Raj,
I'm sorry to say that this post has been largely ignored
because it contains almost no usable information!
-------------------------------
"requesting you to tell me"
OK.. you're asking a question...
--------------------------------
"the macro codes"
Since you're here, we can assume it's VBA macro syntax
for one of the versions of Excel.
--------------------------------
"Multiple Selection of cells"
Are the cells contiguous/sequential?
In which case you would use:
Range("A1:Z65000").Select
Or does your worksheet have a Named Range? Like "SalesRange"?
In which case:
Range("SalesRange").Select
would work
Or.. does your macro have a variable that defines the range?
Like:
...
Dim MyRange as Range
...
Set MyRange = Range("A1:Z65000")
...
MyRange.Select
--------------------------------
"& copying the same"
Copy WHAT?
Values? Formats? column widths?
copy to where?
The same worksheet?
A different sheet in the same workbook?
A different workbook?
A different APPLICATION? (copy Excel values to Word or Outlook!)
To copy the selected Range to the "Clipboard", you could use:
Range("A1:A65000").Select
Selection.Copy
Of course, to copy to the clipboard, you don't
REALLY have to "select" the range explicitly.
Range("A1:A65000").Copy
does the same thing.
Now, if you want to copy and PASTE the data.
Then you could use:
Range("A3:A7").Copy
Range("B3").Select
ActiveSheet.Paste
should do the trick.
But then, you don't have to use the clipboard!
If you want to copy the CONTENTS of the cells (not formatting)
You could use:
Range("B3:B7").Value = Range("A3:A7").Value
---------------------------------------------
Of course, if the "multiple selection" of cells is
not contiguous, then the above all changes!
Have you tried to record a macro to do what you want and see
what code is generated?
What have you tried?
What is causing you problems?
In order to get some group members to be willing to jump in and help
without spending HUGE amounts of time answering questions that
do not apply to you at all, you should give us more information
to work with... Like:
In Excel 2007, I have a macro that creates 2000 rows of data.
I need to locate the ____ values in each row and copy the
values to another worksheet.
The values may be in any column, but can be recognized by ____.
What is the best approach for this?
Paul
________________________________
From: Raj Mahapatra <rajafs...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Fri, January 7, 2011 3:15:14 AM
Subject: Re: $$Excel-Macros$$ Multiple Selection of cells & copying the same
using macro
kindly help on this
On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra <rajafs...@gmail.com> wrote:
hi group,
>
>requesting you to tell me the macro codes for "Multiple Selection of cells &
>copying the same"
>
>thanks
>
>Rajesh--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
