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
|