I am trying to write a macro to select I particular range that is below two lists. So the First part of the Macro is this:
Range("A1").Select
‘Bring me to end of 1st list
Selection.End(xlDown).Select
‘Bring me to start of 2nd list
Selection.End(xlDown).Select
‘Bring me to end of 2nd list
Selection.End(xlDown).Select
‘Bring me to start of 3rd list
Selection.End(xlDown).Select
‘Select Upper-Left Corner of List
ActiveCell.Select
??? – How can I name the active cell as UpperLeft?
UpperLeft = ActiveCell???
Range("UpperLeft", Range("B65536").End(xlUp).Address).Select
I don’t know how to get that ??? part? Is it Dim UpperLeft As Range?String?Cell?
Range("A1").Select
‘Bring me to end of 1st list
Selection.End(xlDown).Select
‘Bring me to start of 2nd list
Selection.End(xlDown).Select
‘Bring me to end of 2nd list
Selection.End(xlDown).Select
‘Bring me to start of 3rd list
Selection.End(xlDown).Select
‘Select Upper-Left Corner of List
ActiveCell.Select
??? – How can I name the active cell as UpperLeft?
UpperLeft = ActiveCell???
Range("UpperLeft", Range("B65536").End(xlUp).Address).Select
I don’t know how to get that ??? part? Is it Dim UpperLeft As Range?String?Cell?