Help with MID function

  • Thread starter Thread starter bobh
  • Start date Start date
B

bobh

I'm not an Excel vba person so I don't know why this doesn't work, any
help is appericated
I'm trying to get the first three characters of the value that's in
cell A3 and store it in the GetVal string variable. This keeps
erroring with the message 'Variable not defined' and it highlights the
A3 on the GetVal line

Dim GetVal As String
Sheets("Dollars").Select
Range("A3").Select
GetVal = Mid(A3, 1, 3) <--highlights A3 after error message
If GetVal = "Oct" then
....etc
end if

thanks
bobh.
 
Hi Bob,

Am Thu, 7 Jun 2012 06:37:54 -0700 (PDT) schrieb bobh:

GetVal = Mid(A3, 1, 3) <--highlights A3 after error message
Click to expand...

GetVal = Mid([A3], 1, 3)


Regards
Claus Busch
 
I'm not an Excel vba person so I don't know why this doesn't work, any
help is appericated
I'm trying to get the first three characters of the value that's in
cell A3 and store it in the GetVal string variable. This keeps
erroring with the message 'Variable not defined' and it highlights the
A3 on the GetVal line

Dim GetVal As String
Sheets("Dollars").Select
Range("A3").Select
GetVal = Mid(A3, 1, 3) <--highlights A3 after error message
If GetVal = "Oct" then
...etc
end if

thanks
bobh.
Click to expand...
You needed to use Range("a3") but
========
if mid(Sheets("Dollars") _
..Range("A3"),1,3) ="Oct" then
do this
else
do that
end if

or you could have used INSTR
 
I'm not an Excel vba person so I don't know why this doesn't work, any
help is appericated
I'm trying to get the first three characters of the value that's in
cell A3 and store it in the GetVal string variable. This keeps
erroring with the message 'Variable not defined' and it highlights the
A3 on the GetVal line

Dim GetVal As String
Sheets("Dollars").Select
Range("A3").Select
GetVal = Mid(A3, 1, 3)  <--highlights A3 after error message
If GetVal = "Oct" then
...etc
end if

thanks
bobh.
Click to expand...

Thanks all...
bobh.
 
Back
Top