I am trying to use the function offset to select the range of B:H Only
But when I use the offset function, the range becomes B:I.
Is there a way to unoffset the offset
Usually with the keyboard shortcut I use, Shift+Right
Please Login or Register to view this content.
Why do you need to use offset at all in this case? Is column H the last column with data?
Generally speaking, if you need to offset to the left, you can use negative numbers, ie
I'm not sure I fully understand your question, thoughPlease Login or Register to view this content.
That's correct, Column H is the last column with data, but I am trying to write a Macro that will be universal for all other workbook.
So I'm trying to select the range from the last column to Column B only.
If I use the offset function, it includes column I in the range.
Also I get an error when I try to offset it by -1
Please Login or Register to view this content.
Last edited by Jerseynjphillypa; 08-03-2012 at 02:56 PM.
if you always want column B then
assuming you really need to select for some reasonPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks for the help.
How would I be able to select the range up to Row 5 only if I started from Row 17
So I'm looking for B5:H17 only for my range based on the code you provided above
I believe this worked
Please Login or Register to view this content.
Last edited by Jerseynjphillypa; 08-03-2012 at 03:06 PM.
I feel like there are a lot of steps in there to select the cells B:LASTCOL in the LASTROW. Try this code instead. Less lines:
Please Login or Register to view this content.
just replace selection.row with 5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks