Hi All,

I am using Excel 2010, 32-bit.

I made a post yesterday about using "Quotes within Quotes", which was answered very neatly by "mancubus". Having been given a solution I then persevered, in an attempt to understand where I had gone wrong, with the original task of trying to use a variable within the OFFSET property, rather than having it hard-coded. I have now reached the point where the syntax I am using seems to be acceptable, but I am getting the dreaded '1004' error. Whatever is wrong here is beyond me. I enclose the code I am using below. The sheet is brand new, not protected and contains month names in H1 thru H12. Nothing else. The statement in the code which is commented out works, but the statement using the variable within the OFFSET causes the error. Any help would be very welcome and may just save my sanity.

Sub TestRange()Dim FRow As Integer
FRow = 1
  Range("H" & FRow & ":" & "OFFSET(""H"" & FRow,0,0,COUNTA(H:H),1)").Select
' Range("H" & FRow & ":" & "OFFSET(H1,0,0,COUNTA(H:H),1)").Select
End Sub
Many thanks.