Is it possible to make my macros a BIT shorter by defining "Sheets("sheetname")" as a variable in my macro? I know i can use:
variable=activeworksheet.name
then :
worksheets(variable).select
but i cant do it like this?:
Sub test()
Dim DataSheet As Worksheet
Dim CurrFile
CurrFile = ActiveWorkbook.Name
DataSheet = Worksheets("DataSheet")
BackUpRange = DataSheet.Range("a1:a5")
end sub
Just wondering, thanks
variable=activeworksheet.name
then :
worksheets(variable).select
but i cant do it like this?:
Sub test()
Dim DataSheet As Worksheet
Dim CurrFile
CurrFile = ActiveWorkbook.Name
DataSheet = Worksheets("DataSheet")
BackUpRange = DataSheet.Range("a1:a5")
end sub
Just wondering, thanks