El_Diabolo
11-20-2013, 11:32 AM
Hi All,
I have been trying all day to change the format of an existing (successful) statement so that it uses a variable as part of the range definition, rather than being hard-coded. Can't seem to do it. All rather sad. The statement in question is:
If Not Intersect(Target, Range("H8:OFFSET(H8,0,0,COUNTA(H:H),1)")) Is Nothing Then
So instead of having "H8" I would like "H" & FRow, for example. I use this format regularly, but seem unable to manage with the above. Any help would be much appreciated.
Best regards.
I have been trying all day to change the format of an existing (successful) statement so that it uses a variable as part of the range definition, rather than being hard-coded. Can't seem to do it. All rather sad. The statement in question is:
If Not Intersect(Target, Range("H8:OFFSET(H8,0,0,COUNTA(H:H),1)")) Is Nothing Then
So instead of having "H8" I would like "H" & FRow, for example. I use this format regularly, but seem unable to manage with the above. Any help would be much appreciated.
Best regards.