How to set range to number of rows found?

[ljCharlie]

Here is what I want to do. I ran a function to find the number of rows is filled or has values in it. Then I want to set the range according to this number of rows.

Please Login or Register  to view this content.

Now, the above set code is not working but something that I wanted to do. Is it possible to do something like that in Excel VBA?

ljCharlie

[davidm]

To create a dynamic range in VBA, several techniques are possible but this will get you started. Suppose you want to create a variable Range in Column A, such that the last row with data will be reflected always as the bottom row. Use:

set rng = Range("a1:a" & Range("a65536").End(xlUp).row)

HTH

[ljCharlie]

Many thanks for the help. I'll give that a try.

ljCharlie