How to work with varying columns

[jayflay]

Hello,

So working with varying lengths of rows in macros is easy.

You can always add numbers together. however, how can you vary columns based on a number?

for example, i can always do things like the following to change the number of rows selected in a column based on the variable numRows.

Please Login or Register  to view this content.

However, say you're on the same row, and want to select a bunch of columns based on a variable (say numCols)? How can i do that?

Thanks

[Leith Ross]

Hello jayflay,

Welcome to the Forum!

Based on your example with the ActiveCell, I would use the range Resize method...

Please Login or Register  to view this content.

[jayflay]

HA!!!

THANKS!!!!

that was easy, i spent like 2 hours trying to figure this out.