Autofill

[Kamranas]

I need an excel VBA code for just 1 row which autofill until the last row .and condition is this it automatically detects the last row.
i hope you will all help me

 

[Michael M]

What do you want to autofill with..formula or text ?

 

[Kamranas]

I need an excel VBA code That auto-fills it down the row until the last row and it detects the last row itself.
i hope you will all help me

 

[Michael M]

Whya VBA when all you have to do is double click on the green square in the bottom rh of cell N2

 

[Kamranas]

What do you want to autofill with..formula or text ?

i just want to auto this text down

 

[Kamranas]

i just want to auto this text down

i just want to auto fill this text down untill last row ,condition is this it automatically detects last row

 

[Kamranas]

Whya VBA when all you have to do is double click on the green square in the bottom rh of cell N2

yes brother I can do this,but I need a vba code which do this because i do this daily basics ,i want to save my time

 

[Michael M]

Don't see the point really, but.....

Range("N2").Copy Range("N3:N" & Cells(Rows.Count, "M").End(xlUp).Row)

 

[johnnyL]

Depending on what your last row # is, it may be faster to bypass the copy command and just use '=':

    Range("N2:N" & Range("M" & Rows.Count).End(xlUp).Row).value = Range("N2").value

 

[Michael M]

still don't see the point though