I am new to VBA Excel programming. The following code goes to the Raw Data worksheet selects some cells, then moves back to the Combined Data worksheet and copies them. Unfortunately, the SENDKEYS that I am using at the bottom does not work. Can you think of another way that I can execute this procedure?
Sub ActivateSheet()
Sheets("RawData").Activate
Range("A1").Activate
ActiveCell.CurrentRegion.Select
ActiveCell.CurrentRegion.Copy
Sheets("Combined Data").Select
Range("A1").Activate
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
Application.SendKeys "{ENTER}"
End Sub
Thanks, Susie
Bookmarks