Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Group,
I have gone through a worksheet that had ID numbers in it and put those IDs in a variable ID1, ID2, ID3...ID10. I am then going over to another worksheet and doing a Find with in a For...Next construct For Q = 1 To 10 Selection.Find(What:=("ID"& Q), After:......... Next Above does not work, although a hard code instead of =("ID"& Q), does work. I have tried varous variations and concantinations to bring in the varible, but have not been able to. ID1, the varaible, contains the number 4, but I can not get that into the search. Thanks, -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using COUNTA for a variable array | Excel Worksheet Functions | |||
use a variable array in a formula | Excel Discussion (Misc queries) | |||
how can I see if an array contain a certain variable? | Excel Programming | |||
about ARRAY variable | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |