activewindow.scrollcolumn

Hi All, I'm trying to show the inverse percentage of a number, and I am struggling to figure out how to do it. Can you please give a it a look and let me know if you can help me. So basically what I'm trying to achieve is if its comes up as 99% I would like it to show as 1%. Here is the Macro...

Hello I have a worksheet where I have a list of accounts that will expire on different dates every month. I'm trying to create a VBA Macro to automate this and will filter a list then copy it to a separate sheet for ease. What I have so far is (I'm new to VBA so recorded a Macro to get...

Hi all, I have a dashboard that was changing column format when i refresh the data connection so have had a crack at recording a macro. i have no prior experience using macros and simply recorded steps (purely to amend col. formatting on opening of file) to give me the following. However when...

Hi, My objective is to select a worksheet which has several columns, and I need to filter a specific column for true values; then i need to copy some columns (not all), therefore I am hiding these and paste it into another worksheet. The recorded macro i have does the job but it sometimes...

Czy możesz mi powiedzieć, jak powinien wyglądać poprawny kod i gdzie popełniam błąd? Mój kod to: Sub Dowodcy () ' ' Dowodcy MAKRO " Jeżeli jest to wartość ( "C2") = Wartość ( "BA2"), a następnie Range ( "J3: AN4"). Wybierz Application.CutCopyMode = False...

I'm trying to set zoom level as well as each sheet having the last empty cell selected. I have a button on each sheet which manually selects and scrolls to the last cell using:- ActiveSheet.ShowAllData Range("Table1").Cells(1, 2).End(xlDown).Offset(1).Select...

Hopefully an easy one. This is a code that seems to work most of the time, but will randomly throw up the error in the title. Code is below. It gives the error at the Selection.Insert Shift:=xlToRight line. I'm in Excel 2016, I can only image that's what is causing this, but I'm not an expert...

Hello Guys, I am New to Excel Macros this is the first time I have created a big code which I want to use for a file every week and the data gets updated often Please find the full code that I have written below. Sub CallMacros() Unmerge TurningOffWrapText ShrinkToFit...

Range("E7").Select ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-1],RC[24],RC[25])" Range("E8").Select ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Range("E7").Select Selection.AutoFill...

With rows of data of a few thousand this runs in under a minute. However the data is now just over 100,000 and the macro makes excel not respond. Can anyone help. thanks Sub DailyToMaster() ' ' DailyToMaster Macro ' Ctrl+Shift+Z ' ' Keyboard Shortcut: Ctrl+Shift+Z ' Application.Calculation...

I have been running this spreadsheet with the current macro "Outliers" for the last several months. I was using an older version of excel (1997 - 2003). The macro has worked fine. I just upgraded to Office 365 and saved the current workbook as an "Excel Macro-Enabled Workbook. Since I made...

Hi, I am getting Compilation error in the Sub Sort_Combined_Sheets() Macro code in the highlighted line. Will some one help me in correcting / refining the code Sub club Combined() and Sub Sort_Combined_Sheets() codes please. (First it has to combine and the sort left to right. Sub Combined()...

I am looking to some help to understand why i am having an issue with a recorded macro. I want to hide multiple columns and have recorded a macro as below. My problem becomes that when I run the macro, it hides all columns from R:AZ but there are specific column i want left un-hidden. Sub...

I have created a macro that copies a concatenated series of cells then runs 'text to columns' on it. I want to repeat this process using the same cell to copy from (the text will change) but copy into a different cell i.e. the first time I run it I want it to start in E2 but the next time may...

Hi good people!, I have a very serious problem...Something happened while working on a spreadsheet which is causing me great headache. All I did was create a macro button with this code: ActiveSheet.Shapes.Range(Array("Rounded Rectangle 11")).Select Columns("AD:AF").Select...

Complete Macro Newb, so I apologize for my ignorance. I know what the problem is, I am just not sure how to fix it. I am filtering one spreadsheet (Utilization Report) by a specific Client, Copying all columns and pasting into another workbook (Book 1). Each Client has its own tab by name in...

Hello Everyone, I have a recorded a short macro and was wondering if anyone can tell me how to run it simultaneously on 10 different excel documents or workbooks? I have Excel 2010. The macro Is as below - Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+a ' Cells.Select...

Hi all, I wish (at some point) for the user to click on the tab for the sheet called RANK. When clicked, I wish UserForm3 to appear with six Command Buttons, each to do something slightly different. simple enough ... Private Sub Worksheet_Activate()UserForm3.Show End Sub If the user...

I am having a hard time inserting this formula into my macro, keep getting a debuggin error. My Macro is this Sub HWI_INV_CODES() ' ' HWI_INV_CODES Macro ' ' Range("A1").Select Selection.AutoFilter ActiveSheet.Range("$A$1:$BX$29470").AutoFilter Field:=6, Criteria1:="HWI"...