Can I use a Wildcard in "Special* so it finds any cells that have the word Special eg. Special Item, Special Deal, Special SalePlease Login or Register to view this content.
Thanks In Advanced
Can I use a Wildcard in "Special* so it finds any cells that have the word Special eg. Special Item, Special Deal, Special SalePlease Login or Register to view this content.
Thanks In Advanced
Hi,
Not as far as I'm aware.
I'd be inclined to use an initiial IF test. i.e.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi,
This should work...
If you are not keen on using the "calculative" way in the Case statement, I think the only other way is to replace the Select case with an If...ElseIf...End If structure and use the condition similar to:Please Login or Register to view this content.
Please Login or Register to view this content.
Regards,
Rudi
Thankyou so much for all your help. Works like a dream but a little slow could you give any pointers of how to make it go faster.
Please Login or Register to view this content.
I second Richards reply.
My initial response to your question was to help with the wildcard search, but based on the code you posted and the extra search and formatting you are doing, I'd tend to go the conditional formatting route. Its very flexible, easy to modify and will by fast and dynamic on the sheet. It's worth considering and experimenting with it. I'm not sure if there is much else we can do to the code to speed it up further.
Maybe I can ask: Is it necessary to scan every cell in the range P5:BS700? Do these terms occur in ANY cell in this range or is it only specific columns. If we can minimize the amount of cells it must scan, it can significantly increase the speed.
Thanks for your suggestion. I am using the vba macro as I am inserting rows from another to this worksheet on a daily basis and I started using CF but it seems to mess up when I start moving rows around.
I might have another look at CF if you both suggest it will make my worksheet run faster.
If you are bringing in data from another sheet or workbook, you could also experiment with the following to avoid issues with CF:
Scenario 1: New data between existing data...
Insert new cells or rows between the existing data that has CF (the data you copied will be pasted into these new cells/rows)
Paste (as values) the copied data into these new cells, so that it does not overwrite the CF in the existing cells.
The CF should kick in straight away since the CF is applied to cells/rows inserted between existing formatting.
Scenario 2: New data below existing data...
Paste the new copied data below the existing rows that have CF
Activate the CF dialog and adjust the range to include the new added data. (See image below)
1.jpg
Last edited by RudiS; 04-23-2014 at 12:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks