L
laavista
I’m comparing values in worksheet 2 against values in worksheet 1. Once
found, I put the cell,column info in the 2nd worksheet indicating where it
was found. This works.
I also want to put cell,column in the 1st worksheet, though, indicating
where it is located in the 1st worksheet. This does not work.
The procedure is in the 2nd worksheet:
Set C = .Find(ReqNum, LookIn:=xlValues)
If Not C Is Nothing Then
FoundAddress = C.Address ' get row & column where reqnum
is found
' the following works
Worksheets("2").Cells(WriteToRow, 2) = "Row" & FoundAddress
' the following does NOT work
Worksheets("1").Cells(C.Address, 2) = "Row" & FromRow
End If
Instead of c.address below, I’ve tried using a variable but that didn't work
either Worksheets("1").Cells(C.Address, 2) = "Row" & FromRow
Any suggestions?
found, I put the cell,column info in the 2nd worksheet indicating where it
was found. This works.
I also want to put cell,column in the 1st worksheet, though, indicating
where it is located in the 1st worksheet. This does not work.
The procedure is in the 2nd worksheet:
Set C = .Find(ReqNum, LookIn:=xlValues)
If Not C Is Nothing Then
FoundAddress = C.Address ' get row & column where reqnum
is found
' the following works
Worksheets("2").Cells(WriteToRow, 2) = "Row" & FoundAddress
' the following does NOT work
Worksheets("1").Cells(C.Address, 2) = "Row" & FromRow
End If
Instead of c.address below, I’ve tried using a variable but that didn't work
either Worksheets("1").Cells(C.Address, 2) = "Row" & FromRow
Any suggestions?