Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
choose a range to copy paste based on data in the cells
Is this possible? I have a column of data (cloumn E) and that the cells
either have a numeric value or text. I need a macro that copies the column only through the numberic values from Column E to Column J. Once the column switches to text I don't want that section of the column copied or pasted. e.g. 900 600 110 115 105 1800 1550 AM EMINI EMINI I only need to copy and paste the column for the range that has numbers, but the range of numeric values can vary even though the numbers will always be first and start at row 1, I never know when the numeric values will end and the text will start. Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
Copy&Paste variable range based on cell value | Excel Programming | |||
Condition based copy/paste of range | Excel Programming | |||
Condition based copy/paste of range | Excel Programming | |||
Condition based copy/paste of range | Excel Programming |