Recent content by miwoodar

Greetings all! I'm trying to write a find/replace script that will look at two columns of info in a single range on a single tab. If the script finds abc in the first column and the second column says xyz the script will find all occurances of abc in the entire workbook and replace them with...

These solutions are a lot easier than the path I was going down! Thanks guys - I got it to work. ____________________ Mike

Thanks Skip - I dropped it into the sheet but the sumproduct idea didn't seem to work...I'll play around with it more in the morning when I'm fresh. Your comment regarding the source data is well taken. Unfortunately, the spreadsheets I'm working with are large tangles of engineering...

Ugh! I can't seem to crack this no matter how hard I try and how much I search. If anyone has a good idea or solution, could you please help? I'm trying to find a way to summarize a work breakdown structure. I have a single column of data and as many formula columns as I need. Possible...

Oh - and I never found a good way to address the custom formats (I stopped counting at a half dozen). ____________________ Mike

So I got this to work...sort of. Here's what I ended up doing before I abandoned the effort. It took about 2 minutes to go through all 15 sheets with the calculation and screen updating turned off. As a result, I ended up removing all dollar signs and all pound signs then added a cell to the...

Like this? It doesn't appear to work. Application.FindFormat.NumberFormat = "[$$]" Application.ReplaceFormat.NumberFormat = "[$£]" Cells.Replace What:="", Replacement:="", LookAt:=xlPart, SearchOrder:= _ xlByRows...

This works until I get to the endless possibilities of custom formats. ____________________ Mike

You guys are talking right over my head. I only get a chance to write code for about 20 hours every other month. It's not in my job desciption but I realize it's usefulness and can usually write meaningful code without asking for help. I don't know how to build and array or make use the...

I'm sorry but where are you telling me to look exactly? I checked the help file - not very helpful. I also looked via the browser window. Is there a better place to learn more about this? ____________________ Mike

I can't do it by columns - the sheets contain many interspersed supporting calcs to calculate the quantities. I'll look at the number format property. Will that let me distinguish between the quantities and the costs? ____________________ Mike

Greetings - I have a number of cost estimates that I am trying to convert to a different currency (US Dollars to UK Pounds). The math is done...now for the formatting. The sheet has thousands of cells that have not been formatted in a similar manner. Some have a currency format, some have an...

I'm just getting back around to doing this project. Someone in my office recommended we try Windows Rights Manager for this instead of the options listed above. Would anyone here on the board think the above options are still a better solution? I am more interested in protecting the actual...

Longhair - Was this supposed to be a new thread? ____________________ Mike

Thanks, very helpful information. I'm hoping to stifle the crowd of users who expect it to 'just work'. I will give it a crack next week. ____________________ Mike