Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you create a Set on Excel?
Here's what I'd like to do:
I'm planning on using the same file on several different tables, that all have the same data but may have the different columns labelled differently: Find Column that has the Rate Assign Column with Rate as RatesColumn The column with the Rate will be the column with a label in this set: (rate, level, %, repo) How can I create a Set of some sort which I can then use when running Find and just say, if value is in Set then its True. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you create a Set on Excel?
Dim rng as Range, rng1 as Range, rng2 as Range
set rng = Rows(1) set rng1 = rng.Find("rate") if not rng1 is nothing then set rng2 = rng1.EntireColumns else msgbox "Column not found" end if -- Regards, Tom Ogilvy "hfazal" wrote: Here's what I'd like to do: I'm planning on using the same file on several different tables, that all have the same data but may have the different columns labelled differently: Find Column that has the Rate Assign Column with Rate as RatesColumn The column with the Rate will be the column with a label in this set: (rate, level, %, repo) How can I create a Set of some sort which I can then use when running Find and just say, if value is in Set then its True. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
Can I create a userform in Excel to create an appointment in Outlo | Excel Programming | |||
create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
Create dictionary of terms, create first time user site | New Users to Excel |