A "go to" formula in VBA with Indirect function

[Dubbelito]

Hi guys and gals,
I would like to record a macro that populates a table I have. The table has data that every time I work with it picks different amount of rows. I pick data from a master table, and depending on some criteria they will appear in this 2nd table. I have a cell where I have counted the number of times this Criteria is fulfilled, or in other words the number of rows that shall be populated.

Now, what I would like to do is basically write a macro that says "start from A3 -> fill down to Nx" where x is the amount of rows needed stated in Cell C1.

Thanks in advance!

[mudraker]

try

Please Login or Register  to view this content.

[Dubbelito]

Brilliant! Thanks Mudraker.