VBA to select visible cells with some other cells that are hidden

Hello, could some one please help me with the following?

I have been trying to use VBA to select the visible cells of my Excel 2003 worksheet named: 1 Mth. (it contains dummy-data).

In the attached workbook there are some hidden cells at AA59000:AJ59200

Please note that the visible data shown in the attached workbook will vary in size each time I run my macro.

What I need:

I need please to be able to use VBA to select the visible cells so that I can format the data.

If any one could please help, it would be greatly appreciated.

Kind regards,

Chris

longbow007;

First, if the cells are hidden, what difference does it make how they are formatted? That said:

Please Login or Register  to view this content.

Hi foxguy, thank you for you valued assistance - much appreciated. I am currently getting a RunTime Error 424 (Object Required) when the macro tries to execute the following code:

Please Login or Register  to view this content.

Also, is it possible to change the with statement to include the current active sheet.

My apologies, sorry I did not make myself very clear in my original post, but I only need to format the visible data, not the hidden data

Lastly, I added another parenthesis to the following line of code as I was getting an error:

Please Login or Register  to view this content.

Cheers,

Chris

E.g.,

Please Login or Register  to view this content.

Please don't quote whole posts -- it's just clutter.

Hi shg, sorry I keep replying with whole posts, I simply do not know any other way of replying so that I can post code properly using the Wrap

Please Login or Register  to view this content.

However, after running this code, it only selects the visible data in column A.

My data is visible from column A to column U.

I am unsure as to why this is happening?

Could you please help?

Kind regards,

Chris

Just press the Reply button instead of the Quote button.

My code was a simple example to illustrate that you don't need to select to do almost anything:

Please Login or Register  to view this content.

I do not have access to the usual set of tools

Tools? The button with the pound sign?

Lacking that, put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after.

Those cells are visible, right?

For visible cells in the used range, see the change in the prior post.

Longbow,

the visible cells in the attached workbook have the range: A1:U51

If you're referring to the only workbook you posted in this thread, the visible cells are a lot larger than that -- they are all the cells you can see. Line 59200 is the only line I see (at a glance) that's hidden. The used range on the worksheet is A2:AJ59200.

One way to capture the range A1:U51 is

Please Login or Register  to view this content.

You need some way to describe the range of interest that Excel understands.

Please Login or Register  to view this content.