| 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 | |||
Hybrid Mode
