[ExcelVBA] Indirect() in VBA

 

I know I've done this before, but I've got over 300,000 lines of VBA code I over 80 applications and I haven't been able to locate it.

Basically, it's a VBA  equivalent to the Excel indirect() function.

I have a series of Excel ranges.

I've created VBA variables that are the same name as these ranges.

Rather than manually enter 10 or 15 lines like:

RangeName = activesheet.Range("RangeName").Value

I'd like to create a loop similar to:

    For Each nField In Array("Report_Date", "Time_Start", "Time_End", "Rep_Author")
        indirect(nField) = Range(nField).Value
    Next nField

But I cannot quite recall how to make that work.

Does anyone recall something like this?

thank you,

Paul

__._,_.___

---

Posted by: schreiner_paul@att.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___