M
Mark Stephens
Hi, this is a strange one...the following items reside in column 1 from rwos
1 to 10:
Local cash
Local bond
Local equity
Local property
Foreign currency
Foreign bonds
Foreign Equity
Foreigh property
Alternative
Commodity
My code wants the number of items (i.e. the number of non empty rows:
bNoItems = Sheets(sSheetName & "_Items").UsedRange.Rows.Count
Answer comes back 13 not 10! Also when I try and select it it selects 3
empty cells on the end (aty least it's consistent!). Anyone any idea what
may be wrong/with a better way of achieving the count, thanks, Mark
1 to 10:
Local cash
Local bond
Local equity
Local property
Foreign currency
Foreign bonds
Foreign Equity
Foreigh property
Alternative
Commodity
My code wants the number of items (i.e. the number of non empty rows:
bNoItems = Sheets(sSheetName & "_Items").UsedRange.Rows.Count
Answer comes back 13 not 10! Also when I try and select it it selects 3
empty cells on the end (aty least it's consistent!). Anyone any idea what
may be wrong/with a better way of achieving the count, thanks, Mark