Selecting area from a5 untill biggest cell

[Juhanen II]

Hi all,

I want my macro to select area starting from a5 and stopping to a cell covering biggest column and row value.

I have found the code below to look for the biggest cell, but I don't know how to select the area beginning from a5 ending to this biggest cell.

Please Login or Register  to view this content.

Hope someone can help me out with this simple question.

Best regards,

Juhanen

[royUK]

By biggest cell, do you mean the last cell in the data? The simplest way would be:

Please Login or Register  to view this content.

[Juhanen II]

Hi,

By biggest cell I mean the cell which column AND row is equally big as the last used row and column in the sheet.

And thanks for the code, but it doesn't seem to work properly. However I figured out how to use LastRow and LastColumn values from my code.

So the code which does this when I include it to my first post (see also the code in my first post) is:

Please Login or Register  to view this content.

Thanks, everything is clear now

Juhanen