Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placeholder in find code
Hi,
Can I use a placeholder in code to execute a find statement? My code currently looks like this; Set rngFound = rngToSearch.find("G25KT") Yet the 25 is a variable number so wanted to express it something like this; Set rngFound = rngToSearch.find("G"& 00 & "KT") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placeholder in find code
Try this:
Set rngFound = rngToSearch.find("G*KT") Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placeholder in find code
Many thanks
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placeholder in find code
Set rngFound = rngToSearch.find("G"& Cstr(VarA) & "KT") "keri" wrote: Hi, Can I use a placeholder in code to execute a find statement? My code currently looks like this; Set rngFound = rngToSearch.find("G25KT") Yet the 25 is a variable number so wanted to express it something like this; Set rngFound = rngToSearch.find("G"& 00 & "KT") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup and placeholder function | Excel Worksheet Functions | |||
Removing Placeholder Values | Excel Discussion (Misc queries) | |||
delete row of text with 3 macros & [placeholder] | Excel Programming | |||
"Show Placeholder" feature in options/view doesnt work | Excel Programming | |||
"Show Placeholder" feature in options/view doesnt work | Excel Programming |