Re: $$Excel-Macros$$ Password protect hidden sheets

Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect "1823" Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox("kindly enter password to unprotect sheet") If pass = "1823" Then Sheet1.Unprotect "1823" Sheets(1).Visible = True Else MsgBox

$$Excel-Macros$$ excell to pdf

Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

$$Excel-Macros$$ reqment of greater than formula

Hello friends, I want to a formula of gareter than. any body tell me. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ reqment of greater than formula

Dear Anil, Please explain, we are not getting your point, On Tue, Jan 31, 2012 at 4:05 PM, anil kumar wrote: > Hello friends, > > I want to a formula of gareter than. any body tell me. > > > Anil > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accura

Re: $$Excel-Macros$$ reqment of greater than formula

Hello sir, Thanks for response, I attach file. anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may

Re: $$Excel-Macros$$ reqment of greater than formula

Dear Anil, You can use..simple =MAX(D2:G2) or =LARGE(D2:G2,1) See attached sheet.. On Tue, Jan 31, 2012 at 4:24 PM, anil kumar wrote: > Hello sir, > > Thanks for response, I attach file. > > > anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate t

Re: $$Excel-Macros$$ reqment of greater than formula

sorry sir, but i want to know what is use of 1 in large formula. and my second queary can solve anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and

Re: $$Excel-Macros$$ reqment of greater than formula

Dear Anil, In large function 1 is using for rank See details about large function.. MS Excel: Large Function -- In Excel, the *Large* function returns the nth largest value from a set of values. The syntax for the *Large* function is: Large( array, nth_position )

Re: $$Excel-Macros$$ reqment of greater than formula

Thanks sir, I will follow this formula than i give u msg Thanks again Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

$$Excel-Macros$$ Query continuous copy paste

Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note tha

RE: $$Excel-Macros$$ excell to pdf

Try this: Sub CreatePDF() Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path & "\" & wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, Igno

RE: $$Excel-Macros$$ Query continuous copy paste

Try this : Sub Transformdata() Dim rngCEll As Range Dim rngRange As Range Dim wksOutput As Worksheet Set wksOutput = ThisWorkbook.Worksheets.Add Set rngRange = ThisWorkbook.Worksheets("Query").Rows(1) For Each rngCEll In rngRange.Cells Application.ScreenUpdating

Re: $$Excel-Macros$$ excell to pdf

hi Rajan, lot of thanks it is working fine Regards chandru On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma wrote: > Try this: > > ** ** > > Sub CreatePDF() > > ** ** > > Dim wksSheet As Worksheet > > For Each wksSheet In ThisWorkbook.Worksheets > > wksSheet.ExportAsFixed

RE: $$Excel-Macros$$ Password protect hidden sheets

Hi After hiding worksheet.. paste this in worksheet code module Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect "YourPassWord" .Visible = xlSheetHidden StrPass = InputBox("kindly enter password to unprotect sheet") If StrP

RE: $$Excel-Macros$$ reqment of greater than formula

Try with CSE =LARGE(SUMPRODUCT(--(NOT(ISERROR(E5:X5)))*IFERROR(E5:$X$5,0)),1) Rajann. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Tue/2012 05:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ reqment of gr

FW: $$Excel-Macros$$ reqment of greater than formula

Please ignore previous Try this With CSE =LARGE(--(NOT(ISERROR(E3:W3)))*IFERROR(E3:W3,0),1) Rajan From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Jan/Tue/2012 07:07 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ reqment of greater than formula Try w

Re: $$Excel-Macros$$ excell to pdf

Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Minimum & Maximum value of a Cell

Why would you even need such a large UDF. This should do it. Function MAXVAL(strTEXT As String) As Long Dim lngLoop As Long For lngLoop = 1 To Len(strTEXT) MAXVAL = Application.Max(1 * IIf(IsNumeric(Mid(strTEXT, lngLoop, 1)), Mid(strTEXT, lngLoop, 1), 0), MAXVAL) Next lngLoop E

Re: $$Excel-Macros$$ Query continuous copy paste

Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form acco

RE: $$Excel-Macros$$ Sent Mailer data

See if it helps: Sub SendMail() Application.Dialogs(xlDialogSendMail).Show End sub Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anjul Porwal Sent: Jan/Tue/2012 12:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sent Mail

Re: $$Excel-Macros$$ excell to pdf

hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA wrote: > Hi Chandra, > > It is not working in my system > Cold you please what you did to get it worked properly? > > Regards, > Kaushik > > -- > FORUM RULES (98

RE: $$Excel-Macros$$ excell to pdf

Which version of excel are u using?? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of raghu gr Sent: Jan/Tue/2012 07:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf hi, its not working to me also, error in l

Re: $$Excel-Macros$$ excell to pdf

Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or

Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells

May I ask why you did not like my solution? Sub TTC_SAS() Application.ScreenUpdating = False Application.DisplayAlerts = False Columns("g:o").Delete Columns("A").TextToColumns Destination:=Range("G1"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(4, 1)), TrailingMinusNumbers:=Tru

RE: $$Excel-Macros$$ excell to pdf

Ok.. it will give error if your worksheet does not have any data Try this Sub CreatePDF() Dim wksSheet As Worksheet Dim intI As Integer intI = 0 For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) <> 0 Then wksSheet.ExportA

$$Excel-Macros$$ Formula Hide in Excel Work Sheet.

Hi Group, How to Hide formula in excel work sheet. Please suggest. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick atte

Re: $$Excel-Macros$$ pdf to word document

Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma wrote: > Try this: > > ** ** > > Sub CreatePDF() > > ** ** > > Dim wksSheet As Worksheet > > For Each wksSheet In ThisWorkbook.Worksheets > > wksSheet

Re: $$Excel-Macros$$ Formula Hide in Excel Work Sheet.

Dear Bhupender, Select formula area and press ctrl+1 and goto protection and selec Hidden and protect sheet See atthached Screen Shot.. On Tue, Jan 31, 2012 at 7:51 PM, bhupendra singh raghav < raghav.bhupen...@gmail.com> wrote: > Hi Group, > > How to Hide formula in excel work sheet. > Please

Re: $$Excel-Macros$$

I suggest you NOT do that. Instead delete the blanks and use data>filter>autofilter>filter as desired. Don Guillett SalesAid Software dguille...@gmail.com From: raghu gr Sent: Tuesday, January 31, 2012 8:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi, In customer data

Re: $$Excel-Macros$$ pdf to word document

Dear Veeru, You can download free pdf to text converter through below link.. http://www.pdf-to-html-word.com/pdf-to-text/ On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC wrote: > Dear sir, > > > how to convert pdf file to text file... > > > On Tue, Jan 31, 2012 at 6:33

RE: $$Excel-Macros$$ pdf to word document

Hi You can Open PDF File in adobe Reader and save as Text file, I think you may lost data formatting ,to avoid this you need to buy any program as noorain suggested.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue

$$Excel-Macros$$ Excel Symbol.

Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

RE: $$Excel-Macros$$ excell to pdf

Dear Kaushik You have a hidden worksheet in this workbook Replace this code . . . . For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) <> 0 Then If wksSheet.Visible = xlSheetHidden Then wksSheet.Visible = xlSheetVisible

$$Excel-Macros$$ Activate The fill Handle

Hi Group, How to activate the fill handle. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answ

Re: $$Excel-Macros$$ Query continuous copy paste

Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar wrote: > Thanks Noorain Ansari Ji for the solution but it works is working with > this sheet only i.e if the column headings are having two

RE: $$Excel-Macros$$ Excel Symbol.

Goto Insert->Symbol You can insert any symbol from here Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Symbol. Hi Group,

Re: $$Excel-Macros$$ excell to pdf

Hi Rajan, Problem resolved. Excellent job to help us on this article. Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi

RE: $$Excel-Macros$$ Activate The fill Handle

HI Raghav, See the attached Link http://www.excelvbamacros.com/search/label/Activate%20The%20fill%20Handle Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:21 To: excel-macros@googlegroups.com Sub

$$Excel-Macros$$ Re: Excel Symbol.

Insert> Symbol Select the one you want. If not found change the font from drop down. Prakash On Jan 31, 7:47 pm, bhupendra singh raghav wrote: > Hi Group, > > I Need a spacial Symbol insert to excel work sheet. there is any opetion. > > Please suggest. > > Regards > Raghav. -- FORUM RULES (9

Re: $$Excel-Macros$$ Activate The fill Handle

Dear Raghav, http://support.microsoft.com/kb/291359 you can search in google more explain On Tue, Jan 31, 2012 at 8:21 PM, bhupendra singh raghav < raghav.bhupen...@gmail.com> wrote: > Hi Group, > > How to activate the fill handle. > > > > > > -- > FORUM RULES (986+ members already BANNED for vi

Re: $$Excel-Macros$$ Excel Symbol.

Rajan Sir, There is limited symbol collection I would like to insert a specific symbol which is designed by me that is not in excel default symbol. How I can insert this?? On Tue, Jan 31, 2012 at 8:27 PM, Rajan_Verma wrote: > Goto Insert->Symbol > > You can insert any symbol from her

Re: $$Excel-Macros$$ Activate The fill Handle

Dear Sir, There is some screen shot I am unable to understand please provide on mail. On Tue, Jan 31, 2012 at 8:28 PM, Rajan_Verma wrote: > HI Raghav, > > See the attached Link > > ** ** > > http://www.excelvbamacros.com/search/label/Activate%20The%20fill%20Handle* > *** > > ** *

RE: $$Excel-Macros$$ excell to pdf

See the final Version Sub CreatePDF() Dim wksSheet As Worksheet Dim blnFlag As Boolean Dim intI As Integer Dim intResult As Byte intI = 0 intResult = Application.InputBox("Type 1 for Entire Workbook and Type 0 For Active Worksheets") If intResult

Re: $$Excel-Macros$$ Query continuous copy paste

Try Option Explicit Sub copycolumstorowsSAS() Dim i As Long For i = 1 To Cells(1, Columns.Count).End(xlToLeft).Column Step 2 Cells(2, i).Resize(6, 2).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1) Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- Fro

RE: $$Excel-Macros$$ Excel Symbol.

You can go to this link http://www.ozgrid.com/forum/showthread.php?t=94991 Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:31 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Sy

$$Excel-Macros$$ How to View formula....

Hi Group, I am working on A official report so frequently I need your help. Thank for your corporation. I have a data having 700 columns but I am unable to identify where formula exist is there any way to identify to seen. -- FORUM RULES (986+ members already BANNED for violation) 1

Re: $$Excel-Macros$$ How to View formula....

Goto Formula-Show Formula On Tue, Jan 31, 2012 at 9:00 PM, bhupendra singh raghav < raghav.bhupen...@gmail.com> wrote: > > > Hi Group, > > > > I am working on A official report so frequently I need your help. > > > > Thank for your corporation. > > > > > > > > I have a data having 700 columns but

RE: $$Excel-Macros$$ How to View formula....

Press CTRL+~ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue/2012 09:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to View formula Goto Formula-Show Formula On Tue, Jan 31, 2012 at 9:00 PM, bh

Re: $$Excel-Macros$$ Query continuous copy paste

@ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns

Re: $$Excel-Macros$$ Query continuous copy paste

Always nice to tell us the ENTIRE problem at the FIRST post. It appears that, if you give proper info, then the last offering by Noorain should work. Don Guillett SalesAid Software dguille...@gmail.com From: Mukesh Kumar Sent: Tuesday, January 31, 2012 9:50 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells

Hi Do you want this? , see the attached =TRANSPOSE(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1)) as CSE Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Jan/Tue/2012 07:40 To: excel-macros@googlegroups.com Subject: Re: $$Exce

$$Excel-Macros$$ based on worksheet attached pdf sent email

Dear all Based on my Worksheets i already having pdf file which i attached and sent respective email address i have email address each sheets K7 How do i attached particular pdf and sent their email id Here is code what i have wrong Sub Send_Email_Current_Workbook() Dim OutApp As Obj

Re: $$Excel-Macros$$ Query continuous copy paste

Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets("Query") ka = .Range("a1").CurrentRegion End With With CreateObject("scripting.dictionary") .comparemode = 1 For c = 1 To UBound(ka, 2)

Re: $$Excel-Macros$$ Query continuous copy paste

Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris wrote: > > Sub kTest() > > Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long > >

Re: $$Excel-Macros$$ Query continuous copy paste

Sub Consolidator() Dim rngSource As Range Dim lngCols As Long, lngRows As Long Set rngSource = Range("A1").CurrentRegion lngRows = rngSource.CurrentRegion.Rows.Count - 1 For lngCols = 3 To rngSource.Columns.Count - 1 Step 2 rngSource.Cells(2, lngCols).Resize(lngRows, 2

Re: $$Excel-Macros$$ Query continuous copy paste

Here's the working model. Have given a button for ease. Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:21 PM, Sam Mathai Chacko wrote: > Sub Consolidator() > > Dim rngSource As Range > Dim lngCols As Long, lngRows As Long > Set rngSource = Range("A1").CurrentRegion > lngRows = rngS

Re: $$Excel-Macros$$ Query continuous copy paste

One of the header is 'No' instead of 'No.' Correct the headers, it should work Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

$$Excel-Macros$$ Re: Solve problem,Plz help me

Dear group, Plz help me ... On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC wrote: > > > Dear All, > > > Can i use pivot table up to data came below type but i required this type > of data > >Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains > Fail

$$Excel-Macros$$ HOW TO OPEN PASSWORD PROTECTED FILE

Hi Experts, i was trying to learn how this dasboard was made, but seems sheet 2 which links to the dashboard sheet is password protected, can anyone crack it for me, thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ pdf to word document

Thank you.. On Tue, Jan 31, 2012 at 8:01 PM, NOORAIN ANSARI wrote: > Dear Veeru, > > You can download free pdf to text converter through below link.. > > http://www.pdf-to-html-word.com/pdf-to-text/ > > On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC wrote: > >> Dear sir, >> >> >>

$$Excel-Macros$$ Solve problem,Plz help me

Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 Req data: indus id Text IN-1008993 DG on load

Re: $$Excel-Macros$$ HOW TO OPEN PASSWORD PROTECTED FILE

Dear Hilary, Please read Forum Rules 3) Don't post questions regarding breaking or bypassing any security measure On Tue, Jan 31, 2012 at 8:49 PM, hilary lomotey wrote: > Hi Experts, > > i was trying to learn how this dasboard was made, but seems sheet 2 which > links to the dashboard sheet is

$$Excel-Macros$$ Solve problem in excel

Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains

Re: $$Excel-Macros$$

And if you still insist :) Sub Consolidator() Dim col As New Collection Dim lngRow As Long Dim strSheetName As String For lngRow = Sheets.Count To 1 Step -1 Application.DisplayAlerts = 0 If Sheets(lngRow).Name <> "Jan1Rake" Then 'ActiveSheet.Name Then

$$Excel-Macros$$ RE: Hands on on Excel

Is there no one who is in this group from Indore? This is the first time I've seen a "no suggestions-no response" situation. Regards, Vani Sharma From: Vani Sharma Sent: Tuesday, 17 January, 2012 7:52 PM To: excel-macros@googlegroups.com Subject: Hands on on Excel All, Looking for

Re: $$Excel-Macros$$ RE: Hands on on Excel

Hi Vani, I know a person which is also member of our Excel macro forum MR.Pankaj Pandey email Id :secrets...@gmail.com provide Advance MS Excel Training. But i m not sure he reside in Indore or Bhopal. Can you touch with him through above mentioned Email ID. -- Thanks & regards, Noorain Ansar

Re: $$Excel-Macros$$ Solve problem in excel

Sub Consolidator() Dim rngSource As Range Dim lngCount As Long Dim strArray() As String With Worksheets("Sheet7") Set rngSource = .Range("A4:C" & .Cells(Rows.Count, 1).End(xlUp)(0).Row) lngCount = Application.CountA(rngSource.Columns(1).Cells) ReDim strArra

RE: $$Excel-Macros$$ How to View formula....

Hi Bhupendra, .Ctrl-F (Find) .Options -> Match Entire Cell Contents, Look in: Formulas .Find What -> =* .Find/Find Next/Find All (I think Find All is only in newer versions of Excel). It will also include text cells that begin with an "=", if you happen to have

Re: $$Excel-Macros$$ based on worksheet attached pdf sent email

The code here is very straight forward and simple to use http://www.excelfox.com/forum/f2/excel-template-macro-sending-mails-attahment-thru-outlook-142/ Check the attachment provided also Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 9:47 PM, chandra sekaran wrote: > Dear all > > Bas

Re: $$Excel-Macros$$ Solve problem in excel

dear sir, can i this pivot tabel after use this vba code but use total vba code and get out put what my requirment data in vba codes On Tue, Jan 31, 2012 at 11:13 PM, Sam Mathai Chacko wrote: > Sub Consolidator() > > Dim rngSource As Range > Dim lngCount As Long > Dim strArray() As

Re: $$Excel-Macros$$ Solve problem in excel

This works on the Pivot table only If you want a macro to create the pivot table also, that can be done. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 11:19 PM, Veeru TOC wrote: > dear sir, > > can i this pivot tabel after use this vba code but use total vba code and > get out put wh

Re: $$Excel-Macros$$ Query continuous copy paste

Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code & for three similar headers another coding is required & so on. Can u give common macro irrespective

Re: $$Excel-Macros$$ learn from basic

2012/1/31 Rajan_Verma > You can visit these sites for advance and Basic VBA.. > > ** ** > > www.ozgrid.com > > www.cpearson.com > > www.akoul.blogspot.com > > www.excelpoweruser.blogspot.com > > www.ozgrid.com > > akoul.posterous.com > > www.mrexcel.com > > www.co

Re: $$Excel-Macros$$ learn from basic

2012/2/1 Bé Trần Văn > > > 2012/1/31 Rajan_Verma > >> You can visit these sites for advance and Basic VBA.. >> >> ** ** >> >> www.ozgrid.com >> >> www.cpearson.com >> >> www.akoul.blogspot.com >> >> www.excelpoweruser.blogspot.com >> >> www.ozgrid.com >> >> akoul.postero

Re: $$Excel-Macros$$ Solve problem in excel

Dear Sir, When i click VBA code i am directly enter to my required data in New sheet from raw data On Tue, Jan 31, 2012 at 11:37 PM, Sam Mathai Chacko wrote: > This works on the Pivot table only If you want a macro to create the > pivot table also, that can be done. > > Regards, >

Re: $$Excel-Macros$$ Query continuous copy paste

Thanks very very much Sam Mathai Chacko sir. This was the resultant code i was looking for. You are marvellous in excel sir. Thanks again. Regards, Mukesh Kumar On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko wrote: > The code I gave was exactly for assigning any number of header groups. > >

Re: $$Excel-Macros$$ Checkbox disappears when Macro Run

Sorry ..late getting back to say that Don your example worked..thanks for your help on this.. On Jan 30, 1:07 pm, "dguillett1" wrote: > UN tested but try > > Sub FilterDeleteColumnN() > Application.ScreenUpdating=false > with Range("N1:N"&Range("N" & Rows.Count).End(xlUp).Row) >    .AutoFilter Fi

$$Excel-Macros$$ stuck with a password protected excel file

Dear All: You guys and gals have been so helpful to all my previous queries and I highly appreciate that... I am stuck again with Excel. This time with a Excel file which was password protected by my ex colleague. He somehow has forgotten the password and it seems there is no way to retrieve the i

Re: $$Excel-Macros$$ stuck with a password protected excel file

3) Don't post questions regarding breaking or bypassing any security measure. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Azeema Sent: Tuesday, January 31, 2012 3:53 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ stuck with a password prote

Re: $$Excel-Macros$$ PivotByMultiSheet2

Thanks Rajan, but same problem continue, its better if you give me an example. On Tue, Jan 31, 2012 at 7:22 PM, Rajan_Verma wrote: > Please try again with attached Add-ins. > > ** ** > > Rajan > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *O

Re: $$Excel-Macros$$ ExcelTest

Dear Noorain, Please provide ansers also. Regards On Tue, Jan 31, 2012 at 7:58 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Excel Test to analyze you excel Skills. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Display numbers in Lakhs

This is really good, but gives answer in million format and not in Indian lakh. Regards On Sun, Jan 29, 2012 at 11:35 AM, Mohammed Muneer wrote: > Mr. Prabhu go to Format cells: > > Go to "Numbers - currency - select Indian RUPEES - Then immediately come > out from currency and go to customs - do

Re: $$Excel-Macros$$ Generating PDF from excel

Generating PDF from excel *Generating PDF from excel..* Sub CreatePDF() Dim wksSheet As Worksheet Dim blnFlag As Boolean Dim intI As Integer

$$Excel-Macros$$ Cloud Storage

Hi Is there anywhere online that MS Excel files can be stored and used. No look-a-likes but Excel. Freeware or low cost. Thanks Charlie -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Password protect hidden sheets

dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan & other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma wrote: >

Re: $$Excel-Macros$$ Password protect hidden sheets

Dear Sam After protecting the sheet i cant hide it, and i want to hide it so other person can not see it, And password is req while unhidding the sheet is because if by mistake someone see the sheet and tries to unhide it , he cant do it w/o password SO is there anything like this ,except macro.

Re: $$Excel-Macros$$ excell to pdf

Dear Rajan I m getting error in below part wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path & "\" & wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _

Re: $$Excel-Macros$$ Re: Solve problem,Plz help me

Instead of Pivot formulas can help u for it, vlookup and & formula On Tue, Jan 31, 2012 at 8:44 PM, Veeru TOC wrote: > Dear group, > > > Plz help me ... > > On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC wrote: > >> >> >> Dear All, >> >> >> Can i use pivot table up to d

Re: $$Excel-Macros$$ Cloud Storage

Yes Cab You can use google docs facility to use online excel. Click here for more information. edutech.msu.edu/*online*/*GoogleDocs*/*GoogleDocs*.html On Wed, Feb 1, 2012 at 12:05 PM, Cab Boose wrote: > Hi > > Is there anywhere online that MS Excel files can be stored and used. N