Please help me correcting this code

[ThrottleWorks]

Sir,


I am facing a problem while executing below mentioned code.


Range(short_single). Offset (0, 33) .select


I want select a range by using this code, I am not getting bug, but the code is not executed either.


Short_single is the last cell in column B, this is different every time, that is why I have defined it as short_single

In this example Cell B17 is last cell & macro is correctly showing short_single.


I want to select a range from B17 to AI17, so I have given following code to select the range.


Please help me in this.

 

[Hui]

Sachinbizboy


Instead of

Range(short_single).Offset (0, 33).select


Try:

Range(short_single).Resize(1,33).select

or some derivative of that

 

[ThrottleWorks]

Ian Sir, this has worked, awesome ! thanks a lot for your great support & valuable time. Have a nice weekend Sir.