Re: Fw: $$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-30 Thread sarfaraz ahmed
I think we had enough mails on this. Sunita, is right.. lets and starts sharing some good knowledge. Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com On Sun, Nov 30, 2008 at 10:00 AM, Sunita Paudel <[EMAIL PROTECTED]> wrote: > Yeah now lets stop the topic..we have done whatever we cud

$$Excel-Macros$$ USING MACROS TO CHANGE/SHIFT LINKS AUTOMATICALLY

2008-11-30 Thread anoopk75
Hi, I am new to this group. Came across this group as I was scouting through web for some help in XL. Really amazed with what I am learning from this group. Thanks a million guys. I have a problem and hope some one may be able to help me with a solution. As a part of my job I keep record of each

$$Excel-Macros$$ A little help..! saving as html and then............

2008-11-30 Thread Sunil Thacker
Hi All, A query, hope someone can help...!! I am saving a excel sheet after all the necessary macro and charts fun as a webpage. now when we open this webpage in notepad it will show the HTML stuff. So what i want is in this html stuff i want to add some code(ASP code) above all the html tags and

$$Excel-Macros$$ Re: excel boooooks..

2008-11-30 Thread Ashok Harsha
Thanks On Sun, Nov 30, 2008 at 2:59 PM, 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 :) > > > -- > Regards, Sunil Thacker > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨)

$$Excel-Macros$$ Re: Paste Error 1004

2008-11-30 Thread Ajit Navre
There is a typo in the last line. However, here is a better approach to accomplish it... Sub sample() Worksheets("Sheet1").Cells(1, 1).EntireRow.Copy Destination:=Worksheets("Sheet2").Range("A1") 'Worksheets("Sheet2").Range(1, 1).EntireRow.Paste End Sub The commented line is what you have. Reg

$$Excel-Macros$$ Re: Paste Error 1004

2008-11-30 Thread Dave Bonallack
Hi, I have come across this before with copy paste. It seems you can copy from any sheet you want, but you can only paste into the active worksheet. Try this: Worksheets("Sheet1").Cells(1, 1).Select ActiveCell.EntireRow.Copy Worksheets("Sheet2").Activate Worksheets("Sheet2").Range(1, 1).EntireRo

$$Excel-Macros$$ Paste Error 1004

2008-11-30 Thread industcontrols
Hi all, This must be so easy but I cannot for the life of me figure out what is going wrong. All I want do do is copy an entire row from one sheet to another sheet in the same workbook. All my code works OK except the apparently simple task of copying and pasting between sheets. The code below i

Re: Fw: $$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-30 Thread Sunita Paudel
Yeah now lets stop the topic..we have done whatever we cud to punish that guy. thnx all for the co-op :) now time to learn and share excel tips have a grt day Suneeta On 11/27/08, Alokeshwar Tiwary <[EMAIL PROTECTED]> wrote: > > > Lets stop this topic and continue sharing excel-vba