Jayadev Sarangi
Member
Is there any problem in the below code, its not moving to next sheet. Also please modify to exclude one tab and make the changes in all other active tabs. Its quite urgent.
" Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
Range("D2").Select
ActiveCell.FormulaR1C1 = "LC"
Next sh"
Regards
Jay
" Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
Range("D2").Select
ActiveCell.FormulaR1C1 = "LC"
Next sh"
Regards
Jay