Search results

Hello, Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 7. The code is pretty straightforward, so I am not sure why I cannot see it... Code (vb): Sheets("PRMC").Select Sheets("PRMC").Activate...

Hello, Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 8. The code is pretty straightforward, so I am not sure why I cannot see it... Sheets("PRMC").Select Sheets("PRMC").Activate...

Hello, I need to save selected tabs to a new file and then when finished delete those tabs. I have it all worked out except it is not saving only the tabs I have highlighted it is saving all tabs remaining in the file. Can you please assist me? Below is the code that I am using to save the tabs...

Hello, I have requested assistance on this once before and it worked for .pdf, however now I am trying to save as .xlsx. It is going through the motions, however the file(s) are not there after the fact. Here is the code I am using can you please assist me with the adjustments that need to...

Hello, I need to select the next cell from A1 using a Macro that will use filters for data and then input with drop down to last row. The issue I am running into is that the data will be in different rows everytime. The filter will remain the same and in the same column but it may be in row 9...

Good Morning, I am trying to save a file using the code within a Macro. I will need to do this several times within the macro and I would like to be able to have the Save As box open to the correct folder. I can get it to open the Save As dialog box, but not to the correct path. Can you please...

Good Morning. I am working on a complex formula that I may have found a fix for, but am not sure if/how to apply it. I have data that comes out of another program as a column collection (meaning that it takes several rows of data and combines them into one cell in Excel.) this is causing an...

Hello, Happy Monday... HAHA! Oxymoron.... :rolleyes: I need to add a name to the dialog box that opens with the below code. I do not want it to say "Open". I want it to say "Open Anchor File". Please help. Here is the code. MsgBox Application.Dialogs(xlDialogOpen).Show(arg1:=Filename) I...

Good Morning, I am stuck. Can you please help me?:( I have written this code, but am at a loss as to how to actually make what they enter populate in Cell A2. Or How to make it a mandatory enter, (Loop) Dim Month As String Dim p As String p = "Enter first day of the last...

Good day everyone and Happy Friday! I am trying to build a rather large complex nested IF statement. I have 49 different options that I need to reveiw for in column collection (or single cell) These are listed in the cell as shown below. And since they are in a single cell combined as they are...

Good afternoon. Thank you for taking the time to assist me. I have a chart that I need assistance with please. My chart shows two data points, 1. Actual Score 2. Goal I have 33 different departments that I am tracking, and need for them to reflect in the chart when we meet or exceed the...

Hello, I have a spreadsheet with two tabs. Tab one has a value that is brought in from tab 2 using =IF('Tab2 '!B23<>"#DIV/0!",Tab2'!B23,"-") Oridinarily this would work just fine, however my problem is that the data in Cell B23 is a formula of =B21/B22*100 which will return the solution...