Address Property
 

I'm writing a subroutine to find information on one sheet based on another
sheet. Here's what I have so far

With oSheetlst.Range("a1:a1500")
Set c = .Find(CLO$, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address


It will return an Address of $A(row) and this is the correct address for the
search, what I want to do is increase the firstAddress (firstAddress =
c.Address) to $B(row) so the I can update the records on the second sheet.

Mike

Address Property
 

You just got your name added to the Christmas card list....Thanks

"Bob Phillips" wrote:

Do you mean

c.Offset(0,1).Address

--

HTH

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


"Mike" wrote in message
...
I'm writing a subroutine to find information on one sheet based on another
sheet. Here's what I have so far

With oSheetlst.Range("a1:a1500")
Set c = .Find(CLO$, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address


It will return an Address of $A(row) and this is the correct address for
the
search, what I want to do is increase the firstAddress (firstAddress =
c.Address) to $B(row) so the I can update the records on the second sheet.

Mike

Address Property
 

Do you mean

c.Offset(0,1).Address

--

HTH

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


"Mike" wrote in message
...
I'm writing a subroutine to find information on one sheet based on another
sheet. Here's what I have so far

With oSheetlst.Range("a1:a1500")
Set c = .Find(CLO$, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address


It will return an Address of $A(row) and this is the correct address for
the
search, what I want to do is increase the firstAddress (firstAddress =
c.Address) to $B(row) so the I can update the records on the second sheet.

Mike