Ideally you should not have got the same error, had you used the code that I
gave you. Still I would urge you to use the following code
Worksheets("Sheet1").Cells(1, 1).Select
ActiveCell.EntireRow.Copy
Worksheets("Sheet2").Cells(1, 1).PasteSpecial xlPasteAll
If still the error persists, then pl
Dude - this problem is already solved. Here is the link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=72
Regards,
-Dev
On Nov 27, 12:17 pm, sanj <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> Can anyone advise me, how can I arrange excel sheets in ascending
> order?
>
> Regards,
> Sanjaykumar
Hello all,
When I am trying to write text "6-5", EXCEL automatically converting it into
"5-Jun". How can I change this setting globally. As I know, using "format"
option we can change it into required text format but this not possible if
my sheet contains thousands of such values.
Please assist me
Nice dear great its so thanks for the same.
*Unfeigned Regards
Manoj S Negi
**"Miles & miles to go before I sleep"
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
*
On Sun, Nov 30, 2008 at 1:30 PM, Suni
*Great Awesome..*
*Unfeigned Regards
Manoj S Negi
**"Miles & miles to go before I sleep"
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
*
On Sun, Nov 30, 2008 at 1:38 PM, Sunil Tha
Is there a way to search or sort the discussions so I can easily find
one that I started?
Regards,
Doug Rohr
(330) 471-4164
-
This message and any attachments are intended for the individual or
entity named above. If you are not the intended reci
Hi Guys, thanks both for your replies.
However I have tried them both and get the same error code,1004.
I am using Excel 2007 with VB version 6.5. Is there something crazy
settings or something causing this?
Thanks CL
--~--~-~--~~~---~--~~
Visit the blog to dow
Hi A very big Thanks... I hope macro part would be
very useful..
On 11/30/08, Sunil Thacker <[EMAIL PROTECTED]> wrote:
>
>
> hi all please find this excel e-boooks..!! Please just say thanks if u
> find it useful..! he he
>
>
> cheer guys and gals...keep exceling :)
>
