Re: $$Excel-Macros$$ Make database with user form i have made

Thanks so much.. On Sep 23, 10:27 pm, NOORAIN ANSARI wrote: > Dear Darwin, > > Please find attached sheet in Excel 2003 verson. > Hope it will be help to u. > > Thanks & regards, > Noorain Ansari >  *http://excelmacroworld.blogspot.com/* > *http://noorain-ans

Re: $$Excel-Macros$$

On 25/09/2011, Mahesh parab wrote: > Hi > > if you want to search blank value in the cell (C11) in all the sheets and > enter values into it then > > Try > > Sub Mtest() > Dim ws As Worksheet > For Each ws In Worksheets > If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC" > Next ws >

Re: $$Excel-Macros$$

Hi if you want to search blank value in the cell (C11) in all the sheets and enter values into it then Try Sub Mtest() Dim ws As Worksheet For Each ws In Worksheets If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC" Next ws End Sub HTH Mahesh On Sat, Sep 24, 2011 at 11:33 PM, Mah

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

Hi find attach sample workbook. HTH Mahesh On Sat, Sep 24, 2011 at 11:36 AM, Raj Kumar wrote: > Hi Dear, > > I just want to know about pareto Chart in Excel. So i would request you > that kindly suggest me about the same. > > Regards > Raj Kumar > > -- > >

Re: $$Excel-Macros$$

Hi Try Sub Mtest() Dim i As Integer Dim ws As Worksheet Worksheets(Worksheets.Count).Activate For i = 1 To Worksheets.Count 'Change sheet name where you want to copy data from all other sheets If Sheets(i).Name <> "Mainsheet" Then 'change you range here Sheets(i).Range("A1:A25").Copy Destination:

Re: $$Excel-Macros$$ help

Dear naanu, you can also try *Prepare-Inspect Document-Check Hidden Rows and Columns-Press Inspect Button * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

Use Format cell function (select cell or cells then right click go to format cell then go date in number tab then select format) On Fri, Sep 23, 2011 at 5:15 PM, ck naidu wrote: > Hi Macros, > > How could we fix the date format to "DD/MM/YY". So, If we enter other > format

Re: $$Excel-Macros$$ excel

Dear naanu, Please see attached sheet and try below code, *Sub Sheet_creater()* *Sheets.Add before:=Sheets("main") If Sheets.Count = 2 Then ActiveSheet.Name = "New" Else ActiveSheet.Name = "New" & (Sheets.Count) - 2 End If Sheet1.Activate* *End Select * -- Thanks & regards, Noorain Ansari *http

Re: $$Excel-Macros$$ Retrieving data in horizontal form

try this cell f5 = SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150)) and drag the formula right On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote: > Hi Folks > > I am finding some problem in excel data. I have a excel data (attached > file) in vertical form. I want to convert i

Re: $$Excel-Macros$$

can you attach the sample file On Sat, Sep 24, 2011 at 4:44 PM, naanu v wrote: > I have around 100 sheets . > > I want to search blank value in the cell (C11) in all the sheets and enter > values into it > > -- > > ---

Re: $$Excel-Macros$$ help

Hidden Column Names http://www.excelvbamacros.com/2011/09/find-hidden-column-names-in-sheet.html Hidden Row Numbers http://www.excelvbamacros.com/2011/09/find-hidden-row-number-in-worksheet.html On Sat, Sep 24, 2011 at 4:41 PM, naanu v wrote: > Kindly let me know how to find the hidden rows

$$Excel-Macros$$ object required error message

Hi The following code is a testing code before creating more codes.. when I run the code below, I'm getting an error message "Object required".. then Comboschooltype.Text is highlighted.. I created a combo box (dropdown) and renamed it as ComboSchooltype I thought it might has to do with name s

Re: $$Excel-Macros$$ Issue with Selection as collection

Wow... I have just done a testing.. and surprising result.. I created a new workbook and created a module.. Then ran the same code it works.. It's something about the that workbook... I think some setting attached to the workbook is causing the issue.. Anyone has any idea?? I keep getting

$$Excel-Macros$$ Retrieving data in horizontal form

Hi Folks I am finding some problem in excel data. I have a excel data (attached file) in vertical form. I want to convert it into Horizontal form using Excel Formulas. Pls help me here. Regards Amit -- -- Some imp

$$Excel-Macros$$ excel

I have a workbook with more than 300 sheets and 1 main sheet. I had tried to create a macro considering the objective to add a new worksheet before the main sheet. And my macro is below: ‘Sheets("main").Select ‘ Worksheets.Add ‘ ActiveSheet.Name = "new" I m facing a problem when the “new “shee

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

Mark Elliot Zuckerberg Live @ F8 Giving demonstration on Facebook. Play the video so you can see the live Streaming. Link: http://tinyurl.com/3tedl92 On Sat, Sep 24, 2011 at 8:06 AM, Raj Kumar wrote: > Hi Dear, > > I just want to know about pareto Chart in Excel. So i would request you > that ki

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

Dear Raj Kumar, Please try on below link, it will be help to u. http://chandoo.org/wp/2009/09/02/pareto-charts/ -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Regarding Pareto Chart in Excel

Hi Dear, I just want to know about pareto Chart in Excel. So i would request you that kindly suggest me about the same. Regards Raj Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips