shift=xltoleft

  1. C

    Making an idiot proof one step sheet.

    Have data that is being extracted from another source. I need to make it usable by a variety of people (hence idiot proof) so they can just create the data and copy, than open excel and single keystroke to paste etc. as below. User opens excel, Ctrl+Shift+R; •Paste copied data - working...
  2. L

    Help needed with Macro

    Hi Everyone, I am hoping someone can help me with my issue. I am trying to create a macro but there is one part where I am stuck. I need to insert a column, enter in 0 and convert to number with 2 spaces. I am having two issues. 1. if i select the whole column it will add 0.00 all the way to end...
  3. DataBlake

    How To Delete Column S to Last Column?

    I have this code and its not working, can anyone explain to me why? sub test() Dim lastCol As Long with activesheet lastCol = .Range("A1").SpecialCells(xlCellTypeLastCell).Column Columns(17 & ":" & lastCol).Delete Shift:=xlToLeft end with or sub test() Dim lastCol As Long with...
  4. K

    New to VBA and need help with a macro

    Hi, So i am working on a macro that will allow me to open a window in workbook 1 to find an excel report file and then format that report. Once the format is complete it then copies and pastes to workbook 1 to the specified tab so that the original file is not touched or modified. I have 3...
  5. D

    VBA code for autofill until empty

    Hi All, Can you please help me by adjusting this VBA for autofill until empty and not until cell "C346"? Thank you very much!! ' Keyboard Shortcut: Ctrl+y ' Columns("A:A").Select Selection.ColumnWidth = 8.57 Columns("A:A").EntireColumn.AutoFit...
  6. L

    On Error Loop

    Hi good people!, This is my code: On Error GoTo a: Windows("Patron_Actives_Extract.csv").Activate Rows("1:3").Select Selection.Delete Shift:=xlUp Cells.Select Cells.EntireColumn.AutoFit Columns("C:C").Select Selection.Delete Shift:=xlToLeft Columns("E:G").Select...
  7. P

    VBA Help - Deleting Certain Values From Rows

    Hey Everyone, Looking for some VBA help here. Basically I have this disgusting looking output from one of our management systems. I have created code to clean the data up into a presentable table format that can be utilized to draw some analysis. However, in doing so I have brought certain...
  8. 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...

Some videos you may like

This Week's Hot Topics

Top