Re: $$Excel-Macros$$ Multiple Selection of cells & copying the same using macro

2011-01-07 Thread Paul Schreiner 
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 
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  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

Re: $$Excel-Macros$$ Multiple Selection of cells & copying the same using macro

2011-01-07 Thread ashish koul 
can you send sample sheet

On 1/7/11, Raj Mahapatra  wrote:
> kindly help on this
>
> On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra  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
>


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

Re: $$Excel-Macros$$ Multiple Selection of cells & copying the same using macro

2011-01-07 Thread Raj Mahapatra 
kindly help on this

On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra  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