Search : in
By :

Excel macro to copy cell content highlighted

Last answer on Mar 5, 2009 9:12:25 am GMT manrick, on Mar 5, 2009 8:31:16 am GMT 
 Report this message to moderators

Hello,
I am trying write a macro assigned to a button that copies the content of a cell into highlighted cells.

Please can anyone suggest a solution
thx
Manny

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « excel macro to copy cell content highlighted » in :
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Ask your question Reply

1

Tweedledum, on Mar 5, 2009 8:41:22 am GMT
  • +1

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

   
Reply to Tweedledum

2

epsiman, on Mar 5, 2009 8:51:16 am GMT

Can you me more explicite please, i can't help you with that much info

   
Reply to epsiman

4

 manrick, on Mar 5, 2009 9:12:25 am GMT

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

   
Reply to manrick

3

manrick, on Mar 5, 2009 8:51:53 am GMT

Thanks Tweedledum
That at least gives me a start

Manny

   
Reply to manrick
Ask your question Reply
They need your help