Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yep, Just tried that code and with a few changes to my ifs ive got it
working a treat, I see you used the cells.find instead of the selection.find and i suppose doing it that way allowed you to put (worksheetname-cells.find etc etc) which must be ensuring that it has the right worksheet, I tried doing it worksheets("name").selection.find but that didnt work and i didnt know about the cells.find. Thank you for you posting GB which i am going to keep re-reading until it sinks in! Many thanks to you both Duncan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I find the series selection tab? | Charts and Charting in Excel | |||
Find Next in a selection, how to stop it when it returns to the fi | Excel Programming | |||
Find selection | Excel Programming | |||
Use of Selection.Find & ActiveCell | Excel Programming | |||
Find the row of all cells in a selection | Excel Programming |