Excel 2004 For Mac Visual Basic Insert Row

Inserting blank rows in active cell visual basic excel. Contents in the cells. I tried to copy the 3 rows then just erase it contents. My problem is if i already put datas in row 4 to row 6, then i click the button again, the previous row 4 to row 6 will now move down, the new blank rows will always be inserted after row 1-row 3 which is. Visual Basic Support in Mac 2016 Hi. Am I missing something? I've been periodically using the Excel 2016 for Mac updates but quickly abandoned them because my sheets rely so heavily on VBA and support for that seemed to be missing. I've updatd to the production version today (15.2).and it still seems to be the case? The Visual Basic editor is.

Good afternoon. Thanks in advance for your help si. (I'm an analyst, not a programmer.) And, I'm the so called Excel whiz, so I guess it's time to learn to play with the big guys. Free app similar to photoshop for mac. Okay here goes.

(This is only part of it, when printed its 4 1/2 pages.) The runtime error occurs immediately. Private Sub CommandButton1_Click() ' Sheets('2-04 Up').Select Range('A10 1000').Select Selection.Copy Sheets('Run ').Select Range('A2').Select ActiveSheet.Paste Sheets('3-04 Up').Select Range('A10 1000').Select Application.CutCopyMode = False Selection.Copy Sheets('Run ').Select ActiveWindow.LargeScroll Down:=34 Range('A1001').Select ActiveSheet.Paste Like I mentioned, the macro runs on its own, it just has problems when I try and attach it to a command button. Thank you so much. [quote]What do you mean the sheet doesn't have a focus?/quote] Even though the sheet has been selected by the code, the button that started the macro still has the focus (ie: is still potentially taking input from the user). It's a strange quirk of Excel, but it has problems changing selection within a worksheet if the focus is elsewhere (like your button). Using Activate basically sets the focus, but activating the sheet without activating the workbook doesnt always work. I've checked my syntax for activating the book, and apparently it should be Parent rather than Workbook, ie: Sheets('2-04 Up').Parent.Activate or even: ThisWorkBook.Activate And if that doesnt work, another option to remove the problem: the code seems to be in chunks of copying from one sheet to another - there is a much simpler way (which doesnt involve selecting).

Rather than this code which Excel produces in macros. Morning again Si - Wanted to let you know I really appreciate all the help you're giving me. I tried what you suggested. Had a couple of kinks, worked some of them out (and you probably have an easier, less complicated way than this) and this is what I'm left with. Google drive for mac desktop.