Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Im 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, Ive tried using a variable but that didn't work either Worksheets("1").Cells(C.Address, 2) = "Row" & FromRow Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WORKSHEET NAME = CELL REFERENCE | Excel Worksheet Functions | |||
WORKSHEET NAME = CELL REFERENCE | Excel Worksheet Functions | |||
Reference another worksheet using a cell | Excel Discussion (Misc queries) | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Reference a cell to get worksheet name | Excel Worksheet Functions |