Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is this possible to set mutiple variables with a loop? I want to go
through a range and for each found item I want the variable set. Here is what I was thinking, but obviously it does nto work. Dim Con1 as Range, Con2 as Range, Con3 as Range etc... For X = 1 to 6 if not Range("A1:A50").find(what:=X & "* Convert", Lookin:= Xlvalues) is nothing then Con & X = Range("A1:A50").find(what:=X & "* Convert", Lookin:= Xlvalues) End if Next X Any help woudl be greatly appreciated, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
Confused about setting up functions based on variables? | Excel Worksheet Functions | |||
Use a loop to create multiple Charts - Suggestions ? | Charts and Charting in Excel | |||
VLOOKUP loop multiple times | Excel Worksheet Functions | |||
Setting up some sort of cutting and pasting loop | Excel Worksheet Functions |