Search results for query: *

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...

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...

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 need advice on the best way to protect the Excel tools I create and maintain for my company. We have recently had problems with people getting trigger fingers and sending them to clients. The senders just can't say 'no' when a client asks. For this reason I don't think a password would...

I have users who are working in very large workbooks. The books take forever to recalculate due to a large number of offset formulas. To help speed things up I have included and auto-open macro that turns automatic calculation off. The users are happy with this solution. The problem is this...

I'm trying to find a fast way to locate all of my Vlookup formulas and replace them as values. Apparently I left my brain at home today. Can anyone please help? Dim Rng As Range, ix As Long Set Rng = Intersect(Range("a:a"), ActiveSheet.UsedRange) For ix = Rng.count To 1 Step -1...

Greetings - I am writing a report generator and am having difficultites adding a sum formula to the bottom of a range. I have a range of data between H2:X23 (this will change each time the report is run). I can select the range where I need to drop in my formulas via variables...I just...

I have a spreadsheet that does not allow me to use the autofilter option. The tabs and the information contained therein originated in Excel. I was able to autofilter prior to sending them to another user who also kept them in Excel. The spreadsheets are now back in my hands but autofilter is...