Excel macro to copy cell content highlighted
Closed
manrick
Posts
3
Registration date
Wednesday 4 March 2009
Status
Member
Last seen
5 March 2009
-
5 Mar 2009 à 03:31
manrick Posts 3 Registration date Wednesday 4 March 2009 Status Member Last seen 5 March 2009 - 5 Mar 2009 à 04:12
manrick Posts 3 Registration date Wednesday 4 March 2009 Status Member Last seen 5 March 2009 - 5 Mar 2009 à 04:12
Related:
- Excel macro to copy cell content highlighted
- How to copy data from one excel sheet to another - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
3 responses
Tweedledum
Posts
181
Registration date
Monday 19 January 2009
Status
Member
Last seen
2 April 2009
125
5 Mar 2009 à 03:41
5 Mar 2009 à 03:41
I am no excel expert but
ActiveSheet.Range("the cell you want to copy eg: A5 ").CurrentRegion.Select
Selection.Copy
ActiveSheet.Range("the cell you want to past to eg: B10 ").CurrentRegion.Select
Selection.Paste
the part about the highlighted cells I am not so sure, but this will do it if you always know where you are pasting to. This is at least a good start, someone else might help you with the other part or you might find it, id suggest recording a macro of selecting a cell for that syntax and then you could mess with it for the desired effect. Sorry I couldnt be more help
ActiveSheet.Range("the cell you want to copy eg: A5 ").CurrentRegion.Select
Selection.Copy
ActiveSheet.Range("the cell you want to past to eg: B10 ").CurrentRegion.Select
Selection.Paste
the part about the highlighted cells I am not so sure, but this will do it if you always know where you are pasting to. This is at least a good start, someone else might help you with the other part or you might find it, id suggest recording a macro of selecting a cell for that syntax and then you could mess with it for the desired effect. Sorry I couldnt be more help
epsiman
Posts
306
Registration date
Tuesday 18 November 2008
Status
Member
Last seen
2 February 2010
162
5 Mar 2009 à 03:51
5 Mar 2009 à 03:51
Can you me more explicite please, I can't help you with that much info
manrick
Posts
3
Registration date
Wednesday 4 March 2009
Status
Member
Last seen
5 March 2009
5 Mar 2009 à 04:12
5 Mar 2009 à 04:12
Hi epsiman
I am manually highlighting a range of cells and want to copy the data from a separate cell into each of the highlighted. I would like to do this via a button assigned to a macro because it is a task that I need to repeat over and over again
Hope I am clearer in what I need to do.
Manny
I am manually highlighting a range of cells and want to copy the data from a separate cell into each of the highlighted. I would like to do this via a button assigned to a macro because it is a task that I need to repeat over and over again
Hope I am clearer in what I need to do.
Manny
manrick
Posts
3
Registration date
Wednesday 4 March 2009
Status
Member
Last seen
5 March 2009
5 Mar 2009 à 03:51
5 Mar 2009 à 03:51
Thanks Tweedledum
That at least gives me a start
Manny
That at least gives me a start
Manny
