how to count rows (1 Viewer)

[exaccess]

HI Experts,
I have two quite simple questions:
what is the statement for finding the number of rows with at least one field filled. Similar question for columns, but this time first I want to know to know the column label together with its number as integer. Secondly using these two numbers I want to define a range in which I will do the rest of the project. Here is code that I tried. But it does not work:

IMAXC = ActiveSheet.Cells(Rows.Count, "F").UsedRange.Rows.Countset
IMAXR = ActiveSheet.Cells(Rows.Count, "F").End(xlUp).Row[CODE]

[/CODE]
I know the code looks stupid, but I am perplexed and confused. Could anybody help please

 

[JHB]

I think you've a better change to get a proper response if you post in the Excel - forum.

 

[arnelgp]

your range address will be:

debug.print ActiveSheet.UsedRange. Address

 

[exaccess]

Hi Experts. Due to internal reasons this project has been abandoned. Thanks a lot for those who tried to help with all their good will.