| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Everchanging number of rows
The count method will not be accurate unless you offset the count by the the start row number being 2. Count is 100 your last row will be 2 + (100 - 1) = 101. this statment is probably giving you the error Range("A2:A & Range("Count")").Select the correct way of writing this is Range("A2:A" & Range("Count").Count).Select I assume that your named range "Count" is a range of cells. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175897 Microsoft Office Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a number of rows based on the number of columns filled bytext values | Excel Programming | |||
| Fill Cells with same number in three rows then skip to next number | Excel Worksheet Functions | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
![joel[_634_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
