VBA to run on just 1 sheet

[Keibri]

Hi all,

I know that this may sound really a beginners question, but I am quiet a newbie in VBA writing. I have the following code:

Sub AutoFit()

For i = 1 To Cells(Rows.Count, "D").End(xlUp).Row
Cells(i, "D") = Chr(10) & Cells(i, "D").Text & Chr(10)
Next i
End Sub

I would like it to work only for 1 particular worksheet and not for all the worksheets, say Sheet 1. How can I amend it?

Thanks

Keibri

[PCI]

Perhaps
NOT TESTED

Please Login or Register  to view this content.

[JieJenn]

Add the word Worksheets("Sheet1") to all line before word Cells

Please Login or Register  to view this content.

[Keibri]

Thanks a lot guys that did the trick!!!

Great Thanks