$$Excel-Macros$$ Re: Help with formatting and subtotal

You can also use sumif formula On Sat, Aug 15, 2009 at 3:57 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: Hi Attached is the solution to problem.. you just need to hide to column C. Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83

$$Excel-Macros$$ Re: removing starting letters

This works...Thank you so much. Can you please provide me with similar function for MS Access database as well? RM On Sat, Aug 15, 2009 at 1:18 AM, Serghei Ovanesov oserg...@hotmail.comwrote: Hello, To remove starting letters from the cell the following nested function can be used:

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos Blank

Hi Bakul, You'll have to include the formatting lines in the code I sent in order to insert an = in front of numbers and into blank cells. Regards - Dave. Date: Fri, 14 Aug 2009 15:02:13 -0700 From: bakulpatel...@yahoo.com Subject: $$Excel-Macros$$ Re: insert = in every cell as prefix with nos

$$Excel-Macros$$ Independance day

Wishing you all a very happy Independence Day. Thanks Regards, Dhananjay --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ about to remove #VALUE! error

Dear All, Can anyone provide me the solution as per the requirement in the attachment. Thanks in advance Regards, Dhananjay Pinjan (Mob. No. 9922255533) --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Fwd: about to remove #VALUE! error

Dear All, Please ignore the previous mail sent by me because i forgot to attach the excel file. Can anyone provide me the solution as per the requirement in the attachment. Thanks in advance Regards, Dhananjay Pinjan (Mob. No. 9922255533)

$$Excel-Macros$$ Cell Lock

Dear All, In the attached sheet advise how to lock onlu one cell (Yellow highlighted) from editing or filtering Thanks in advance Regards, -- Prashant --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Help with formatting and subtotal

USe Pivot Table .. Probably that will give solution what you are looking for. Kamal On Sat, Aug 15, 2009 at 6:57 AM, vivek agrawal vivek.agrawa...@gmail.comwrote: Hi Attached is the solution to problem.. you just need to hide to column C. Hope this helps Thanks and Regards, Vivek

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos Blank

Hi Bakul Try this one Sub Insertequals() Dim cel As Range For Each cel In Selection If IsNumeric(cel.Value) Then cel.Value = = cel.Value Else Exit Sub End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf

$$Excel-Macros$$ Dynamic UserForms - How to access its objects created through code

Hi, I've created a dynamic userform that will show a number of comboboxes indicated by the global variable HomeGoals. This variable will be given a variable in the previous userform, which then calls my dynamic userform. I've managed to show the number of comboboxes I want, as well as resize

$$Excel-Macros$$ Re: Fwd: about to remove #VALUE! error

Hi, Have a look at the attached. I've used SUMIF. But I don't know why you don't want to use SUM. It works just as well, and is simpler. They are the results in red. Regards - Dave Date: Sat, 15 Aug 2009 17:21:35 +0530 Subject: $$Excel-Macros$$ Fwd: about to remove #VALUE! error From: