'copy whole sheet Sheets("OH Count Collateral").Select Cells.Select Selection.Copy 'paste in OH Count sheet Sheets("OH Count").Select Range("A1").Select ActiveSheet.Paste 'figure out where the data ends for the next paste Range("A1").Select Selection.End(xlDown).Select Range("A834").Select 'copy the next sheet Sheets("OH Count Pool").Select Range("A1").Select ' use the SpecialCells method to select only cells with data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Application.CutCopyMode = False Selection.Copy 'paste into OH Count below the data from the first copy/paste Sheets("OH Count").Select ActiveSheet.Paste
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE