macro for copy a cell
how can i make a macro do the following:
copy the active cell and past in the second cell ( never mind the name of the cell )
Hi,
By second cell do you mean the one next to it?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
simple
activecell.copy activecell.offset(,1) 'for copy to next column activecell.copy activecell.offset(1,0) 'for copy under activecell
try this
Change the parameter of "Offset" function to select desire cellActiveCell.Select Selection.Copy ActiveCell.Offset(0, 1).Select ActiveSheet.Paste Application.CutCopyMode = False
thank you all
but
how can i make this macro run each time i open this workbook
Have a look here: http://www.rondebruin.nl/personal.htm
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks