Autofill Variable Range

[efarkouh]

I'm trying to get a variable range to autofill.

More detail:

I'll be working with files that have a variable amount of rows & columns. I'm trying to reach the first column with no text in it and enter text in the first cell. In the second cell I'd like to add a formula and autofill it down to the last row.

Here's what I have so far:

Please Login or Register  to view this content.

The last command (the bit with autofill) is where I'm struggling.

Suggestions?

[karedog]

Hi,

Try this code :

Please Login or Register  to view this content.

[efarkouh]

I get:

"Compile Error:

Wrong number of arguments or invalid property assignment"

on that last line ("Range" is highlighted).

[karedog]

Please look at my attached file.

If you have different layout, then please upload your file.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[efarkouh]

Please look at my attached file.

If you have different layout, then please upload your file.

Seems to have worked this time around. Thanks!

[efarkouh]

Maybe:

Please Login or Register  to view this content.

John, yours worked as well. Thanks. Do you mind explaining the last two lines in the code?

[JOHN H. DAVIS]

You're welcome.

Please Login or Register  to view this content.

used cells as range 1= row, ulc = Last used column in row, offset 1 column = "Vehicle ID"

Please Login or Register  to view this content.

Range from (cells row 2, Lastused Column) to cells(ulr - first empty row in Column A, ulc- Last used column) - Places the formula all the way down.

Hope that helps.

[efarkouh]

You're welcome.

Please Login or Register  to view this content.

used cells as range 1= row, ulc = Last used column in row, offset 1 column = "Vehicle ID"

Please Login or Register  to view this content.

Range from (cells row 2, Lastused Column) to cells(ulr - first empty row in Column A, ulc- Last used column) - Places the formula all the way down.

Hope that helps.

Thanks again, John.

[JOHN H. DAVIS]

Anytime. Glad to help out.