Find Cell with variable not known

[MarkCBB]

Hi there,

I am using the following code:

 Cells.Find(What:="Total FNB EFT").Select

But the FNB (sometimes it is Bots or Nabi, and sometimes it is unknow) is different depending on the excel workbook I using, I tried:

 Cells.Find(What:="Total * EFT").Select

but it doesn't find it.

How can i make this line of code more robust?

 

[Andrew Poulsom]

Using the wildcard character worked for me with:

<TABLE style="WIDTH: 71pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=95 border=0 x:str><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 71pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=95 height=17>Total Bots EFT</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Total FNB EFT</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Total Nabi EFT</TD></TR></TBODY></TABLE>

It should work for any text starting with Total followed by a space and ending with EFT preceded by a space.

 

[MarkCBB]

Hi Andrew,

so embaressing I was actually looking for FET not EFT, thats why it wasnt working I have confussed for ages. haha, thank for your assistance one again.

Kindest Regards,
Mark Blackburn