400

The values on the right side of my combo chart are left-aligned as shown below. How do I change them to right-aligned? 1,600 1,400 1,200 1,000 800 600 400 200 100 0

Hello, Can someone take a look at this bad boy and tell me why I'm getting a 400 error? Please assist. Sub Macro1() Dim Rang1 As Range Set Rang1 = Range("A1") Dim Row1 As Integer Row1 = ActiveCell.Row Dim Sumact As Long Sumact = Appplication.SumIfs(Worksheets("ERM ").Range("G:G")...

Hi All, I am not going to paste any codes here, because my question is just in general. There is a VBA code, which is able to open all the Excel workbooks in a specified folder, copy their content from a specified range, and paste them all together in a big list. Files, forms, shapes, even the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would be greatly appreciate to provide me support for a VBA code so that to run through row “1” and where find the words “Count” & “Total” should clear...

Ok I am not sure this will go where I want it to but I am going to try this. I am new to excel and can not figure out this formula, if it is possible. I am trying.... if k20=2 then "22,400" if h23="" then "36,000" if h23=8 then "38,000" if h23=9 then "39,000" if h23 >= 10 then "22,400 each"...

Hello! I am having trouble running a macro that was written to re-name the tabs in a worksheet. It comes up with a box and "400". Now my main source of confusion is that I have the exact same code & references in another spreadsheet and it works 100% fine. Does anyone know what could be...

I keep getting a 400 error when running the code below. This only happens if the code goes to error handler and is then repeated immediately after. Any ideas why? Public Sub OpenDrawing() StopVLookup = True Dim partno As String On Error GoTo errorhandler partno = Cells(ActiveCell.row...

I am hoping this is pretty minor, but I have a macro that I am trying to run, and when I do, it seems to interfere with my selection change code on my sheet. They both work independently, but when they are on the same sheet I have issues. Can anybody help with this? Here is one of my macros...