mirko
03-03-2008, 09:36 PM
Hi folks,
I have a quick (and probably easy for most of you) question.
I want to name a range in Excel (e.g A1:F19) but the range can change according to the number of entries the spreadsheet has.
This is what I have now:
With Worksheets("PropSurveys").Range("a1")
Range(.Offset(1, 0), .End(xlDown)).Name = "Locations"
End With
This will just get the range from A1 all the way down. How can I change it to take the range from A1 to F1 and all the way down?
Thanks a lot for the help.
I have a quick (and probably easy for most of you) question.
I want to name a range in Excel (e.g A1:F19) but the range can change according to the number of entries the spreadsheet has.
This is what I have now:
With Worksheets("PropSurveys").Range("a1")
Range(.Offset(1, 0), .End(xlDown)).Name = "Locations"
End With
This will just get the range from A1 all the way down. How can I change it to take the range from A1 to F1 and all the way down?
Thanks a lot for the help.