Excel 2007 Macro
Closed
Mahe
-
Aug 11, 2011 at 03:18 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 11, 2011 at 07:38 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 11, 2011 at 07:38 AM
Related:
- Excel 2007 Macro
- Save as pdf office 2007 - Download - Other
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 11, 2011 at 07:38 AM
Aug 11, 2011 at 07:38 AM
the question is vague
suppose you want to transfer cell B1 in sheet1 to the first available row and in column A in sheet 2
the macro will be something like this
suppose you want to transfer cell B1 in sheet1 to the first available row and in column A in sheet 2
the macro will be something like this
With Worksheets("sheet1")
.Range("B1").Copy
With Worksheets("sheet2")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
End With
