Hi,
I am trying to write a formula on each sheet in a range which is not clearly defined on each sheet on the book. excel is complaining my range object and I am not seeing it today (coding too much....). Anyone can point me there?
Sub GenerateAmenities()
Dim ws As Worksheet
For Each ws In Worksheets
Select Case ws.Name
Case "Report", "Amenities"
' do nothing
Case Else
ws.Range(("N2"), Range("A65536").End(xlUp).Offset(0, 13)).Select
Selection.FormulaR1C1 = "=RC[-4]&"" - ""&RC[-1]"
End Select
Next ws
End Sub
thanks,
A2k
Bookmarks