Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Help with Address property in nested loops | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Is there a Filename property in PrintOut property | Excel Programming |