VBA Excel Help
-
I recorded an actual Macro and it looks like this. Application.CommandBars("Web").Visible = False Range("A28").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("A29").Select ActiveWindow.SmallScroll Down:=3 What I actually have is thousands of rows populated, Three rows are visible with data in the top three rows of my active sheet, 26, 27 & 28 in this example. When I first open the spreadsheet, I need to make the WEB toolbar go away, this part is good. I then need to click on the very last hyperlink in 'A' column, I think it may be refered to something like lastused range????? This example is 'A28'. I then need to put the cursor in the next available empty cell past the lastused range in the 'A' column and post it in the very top left corner, (as though it was in cell A1 ready to work). This empty cell was in the fourth row so I did three smallscroll to get it to the top row in view. When I record the macro as you see above it records the actual cell number, this will not help me but I know someone here can please. I also need the macro to run slowly giving the internet time to upload the hyperlink and then revert back to finish the macro, it just zips right through it now and does not end up in the correct cell when completed. Thanks in advance for any help, I didnt see a VBA forum, flame suit on. Lastly, is there a way to make the WEB toolbar stay gone, it wasnt in view by default prior to some MS update I am guessing???