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

 

[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]

Glad it worked for you.....

 

[johnnyL]

@Kamranas, On the right side of each post in a thread that you have started will be a heart, number, and a checkmark. click the checkmark on the post that you feel best answered your question.

 

[Peter_SSs]

it is working

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[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