Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Help didn't explain this very well, so I figured I'd ask the experts. I'm writing a routine that will copy rows containing exceptions on one sheet and paste them onto a separate sheet so that they can be worked individually. Here is that part of the code: Set wksht = wkbk.Worksheets(2) rownum = wksht.UsedRange.Rows.Count + 1 <more code wksht.Rows.EntireRow(rownum).PasteSpecial The question is that, when wksht is blank, rownum starts at 2 instead of one. Does UsedRange default to cell A1 if the sheet is blank or anything like that? If I have data in wksht.row(1), then rownum is still 2. Am I on the right track? Thanks to all for the insight. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is worksheet.usedrange empty? | Excel Worksheet Functions | |||
finding last row number of UsedRange | Excel Programming | |||
UsedRange problem | Excel Programming | |||
Find Usedrange question | Excel Programming | |||
Usedrange | Excel Programming |