Hi,

I have a macro that seems to work fine from A to Z.
I'm now trying to make it more elegant and slimmer.

- The first thing it does, it selects a table (with daily_updated data for only one
day), selects a specific sheet, highlights all the used cells from column A to
BP or so and copies the whole thing to a file called "always_current".
=> I would like to just skip this step as I can just as well generate my formulas
and calculate the values I need directly in that file.
<=> But that file has a number of hidden rows at the top (between rows 1 and
x) which are not counted - I don't know what is in those rows, but that
seems to be correct.
=> The nr. of rows which are hidden varies from day to day so that I wouldn't
know which row to paste the formula I need.

Can somebody tell me if there's a way in VBA to select the first not_hidden row > 1?

Thanks a lot!

Best regards,



Officer_Bierschnitt