Home |
Search |
Today's Posts |
#17
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
Hi Howard,
Am Wed, 19 Mar 2014 09:11:24 +0100 schrieb Claus Busch: Enter a code line with With ThisWorkbook.Sheets("Title Builder") in case the sheet "Title Builder" is not the active sheet Then don't forget the dots in front of the ranges LRow = Cells(Rows.Count, 1).End(xlUp).Row if all sections in all colors are filled you have more than 12100 rows, otherwise you can have less. 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) |