Thread: Placeholder in find code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keri keri is offline
external usenet poster
  
Posts: 34
Default 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")

Reply With QuoteReply With Quote