ehcpieterse
Active Member
- Joined
- Nov 16, 2006
- Messages
- 278
Hi,
I am using the command: lastrow = ActiveSheet.UsedRange.Rows.Count
However, it returns a value of say 35, when I can clearly see that the last row I've used is 3. The command has always worked fine, but is returning these incorrect values lately.
Does anyone know why this is?
I am using the command: lastrow = ActiveSheet.UsedRange.Rows.Count
However, it returns a value of say 35, when I can clearly see that the last row I've used is 3. The command has always worked fine, but is returning these incorrect values lately.
Does anyone know why this is?