'move to the AddRecipes tab
Sheets("AddRecipes").Select
'select the range of recipe ingredients and then copy the selection.
Range("C11:C30").Select
Selection.Copy
'select the dessert sheet
Sheets("DessertIngredients").Select
'select the range and then paste there using the dynamic variables in the for loop
Range(Cells(Row1 + 1, Column1), Cells(Row1 + 21, Column1)).Select
ActiveSheet.Paste
I am always exploring interesting tidbit in technology. I will keep a blog of my path to discovering new technology.
Wednesday, July 6, 2011
VBA code for copying range of cells in excel
I helped someone make a copy of some cells in an excel spreadsheet using VBA. Thy were adding a recipe to another worksheet.
Subscribe to:
Post Comments (Atom)
1 comment:
it's good for all and very impressive if we use in our project...
Post a Comment