Select User Definable Number of Cells in a Column

[HangMan]

I have this code, which allows me to select a cell, run the macro and then enter the number of blank rows to insert below the selected cell. Is there any way to adapt this, using the same principal so that I can select a cell, run a macro and then enter the number of cells I'd like to select in the same column?

Please Login or Register  to view this content.

Many thanks...

[benishiryo]

hi HangMan, try:

Please Login or Register  to view this content.

[HangMan]

Hi benishiryo,

Thanks for your reply, however, that wasn't quite what I was looking to do. I want to be able to select a cell, say C5, then run a macro where I can enter a number, e.g. 10 and for that macro to keep cell C5 selected and to also select the ten cells below C5 so that cells C5 to C15 are now selected...

[benishiryo]

ohh, just selection within the column? how about:

Please Login or Register  to view this content.

[HangMan]

Hi benishiryo,

That works perfectly, brilliant...
This will be a major time saver, thanks so much...