| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove blank rows without hiding them
I have a column of data in a worksheet (50 rows A1:A50). At the moment the data is hard coded i.e. A1=sheet2!ab1,B1=sheet2!ab2, etc. Sometimes there is no data in source cells (e.g. ab15 ,ab19 etc), whic results in many blank rows in the destination worksheet. At the momen I am hiding the blank rows with code, which now creates a problem fo me in extracting data into a Word doc. Is there a way to populate the destination worksheet sheet such tha the rows remain contiguous without any blank rows (i.e. no blank o hidden rows?). Any help much appreciated, please bear in mind I'm new to VBA! Cheers, Pete -- peter.thompso ----------------------------------------------------------------------- peter.thompson's Profile: http://www.excelforum.com/member.php...fo&userid=2968 View this thread: http://www.excelforum.com/showthread.php?threadid=50084 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding blank rows using a macro | Excel Discussion (Misc queries) | |||
| Hiding Rows if Blank cell | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Hiding blank rows | Excel Discussion (Misc queries) | |||
| Hiding Rows with Zero or Blank Values | Excel Programming | |||
![peter.thompson[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
