$$Excel-Macros$$ Re: unsubscribe

PLEASE UNSUCRIBE ME On 3/27/09, mohammed farhaan wrote: > > > pls unsubsribe me... > -- > Add more friends to your messenger and enjoy! Invite them now. > > > > --~--~-~--~~--

$$Excel-Macros$$ Re: Modifying the contents of a cell in a range in excel

Hello Friend -- You need a subroutine to change the range ... Sub ChangeCells(theRange As Range) theRange.Cells(1,1) = "Hello World" End Sub ... this will work fine Hope it helps you ! - Rodney POWELL [ Microsoft MVP - Excel, 1997-2009 ] www.BeyondTechnology.com On Mar 28, 1

$$Excel-Macros$$ Re: answer for query

Thanks a lot Vinu That solves my problem. Happy Ugadi to you too. I have few more queries which I have put in the attached excel sheet. Hope to get the answer. Thanks in advance. Praveen Khunte On Sat, Mar 28, 2009 at 7:51 PM, Vinu wrote: > Hello Praveen, > I hope you are doing well, happy Ug

$$Excel-Macros$$ Modifying the contents of a cell in a range in excel

All, I have a simple task: I'd like to modify the value in a cell in a range of cells, which is passed in to a function. For example: Function ChangeCells(theRange As Range) theRange.Cells(1,1) = "Hello World" End Function If I run this function, I always receive the #VALUE! error message

$$Excel-Macros$$ answer for query

Hello Praveen, I hope you are doing well, happy Ugadi. I have enclosed the copy of xl sheet, which solves your query. I used Sumproduct forulat, just change the company names to know the count. Please let me know if you have any issues. -- Vinu (¨`*.*´¨) Always `*.¸(¨`*.*´¨) Keep (¨`*.*´¨)

$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

There are a couple of ways you can approach this ... Possible Solution # 1 - If your criteria must be hardcoded in the VBA procedure then ... Select Case Selection.Cells(x&, 8).Value Case "AD", "AE", "AF", "AG", "AI", "AL", "AM", "AN", "AO", "AQ", "AR", "AS"

$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

Hi the way you try to do is wrong ... here you go If Selection.Cells(x, 8) <> _ "AD" Or Selection.Cells(x, 8) <> "AE" Or Selection.Cells(x, 8) <> "AF" Or Selection.Cells(x, 8) <> "AG" Or Selection.Cells(x, 8) <> "AI" Or Selection.Cells(x, 8) <> "AL" Or Selection.Cells(x, 8) <> "AM" Or Selection.C

$$Excel-Macros$$ Extract the contents from Flash Site

Hi Team, Can anyone please suggest me to extract the contents from the Flash Site. It would be helpful if you could provide me macro to do this. Your suggestions will be of great help. Thanks, Sharma --~--~-~--~~~---~--~~ -