select range using offset or resize property

[longhorn23]

Hi!!

So in my sheet, I have selected column D. And I want to select the next 4 columns (including column D), so that my selection or active cells at that point would be Columns D, E, F, G and H.

All help is very appreciated! THanks!

[JBeaucaire]

I wouldn't recommend the "selecting" process at all, it's 99% unnecessary in VBA. You can define a range and address commands to that range directly.

But to answer your question. If you have "selected" a column and wish to resize that selection to a total of 5 columns:

Please Login or Register  to view this content.

[longhorn23]

I wouldn't recommend the "selecting" process at all, it's 99% unnecessary in VBA. You can define a range and address commands to that range directly.

But to answer your question. If you have "selected" a column and wish to resize that selection to a total of 5 columns:

Please Login or Register  to view this content.

Thanks for the reply!

The way it works is that, I have a listbox which has a few values in it. The code goes into sheet1 and searches for those values and offsets or resizes to the amount of values that are stored in the listbox.

For example, if I have a 4 values in the listbox with the first value being in Column B. It should select columns B, C, D, and E. (i.e. selecting a total of 4 columns since there are 4 values).

I think your code is working though. I used the same code, but instead of resize I was using offset.

[royUK]

Not sure what you mean. What type of ListBox?

You might want

Please Login or Register  to view this content.

[longhorn23]

Not sure what you mean. What type of ListBox?

You might want

Please Login or Register  to view this content.

I figured it out. Thanks for hte help!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.