Help with code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With data in cells A1:A12, in the immediate window, I get:

? Range("A65536").End(xlUp).Row
12
? Cells(Rows.Count,"a").end(xlup).row
12
? Range("A" & Rows.Count).End(xlUp).Row
12
? Range("A:A").End(xlUp).Row
1

Why (in the last case) am I getting 1 ?
Thanks (in advance),
 
The .End(xlUp) starts "searching" from the uppermost cell of the range object
specified. The range object A:A includes A1 so .End(xlUp) starts with A1 and
goes up from there. Hence it returns row=1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run two macros for two different sheets 11
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Open four Wbooks, copy four columns from each to Master Wbook 16
My Never ending ARRAY code problems 18
A simple if <> nn then Msgbox "No Match" 5
Array with many cells from a row but not in order or together 11
Should I be content with the time code takes? 2
Copy columns and paste with blank column between 5

Back
Top