Vba Cell Address Question

  • Thread starter Thread starter MJSlattery
  • Start date Start date
M

MJSlattery

I am attempting to direct a macro to copy data. It does not like my
attempt to define where the cell is. That is not a hard address.

How do you use a calculation from another cell as an address.

VBA compiler does not like ADDRESS(8,D5) or CELL(8,D5) or $D5.

What is the correct way to set an indexed cell address?

Thanks,

Michael
 
You mean like Range("D5").Address or Cells(5,4).address -- --- will get
you $d$5
 
You must log in or register to reply here.

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

Help with another formula, please 3
Forms Check Box cell link 4
Excel Macro to automatically go to the right of the last colored cell 0
Not working: Conditional Formatting 5
Count occurrences of a substring in an array 4
Where to put quotes in a SUMIF formula and when is & used for cell 2
compare for high with two or more cells and then flag. 1
hiding or showing rows based on a cell value 6

Back
Top