activewindow.scrollrow

  1. V

    Macro help

    Hi, I have recorded the below macro. However it is taking loads of time to run. Is there a way to ensure macro will delete old data on the file (with click of a button) and let the user start a fresh. Same time it won't take time to run. The vlookup should be done only if columns C as value...
  2. M

    Paste several worksheets into one worksheet

    I used to have this working but then we made changes. Can you help me? this macro opens up and pastes each sheet into one sheet. Sub Aisles() ' ' Aisles Macro ' ' ActiveWindow.ScrollRow = 50 ActiveWindow.ScrollRow = 48 ActiveWindow.ScrollRow = 46 ActiveWindow.ScrollRow = 43...
  3. O

    Scroll to SheetChange..

    Hey everyone, I would appreciate some help on using the sheet change event with scrolling. For instance, how would I Scroll to the target cell that triggered sheet change event. One way to achieve is to use the following two lines ActiveWindow.ScrollRow = Selection.Row...
  4. N

    Macro to Scroll to Named Row

    I'm using ActiveWindow.ScrollRow = 3 in a macro to take me to the top of a long list of data. The list of data is always changing so I've named the last row "BorderLastRow". Can ActiveWindow.ScrollRow be used to take me to the bottom of the list? There is additional information below...
  5. A

    VBA for Text to Column and Vlookup and Concatenate

    Dear Experts, Not able to add an attachment. Working on a code that can fetch file name from local drive and rename it. Have break inrto 3 codes. 1. Fetching file name 2. Getting the new file name 3. Renaming in local drive. Macro 1 & 3 are working fine but facing issues with macro 2. I...
  6. G

    Not Able to Specify Range I want as the range keeps changing Please Help Me

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

    ever changing worksheet tab

    good day , I have a workbook with several tabs . I created a macro that will 'blank' applicable cells & then prompt a message to insert a date. below is the code:- Sub blanksheetsall() ' ' blanksheetsall Macro ' ActiveWindow.ScrollRow = 2 ActiveWindow.ScrollRow = 3...
  8. M

    Macro to insert formula

    Hi, I inserted a formula into a macro to start in cell H2. It worked in my test sheet, but in the working sheet nothing happens. Please tell me what I'm missing! The formula to go into H2 and copy down is - =IF(T2<>110,"Incorrect amount billed; to be investigated. Comp fee...
  9. S

    Inserting a Formula into my macro

    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"...
  10. V

    Need help understandig why something works in VBA, and something else doesn't

    These work: Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveSheet.CommandButton1 .Top = ActiveWindow.ScrollRow * Rows(ActiveWindow.ScrollRow).Height - 14 End With End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim intCellHeight...
  11. Vgabond

    Remove front Value ( EG : Status = ) and make it a Header Name

    Gurus I have a data from Column A to Column BB. The data can go up till 500,000 lines or more. I have record a macro for the changes that I've done. The macro works pretty well but it run really slow which I believes due to it has a lot of redundant code that can be simplify to make it faster...
  12. C

    Is it OK to delete all the ActiveWindow.SCROLLROWs ??

    I'm tempted to delete a large chunk of this code (scrolling) but want to make sure I understand it and know it is ok... When recording a macro, I notice this often "ActiveWindow.ScrollRow = xxxxx" and wonder if it would hurt anything if I get rid of it... (references of Row 65387 through Row 1)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top