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
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
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
Dear Anil,
Please explain, we are not getting your point,
On Tue, Jan 31, 2012 at 4:05 PM, anil kumar kmr7a...@gmail.com 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,
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
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 kmr7a...@gmail.com wrote:
Hello sir,
Thanks for response, I attach file.
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
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,
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 )
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
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
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,
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 =
hi Rajan,
lot of thanks it is working fine
Regards
chandru
On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Try this:
** **
Sub CreatePDF()
** **
Dim wksSheet As Worksheet
For Each wksSheet In ThisWorkbook.Worksheets
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 StrPass
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
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
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,
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
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
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
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 savla.kaus...@gmail.comwrote:
Hi Chandra,
It is not working in my system
Cold you please what you did to get it worked properly?
Regards,
Kaushik
--
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
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
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:=True
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
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
Dear sir,
how to convert pdf file to text file...
On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Try this:
** **
Sub CreatePDF()
** **
Dim wksSheet As Worksheet
For Each wksSheet In ThisWorkbook.Worksheets
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
I suggest you NOT do that. Instead delete the blanks and use
datafilterautofilterfilter 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
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 veerub...@gmail.com wrote:
Dear sir,
how to convert pdf file to text file...
On Tue, Jan 31,
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:
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
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
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
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 mukeshka...@gmail.com wrote:
Thanks Noorain Ansari Ji for the solution but it works is working with
this sheet only i.e if the column
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,
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
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
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
raghav.bhupen...@gmail.com wrote:
Hi Group,
I Need a spacial Symbol insert to excel work sheet. there is any opetion.
Please suggest.
Regards
Raghav.
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 violation)
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 rajanverma1...@gmail.comwrote:
Goto Insert-Symbol
You can
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 rajanverma1...@gmail.comwrote:
HI Raghav,
See the attached Link
** **
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 =
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-
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
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)
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 I am unable to
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,
@ 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
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
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:
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
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)
If
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 krishnak...@gmail.com wrote:
Sub kTest()
Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long,
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,
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 samde...@gmail.comwrote:
Sub Consolidator()
Dim rngSource As Range
Dim lngCols As Long, lngRows As Long
Set rngSource = Range(A1).CurrentRegion
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
Dear group,
Plz help me ...
On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com 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
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,
Thank you..
On Tue, Jan 31, 2012 at 8:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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 veerub...@gmail.com
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
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 resp...@gmail.com wrote:
Hi Experts,
i was trying to learn how this dasboard was made, but seems sheet 2 which
links to the
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
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
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
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
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
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
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
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 samde...@gmail.comwrote:
Sub Consolidator()
Dim rngSource As Range
Dim lngCount As Long
Dim
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 veerub...@gmail.com wrote:
dear sir,
can i this pivot tabel after use this vba code but use total vba code and
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
2012/1/31 Rajan_Verma rajanverma1...@gmail.com
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
2012/2/1 Bé Trần Văn betnmtdongna...@gmail.com
2012/1/31 Rajan_Verma rajanverma1...@gmail.com
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
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 samde...@gmail.comwrote:
This works on the Pivot table only If you want a macro to create the
pivot table also, that can be
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 samde...@gmail.comwrote:
The code I gave was exactly for assigning any number of
Sorry ..late getting back to say that Don your example worked..thanks
for your help on this..
On Jan 30, 1:07 pm, dguillett1 dguille...@gmail.com wrote:
UN tested but try
Sub FilterDeleteColumnN()
Application.ScreenUpdating=false
with Range(N1:NRange(N Rows.Count).End(xlUp).Row)
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
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
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 rajanverma1...@gmail.comwrote:
Please try again with attached Add-ins.
** **
Rajan
** **
*From:* excel-macros@googlegroups.com [mailto:
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 mmun...@ccc.com.qawrote:
Mr. Prabhu go to Format cells:
Go to Numbers - currency - select Indian RUPEES - Then immediately come
out from currency and go
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
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
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
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:= _
Instead of Pivot formulas can help u for it, vlookup and formula
On Tue, Jan 31, 2012 at 8:44 PM, Veeru TOC veerub...@gmail.com wrote:
Dear group,
Plz help me ...
On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com wrote:
Dear All,
Can i use
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 swch...@gmail.com wrote:
Hi
Is there anywhere online that MS Excel files can be
87 matches
Mail list logo