- Joined
- Dec 13, 2009
- Messages
- 1
- Reaction score
- 0
I’m still new to Excel programming and I need some help with using a range name in a Range.Select Macro.
This macro will increment a cell location on one worksheet (CountNum) which will in turn spit out a cell location to goto (Dbase_Loc).
Public Sub Cust_Dbase2()
Sheets("Accounts").Range("CountNum").Value = Sheets("Accounts").Range("CountNum") + 1
Sheets("Cust_Accts").Select
Here is where I will use the new found cell location (Dbase_Loc) in a Range.Select statement to goto the cell location on the Cust_Acct worksheet.
All help will be appreciated
This macro will increment a cell location on one worksheet (CountNum) which will in turn spit out a cell location to goto (Dbase_Loc).
Public Sub Cust_Dbase2()
Sheets("Accounts").Range("CountNum").Value = Sheets("Accounts").Range("CountNum") + 1
Sheets("Cust_Accts").Select
Here is where I will use the new found cell location (Dbase_Loc) in a Range.Select statement to goto the cell location on the Cust_Acct worksheet.
All help will be appreciated