Problem getting cell value from range var

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

Guest

I am running the following test macro code to display content of the first
cell in a verticle single column named range that contains about 20 items and
am getting a q=Error 2042 runtime 13 type mismatch error. How do I get the
first cell content correctly?

q = Range("jde_NewData")(1).Value
MsgBox "x=" & q
 

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

VBA set thick borders around non empty cells in range 0
referencing a workbook using string var = error9 1
Sorting Problem 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Cell values to an array, then array transpose to another workbook 8
copy a range from active cell 6
Arrays and scattered cell values or another way? 16
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Back
Top