| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
Hi Howard,
Am Thu, 20 Mar 2014 06:14:42 -0700 (PDT) schrieb L. Howard: Sheets("Sheet2").Range("B2").Resize(lRowCount - 1) = myArr that is my bad I did notice that Column AE2 is blank and the blank repeats every 20 rows. Does not affect the copy that your code does. All the blank rows are copied as 5 short phrases instead of 6. More troubleshooting to do. do you want to skip blank cells? Can you send me the workbook? Regards Claus B. -- Vista Ultimate SP2 / Windows7 SP1 Office 2007 Ultimate SP3 / 2010 Prodessional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting blanks as spaces | Charts and Charting in Excel | |||
| Issue removing leading and lagging spaces | Excel Programming | |||
| How to count blanks and spaces that look like blanks | Excel Programming | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Threaded Mode
