Search results

The attachment with links was intentional. That is how it will appear after the worksheet is moved from the first model to the second. I am sorry you didn't find my elaboration and example workbook sufficient. Thanks anyway.

Thank you for the reply In this case they may or may not be linked from another workbook - this is just an example Understanding that it's ideal to work with colors...in this specific case, I need to. I have macros for breaking external links, etc - was just hoping someone could help me with...

Fairly simple. 1) For the active worksheet, select all cells that have a font color of RBG 0-128-0 2) Copy and paste values for those cells 3) Color those cells RGB 0-0-255 That is all.

Hi there, I'm hoping someone can help me write what (I think) should be a reasonably easily macro to run The scenario is this - I've built a large, complicated roll-up model that kicks out individual cash flows on an asset-by-asset basis into a specified output. This model is too complicated /...

These are both great. Thank you so much.

Hi there, I've attached a sample workbook which should clearly illustrate the problem I am trying to solve. I'd like to be able to rename the individual worksheets in a workbook based on two lists (shown in the same file). I've named both of these ranges. Can someone please help me write a...

Thank you! Works great and I appreciate the detailed example. Very clear. Thanks again!

Can someone please help me write a macro that will change the sign of the actively selected cells, even if a formula is in them already? This works well for hardcoded figures: Sub ConvertValues() Dim rng As Range Dim area As Range Dim c As Range Set rng = Selection For...

It's Microsoft Office Professional Plus 2013. Can't specifically comment on SKU. I've further checked to see if any of the commands are available under the customize ribbon bar, and I can't seem to find anything related to PowerMap even though the add-in is fully installed / present in the...

Can someone please help me write a piece of code that will simply start the PowerMap Com Add-In in Excel 2013? For several reasons, in this circumstance, I am prevented from launching through traditional methods, though the COM add-in is installed on this particular machine. I would greatly...

Actually, I think the easiest way to do this is add them to the array, but just leave out the leading and trailing spaces, so that they are always capitalized. For example, "Ibm" would be written into the Originals Array, and "IBM" would be in the replacements. I think this should pick up all...

Just fantastic. Thank you again! Question about one more condition. If a word is greater than 3 letters or greater and is already in ALL CAPS, is it possible to IGNORE without having to enter the words into the arrays? For example, "IBM" , "AAPL", or "MSFT" and other similarly formatted text...

Thank you for the quick response! This is quite clever. Thank you so much! I will use in practice and follow up with any additional questions. I've run a few test cases and it seems to work perfectly.

I'm hoping to get assistance writing a macro that can change the case of text in selected cells. Ideally, the macro will be able to: Capitalize the first letter of words in a selected range, BUT ALSO Have the flexibility to exclude certain words (like articles and prepositions, such as...

Thank you so much! This is perfect.

Would someone please be able to help me integrate the active window view as a variable into the code below? Effectively, I'm trying to integrate the following logic at the beginning (and later end) of the code: Store the current view of the active sheet as a variable (i.e. xlPageBreakPreview)...

Updated to prevent name errors from creating an alert box when copying the original tab. Sub PasteAsPicture2() Application.DisplayCommentIndicator = xlNoIndicator Application.DisplayAlerts = False Set origSht = ActiveSheet ActiveSheet.Copy after:=Sheets(Sheets.Count) Set NewSht = ActiveSheet...

Would it be possible to add the following condition? Before the image is copied (switch all views to normal view) If the ActiveWindow.View = xlNormalView, Then Keep xlNormalView If the ActiveWindow.View = xlPageBreakPreview, then Switch to xlNormalView If any other view, switch to xlNormalView...

I also two more minor features for anyone interested. Comment indicators are no longer picked up in the image as well The recently created image is also copied to the clipboard after creation (to be pasted into PowerPoint, Word, etc). One could also set this to delete the image from Excel if...

p45cal - this is genius, it works exactly as I had hoped. thank you so much! you are also correct, I should have been more clear with my sample file.

No, it would not. This code doesn't do anything to change the font colors to black. Thanks anyhow, Ben

Made a slight alteration to the code. Now this should only copy and paste visible rows/columns within the selection. One additional issue that I'm having is that I'm unable to keep the row heights the same. Can someone help me 1) prevent the fonts that are already white from changing to...

Sure Narayan - I've attached a sample workbook. I've written the attached code, which is doing exactly what I want it to do, except that it can't handle font colors that should not be changed to black (i.e. white). Sub Test() Dim myCells As Range Set myCells = Selection myCells.Copy...

Understood on the first point. On the second point, there is no way to discern the cells by data in this instance, it needs to be done by color.

Thanks for the reply. The fonts that won't change color are black and white, so it's not just a matter of changing all the colors to black and then deleting the sheet. One would have to actively discern which cells are white and avoid selecting those so they remain unadjusted and aren't made...