Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I use this command to know what will be the next row to use to save th data of the invoice I just printed. The data of every invoice is sav on one line of the data sheet. The problem is that if my DATA sheet is empty, no line used, th command UsedRange.Rows.Count will return 1. If one line is used, it will also return 1. To go around this problem, I put a dummy in the first row. But I don' like it. Any idea on how to fix my problem ? Is there a way to hav UsedRange.Rows.Count return 0 when no line are used? Thanks! Alai -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions | |||
SpecialCells and UsedRange | Excel Programming | |||
UsedRange problem | Excel Programming | |||
UsedRange problem | Excel Programming | |||
Usedrange | Excel Programming |