Select cells based on certain number of rows and columns...

dpmicka · Mar 30th, 2004, 08:05 PM

I'd like to set up a macro or some code that would select a range of cells that is 8 columns wide by 15 rows high and copy it to clipbaord no matter what particular cell is selected at any given time I might run the macro. In other words, if I had cell A2 selected and I ran the macro, cells in range A2:H16 would be selected then copied to clipboard. If I happened to be in cell K20 and ran the macro, then range K20:R34 would be selected then copied to clipboard. I hope I explained this clearly enough - any ideas???

Mar 30th, 2004, 08:05 PM	#1
dpmicka Join Date: Jun 2002 Location: North Carolina Posts: 119	Select cells based on certain number of rows and columns... I'd like to set up a macro or some code that would select a range of cells that is 8 columns wide by 15 rows high and copy it to clipbaord no matter what particular cell is selected at any given time I might run the macro. In other words, if I had cell A2 selected and I ran the macro, cells in range A2:H16 would be selected then copied to clipboard. If I happened to be in cell K20 and ran the macro, then range K20:R34 would be selected then copied to clipboard. I hope I explained this clearly enough - any ideas???

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode