Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Seeing the example may make more sense
MyWBConvertor.Activate Dim MyPath3 As String, MyRange3 As Range Dim MyPath4 As String, MyRange4 As Range MyPath3 = MyWBConvertor.Path MyPath4 = MyWBConvertor.Path Set MyRange3 = MyWBConvertor.ActiveSheet.Range("D25") '2 months ago Set MyRange4 = MyWBConvertor.ActiveSheet.Range("C26") 'Year MyWBConvertor.Activate Dim MyPath As String, MyRange As Range Dim MyPath2 As String, MyRange2 As Range MyPath = MyWBConvertor.Path MyPath2 = MyWBConvertor.Path Set MyRange = MyWBConvertor.ActiveSheet.Range("C25") ' Last month Set MyRange2 = MyWBConvertor.ActiveSheet.Range("C26") ' Year |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Named Cell ranges based upon value of another cell? | Excel Programming | |||
Using Cell Ranges | Excel Programming | |||
Cell ranges | Excel Discussion (Misc queries) | |||
I dentifying cell and ranges using n as in For n =1 to 600 | Excel Programming | |||
Formatting Cell Ranges | Excel Programming |