| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a macro to copy first cell down until next cell has data
I need help writing a macro to take the first cell in a particular
column that is not blank and copy it down until the next cell tha does have data and keep doing so until the end of the spreadsheet. Any help would be appreciated. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing a macro to copy first cell down until next cell has data
Use this Gerald
http://www.contextures.com/xlDataEntry02.html -- Regards Ron de Bruin http://www.rondebruin.nl "Gerald" wrote in message oups.com... I need help writing a macro to take the first cell in a particular column that is not blank and copy it down until the next cell tha does have data and keep doing so until the end of the spreadsheet. Any help would be appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing a macro to hide columns based on cell value | Excel Discussion (Misc queries) | |||
| When writing a macro in excel workbook, how do I refer to ea cell | Excel Programming | |||
| I need help writing a macro to replace cell contents. (new to VB) | Excel Programming | |||
| Writing Macro - How to get the cursor/Active Cell back to top of W | Excel Programming | |||
| Writing variable from a Macro to a Cell | Excel Programming | |||
![Gerald[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
