selection.cut

Hello: I'm trying to avoid using the Select method, so I'm trying ActiveCell. But I've heard I should try to avoid using ActiveCell as well. :confused: Any ideas on firming up this code? Here's what I have: Using Select Range(Selection.End(xlToRight), Selection.Offset(0, 7)).Select...

My boss (not a spreadsheet man :-)) has created the following code to move some data around his spreadsheet, to be honest I'm quite impressed he has got this far! I am going to improve it when I get chance, but an immediate issue is when the code runs, the last cell of excel becomes T1048574...

Hello, I have this Macro and I need it to repeat until there are no more lines. the tricky part is that the macro creates 6 new rows each time. also how can I make it delete the rows with zero balance? thank you Sub Create_Rows() ' ' Create_Rows Macro ' ' Keyboard Shortcut: Ctrl+q '...

Hi, I have a macro running which includes this information below. When the macro runs I get this error: Run time error '1004' The pivot table field name is not valid. To create a pivot table report, you must use data that is organised as a list with labeled columns. If you are changing the...

Aloha, I recorded the following macro and would like to extend the macro to row 1,000. The macro inserts a row, deletes column C, then cuts cells A5 and B5 and paste the cells in F2 and G2. It then deletes 8 rows. Then it repeats the process Thanks Sub Macro1() ' ' Macro1 Macro ' '...

Good Morning, I seem to be having an issue getting the following to post. Everything runs fine until it gets to the Selection.Paste (Highlighted in blue) I've tried variations and the only time it will paste is if I add Selection.Cut but I need to leave the original data in place on the...

Hi. I have an Excel Worksheet with 241 columns and around 46 thousand rows of numbers (no blanks anywhere). I only require 9 (nine) columns from the sheet which should be placed in Columns B to J. From recording a macro, and deleting unnecessary cursor movements, I ended up with the following...

Hi, I am new to VBA and having issues trying to cut and paste highlighted rows. I have started with the below code but it only cuts the active cells rather than the entire rows , I have tried various different bits of code but can’t get anything to work. I need the code to loop through sheet...

Hello everyone, I need some help. I'm trying to create a macro which converts a (really bad) SAP report to a good table with only the necessary info. The table is about vendors. Till the last step everything works correctly. But there is a little problem, the report contains the existing data...