Syntax for Range Reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a macro I have a string variable (macroName) that is set to the name of a
workbook. In the macro I am trying to retrieve information from the second
worksheet of that workbook while another workbook is active.

I have tried variations of the following syntax, but can't get either
statement below to work.

ColumnID = Workbooks(MacroName).Sheets(2).Cells(1, _ NumColsMacro).Address
NormalHomeRng = Workbooks(MacroName).Sheets(2) & "!$A$1"

Could someone please give me the correct syntax for these two lines?

TIA.
 
Not sure on the first one, as I don't knowm what _NumColsMacro is and why
you get the cell address, but it seems okay.

For the second, try

Set NormalHomeRng = Workbooks(MacroName).Sheets(2).Range("$A$1")


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Error in 2003 6
Run code from another workbook 7
Need syntax for RUNning a Word macro with an argument, called from an Excel macro 3
Filename leads MacroName 4
Autoshape Macro 4
Create button with addin/reference macro in another file 2
Macro execution changes filename reference for all macros 1
How to properly read Value2 Range ? 5

Back
Top