ChrisNewbie
New Member
- Joined
- Dec 22, 2008
- Messages
- 3
Hi, I am new to this and would appreciate your help.
I am looking for a macro to copy a specific cell say "$A$1" and when click on a new cell and press "ctrl+M" will paste $A$1's contents & formatting into a cell selected by the user-
Ctrl+M is the shortcut to the above macro
I basically want to be able to click random cells on my gannt chart and paste $A$1 into it, Because the spreadsheet is a gannt chart the formatting and colour highlight used in cell was needs to be copied too. It is the significant part of the sheet.
Many Thanks For Your Help In Advance
Chris
I am looking for a macro to copy a specific cell say "$A$1" and when click on a new cell and press "ctrl+M" will paste $A$1's contents & formatting into a cell selected by the user-
Ctrl+M is the shortcut to the above macro
I basically want to be able to click random cells on my gannt chart and paste $A$1 into it, Because the spreadsheet is a gannt chart the formatting and colour highlight used in cell was needs to be copied too. It is the significant part of the sheet.
Many Thanks For Your Help In Advance
Chris
