Get value in a cell

G

Guest

How can I get the value from one cell (row=1, column = 14)? I need the value
from this cell as the upper limit for a loop.
I have the following code, but it is not working:

cMaxRows = Worksheets("Complete").Cells(l, 14).Value

I have the following error:
Run-time error '1004': Application-defined or object-defined error.

Can anyone help me with this? Thanks in advance.
 
J

JE McGimpsey

Incidently - that's exactly why you should have

Option Explicit

at the top of every code module.
 

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

how to set external cell value? 0
Columns("C:C").Value = Columns("D:D").Value not working after adding16th page 18
Excel VBA 1
Run-time Error '1004' 1
Run-time error 1004 8
Creating a formula in VBA with quoted strings 1
Application-defined or Object-defined-error when changing color in 1
Excel VBA help: Text file formatting 19

Top