Hello Shankar,
You can use Format() in VBA.
txttotser.Text = Format(txttotyrs.Value, 00) Format(txttotmths.Value,
00) Format(txttotdays.Value, 00)
To use Application.Worksheetfunction.Text, it would go like:
txttotser.Text = Application.WorksheetFunction.Text(txttotyrs.Value, 00)
thanks EVERY BUDDY.
On Sun, Jan 29, 2012 at 10:32 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
See attached sheet.
On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee
yasir.shah...@gmail.comwrote:
Respected Masters,
Kindly check attached sheet. i need Time calculate in Hours. hopefully
Hi Darwin,
Your ElseIf Not. lines are redundant, you can simply say Else for those
lines, since that is what the ElseIf line already does.
In the line
.Cells(r, 14).Value = VBA.Left(.Range(E r), (InStr(.Range(E r), X)
- 1))
If the cell at .Range(E r) does not contain an X, then Instr()
Hi Asa,
First thank you very much for suggesting why there is an error. As a newbie
in VBA programming, I really dont know much about OPTION EXPLICIT, only to
the extent it requires us to define variables in every procedure.
When i put OPTION EXPLICIT in original code, I find there is error
Still your problem is not being understand
I m not getting exactly what u want
On Mon, Jan 30, 2012 at 1:31 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
**
plz, check I write clearly now. I was little busy doing something other
than this.
I need the same in formula.
Regards,
Muneer,
Thank you asa.
On Mon, Jan 30, 2012 at 1:40 PM, Asa Rossoff a...@lovetour.info wrote:
Hello Shankar,
You can use Format() in VBA.
txttotser.Text = Format(txttotyrs.Value, 00) Format(txttotmths.Value,
00) Format(txttotdays.Value, 00)
** **
To use
Hi,
Is there a difference between these 2 methods of assignation :
Range method :
Dim MyArray() as long, rCnt As Long, cCnt As Integer
With Sheet1.Range(A1:C5)
ReDim MyArray(1 To .Rows.Count, 1 To .Columns.Count)
MyArray = Sheet1.Range(A1:C5)
End With
Loop method :
with
=B3*($F$6/100)
and copy down
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Monday, January 30, 2012 2:01 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ IS.xls
plz, check I write clearly now. I was little busy doing something other
oops. change o1 to p1
Application.DisplayAlerts = True
Columns(f).Copy Range(p1)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Sunday, January 29, 2012 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Splitting the values from 1 cell to 2
Hi Paul, Thanks a lot for your explanation first on how to use option
explicit. Let me try the code when I m back to office!!
2012/1/30 Paul Schreiner schreiner_p...@att.net
First of all, I'll explain Option Explicit.
In ANY programming language, you have the ability to define variables to
It appears that this will, indeed, be very useful. Thanks from Texas
Don Guillett
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Monday, January 30, 2012 9:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like
Try this:
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to
Pick Downloaded Bills
=INDIRECT(' A2'!E MAX(IF(LEN('dia 28 en8 bgt'!A:J)0,ROW('dia 28 en8
bgt'!A:J with CSE
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Jan/Wed/2012 11:12
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Import data
Indirect only works with external sheets that are OPEN. So, if you want to use
formulas for this I suggest using edit replace to change the formula as needed.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, January 30, 2012 10:31 AM
To:
First of all, your first method has very less likelihood of working. In
other words, you cannot pass a range of values once you have defined the
dimensions of the array.
If you had defined the variable as a variant, it would have worked.
So basically,
Dim MyArray as Variant
With
I have this weird problem that whenever I run a macro I have the
clears some data.. the checkbox control at the top
disappears..Stranger still is if I drag the last row of data or copy
and paste in a new row the checkbox reappears.. I have already tried
changing the format control to the option
Try adding a line at the end of the code
Application.ScreenUpdating=True
Regards,
Sam Mathai Chacko
On Mon, Jan 30, 2012 at 8:59 PM, Thomp williamth...@gmail.com wrote:
I have this weird problem that whenever I run a macro I have the
clears some data.. the checkbox control at the top
For deleting all files from a folder..
Sub deleteFiles()
Dim MyFile As File
Dim MyFolder As Folder
Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject
Set MyFolder = fso.GetFolder(YourFolderPath)
For Each MyFile In MyFolder.Files
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.contextures.com
www.rondebruin.nl
peltiertech.com
chandoo.org
www.mvps.org/links.html
Use this
=OFFSET(INDEX(Data!A:A,MATCH(Dashboard!E3,Data!A:A,0),1),2,MATCH(Dashboard!F
2,Data!$A$1:$L$1,0)-1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of John A. Smith
Sent: Jan/Thu/2012 08:49
To: excel-macros@googlegroups.com
Subject:
Try this:
Sub GetOutput()
Dim rngFrom As Range
Dim rngTo As Range
Dim rngCell As Range
Dim wksOutput As Worksheet
Dim rngCell2 As Range
Dim lngRow As Long
Set rngFrom = Range(rngFrom).Resize(Range(rngFrom).End(xlDown).Row -
(Range(rngFrom).Row - 1),
Try this:
Sub CreatePivot()
Dim wksPivotSheet As Worksheet
Dim wksWest As Worksheet
Set wksPivotSheet = ThisWorkbook.Worksheets.Add
Dim oPC As PivotCache
Dim oPT As PivotTable
Dim oWS As Worksheet
Set oWS = ActiveSheet
Set oPC =
Here is the code Sam..when I added your code line it eliminates all
the lines not just those completed
Sub FilterDeleteColumnF()
Dim Lastrow As Long
Range(N:N).AutoFilter Field:=1, Criteria1:=þ
Lastrow = Range(N Rows.Count).End(xlUp).Row
If Lastrow 3 Then Range(A3:A
Question Experts:
I receive a nightly data dump from one of my vendors which is stored
in a shared drive. For example, Jan01_2012.csv, Jan02_2012.csv,
Jan03_2012.csv, etc.
Is there a way I can take each file and append the data into one
file? I have a file for each day from 9/22/2011 thru
thanks
...the base 1 array is a mistake, i usually work with base 0, so it
would then be :
redim MyArray(.Rows.count-1, .Colymns.Count-1)
then...
for i = 1 to .rows.count
for j = 1 to .columns.count
MyArray(i-1, j-1) = ...
I think it's better like that
On Jan 30, 4:59 pm, Sam Mathai Chacko
=(ROUNDDOWN(G7,0)+H7-ROUNDDOWN(E7,0)-F7)*24
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Jan/Sun/2012 07:29
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Hours calculate highlighted colum
Just to be clear, in
UN tested but try
Sub FilterDeleteColumnN()
Application.ScreenUpdating=false
with Range(N1:NRange(N Rows.Count).End(xlUp).Row)
.AutoFilter Field:=1, Criteria1:=ş
.offset(1).rows.delete
.AutoFilter
end with
Application.ScreenUpdating=True
end sub
On Jan 30, 11:10 am, Sam Mathai Chacko
Dim objDic as object
Set objdic= CreateObject(Scripting.Dictionary)
ObjDic.add Key,values
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of IF
Sent: Jan/Sat/2012 02:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Adding an Item to a
You can use this for text also
Sub isExist()
On Error Resume Next
If WorksheetFunction.Match(Range(rngValues).Text,
Worksheets(Sheet2).Range(d4:d10), 0) Then
If Err.Number = 1004 Then
Err.Clear
On Error GoTo 0: On Error GoTo -1
MsgBox Values not found
Hi Group,
Please call on 8860604189 Mr.Bhupendra Raghav
raghav.bhupen...@gmail.com
Regards
Rajan verma
From: Raghav [mailto:bhupendra.rag...@smaca.com]
Sent: Jan/Tue/2012 12:50
To: rajanverma1...@gmail.com
Subject: FW: Employee Referral Scheme..Buddy Get Buddy
Please find
I'd rather go with
for i = 0 to .rows.count-1
for j = 0 to .columns.count-1
MyArray(i, j) = ...
Regards,
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 12:23 AM, bpascal123 bpascal...@gmail.com wrote:
thanks
...the base 1 array is a mistake, i usually work with base 0, so it
would then be :
I think he is talking abt Focus event ..
If working with VBA FORm you can use Activate event as setFocus and
terminate as lostFocus event.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Jan/Sun/2012 11:11
To:
Depending on the volume of data, you can choose between Excel or Access.
However, the point is, you'd need a macro loop to run through each of those
files and append it to access table, or to Excel sheet.
Regards,
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 12:20 AM, RockyFontane
OR, you probably are not intending a Dictionary object, but a collection
object.
Sam
On Tue, Jan 31, 2012 at 12:39 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Dim objDic as object
Set objdic= CreateObject(“Scripting.Dictionary”)
ObjDic.add Key,values
** **
*From:*
Position Level: Advance Analyst (1-3 yrs) / Sr. Analyst (3-5 yrs)
Job Location: Gurgaon
Shifts: Day shifts
Must have: Ms Access + VBA (Know how to code macros) with good communication
skills.
Job Description:
Perform detailed reviews and update of Access financial models
Job Description
Hello,
Genpact is looking for MS Access Professionals -
BE/B.Tech/MCA or equivalent
.3 to 5 years of experience in MS Access (Forms, Database and Reports), VBA,
Visual basic and SQL Server, and Stored Procedures
.Thorough understanding of building user
No,
You can not record macro like this.. As noorain Explain in the example you
can Execute any Exe File with shell Command..
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kasireddy Amarender
Sent: Jan/Mon/2012 11:49
To:
Thanks Sam - the data is small (approx 100 rows per day). Can anyone
provide me with a macro that would accomplish that task? I'll change
the file names of course. Let me know. Thanks!
On Jan 30, 2:30 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Depending on the volume of data, you can
WorksheetFunction.Text(1,) = 0001
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Mon/2012 11:32
To: excel-macros@googlegroups.com; Sam Mathai Chacko
Subject: $$Excel-Macros$$ prefix 0 problem
Dear Experts
In the
You can use Split method and Assign split values to range
Range(A1:C1)=split(A:B:C,:)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Jan/Mon/2012 08:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Can u attached sample file.. I want to look at that
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Thomp
Sent: Jan/Mon/2012 08:59
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Checkbox disappears when Macro Run
I
Would be better if you post a sample of your master file, and one daily file
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 1:16 AM, RockyFontane vtorral...@gmail.com wrote:
Thanks Sam - the data is small (approx 100 rows per day). Can anyone
provide me with a macro that would accomplish that
Kasireddy,
In my opinion the best way to automate windows in general is with the
AutoHotkey script language. It includes a macro recorder, and you can
modify the resulting scripts as you like. You can also compile them into
EXE files. If desired, you can call your script from VBA as in the CALC
Hi All,
Dear friends, I am looking for a pitch/presentation which represents
the value to data in the organisation and how data can transform the
decision making abilty of an organisation and drive growth. Moreover,
what are the best analytics ability that an organisation can have.
If you have a
Additionally, this is required for pure marketing and sales, so that I
can attract the team and the leadership on the importance of data and
analytics and also how it can help us improve on efficienc and
forecasting. Any help in this regard will be deeply appreciated.
Regards,
Rohan.
--
FORUM
Nice Work. Thank you !!
Rohan.
--
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 answered.
2)
Thnks
On Mon, Jan 30, 2012 at 12:43 AM, Asa Rossoff a...@lovetour.info wrote:
Thanks for posting a useful, practical application, Noorain.
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* Sunday,
Dear Group,
Please find attached Excel Test to analyze you excel Skills.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
--
FORUM RULES (986+ members
Thanks Asa,
I'll check this and keep you posted.
Best regards,
Amar
On 31/01/2012, Asa Rossoff a...@lovetour.info wrote:
Kasireddy,
In my opinion the best way to automate windows in general is with the
AutoHotkey script language. It includes a macro recorder, and you can
modify the
That's what I want!
Thanx.
Regards,
Muneer,
CC...
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Monday, January 30, 2012 7:35 PM
To: excel-macros@googlegroups.com
Subject: Re:
Dear Excel guru,
I have a data like below
Admin. 5
Household.7
Production.2
Stores. 3
Admin. 2
Household.3
Production.1
Stores. 5
Admin. 6
Household.1
Production.3
Stores. 2
Now I want here the minimum no of
Dear Sandeep,
Please try it,,
=SMALL(IF($A$1:$A$14=A17,$B$1:$B$14,),1) with ctrl+Shift+enter(CSE)
See attached sheet.
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Hi Rohan,
If you need the slides you have to relay on google only. Because i
never come across these type of basic slides. But with right data you
can predict lots of things like simple will be churn,your sales/
Profit driver,forcasting, correlation,default rate,survival rate of
your
Dear Sandeep,
You can also use...
=MIN(IF($A$1:$A$14=A17,$B$1:$B$14,)) with ctrl+shift+enter
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Jan 31,
Dear all,
Here with attached salary data and payslip format i have data sheet
that is containing emp salary details i have sheet Payslip . this
is containing Payslip formati need macro for this only once i will
run macro all the employee should generate this format and
Hi Group,
I want to extract my data horizently according to my header from vertical
row data.
See attached sheet for more clearity.
Thanks in advance
With Regards,
Pravesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Hi Group,
I need to extract min max value of a cell.
Sample sheet is attached herewith.
Thanks in advance.
With Regards,
Pravesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi Group,
I am unable to extract AHT Column data through Vlookup.
Please sove my query..
Thanks in Advance
With Regards,
Pravesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Dear Pravesh,
Please use..this one..see attached sheet..
=INDEX($D$2:$D$10,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0))
with ctrl+shift+Enter
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
=OFFSET($D$1,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0),0)
With ctrl+shift+enter
On Tue, Jan 31, 2012 at 11:24 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Pravesh,
Please use..this one..see attached sheet..
attachment Missing
On Tue, Jan 31, 2012 at 9:26 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi Group,
I want to extract my data horizently according to my header from vertical
row data.
See attached sheet for more clearity.
Thanks in advance
With Regards,
Pravesh
--
FORUM
hi rajan,
Macro is protected can you sent with protection
regards
chandru
On Tue, Jan 31, 2012 at 11:18 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi Chandru
I have create a macro for the same before some time ,You can modify this
macro according to your Requirement… Please see
Great
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Tue/2012 11:44
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Income tax calculation for employee :- Usefull to
our Group Member
Dear all
I found this
very usefurl site..
On Tue, Jan 31, 2012 at 11:43 AM, chandra sekaran duraichan...@gmail.comwrote:
Dear all
I found this income tax calculation from ynithya.comthis is realy
use full to our group member
If you want me to send you a new version whenever I update, please
send a
Thanks rajan
On Tue, Jan 31, 2012 at 11:46 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi Chandru
Please find unprotected version
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
You just need to change Range reference in Macro Code..
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Tue/2012 11:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Payslip macro need
Thanks
For Min
=MIN(INT(MID(A2,ROW(INDIRECT(1:LEN(A2))),1)))
For Max
=MAX(INT(MID(A2,ROW(INDIRECT(1:LEN(A2))),1)))
Use with CSE
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of PRAVESH KUMAR
Sent: Jan/Tue/2012 09:42
To:
Dear Team
Kindly let me know if i have a workbook having 3 sheets in it, and i hide
2 sheets of it and when next time i unhide those sheets a password box
gets open and without password it can't be unhide
I have excel 2007 version
If any more details req kindly let me know
Regards
Priyanka
You can Protect Workbook. After hiding Worksheets..
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of PrIyAnKa
Sent: Jan/Tue/2012 12:05
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Password protect hidden sheets
Dear Team
Dear Pravesh,
Try it..UDF
*For Minimum Value..*.
Function Minval(x As String)
Dim i As Integer, minx As Integer
For i = 1 To Len(x)
If IsNumeric(Mid(x, i, 1)) Then
minx = Mid(x, i, 1)
Exit For
End If
Next
For i = 1 To Len(x)
If IsNumeric(Mid(x, i, 1)) Then
If Mid(x, i, 1) minx Then
Good afternoon all.
Thank you very much Sam and Asa. Actually I am not so sound in code
building. I am working in a office and trying to minimise and simplifying
my dealing work by automating the data entry. For that I joined for VB 6.0
and built some programs but many were failed. After a
thank you so much
On Tue, Jan 31, 2012 at 7:53 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Thnks
On Mon, Jan 30, 2012 at 12:43 AM, Asa Rossoff a...@lovetour.info wrote:
Thanks for posting a useful, practical application, Noorain.
Asa
** **
*From:*
Hi Priyanka,
I think you can't unhide sheet without password..
refer to below link..
http://www.howtogeek.com/howto/14160/hide-and-unhide-worksheets-and-workbooks-in-excel-2007-2010/
On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Team
Kindly let me know if i
hi.
attach data for mailer. we want macro for sent data for anil.
Regards
Anjul.
--
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
Can you send the output of mail ..
What will the format?
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 Mailer data
hi.
attach
Thanks Noorain its working great!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 31 Jan 2012 10:56:00
To: excel-macros@googlegroups.com
Reply-To:
Press Shift + Ctrl P and add the ranges to list box.. Range should have same
column.. Not a single heading should be blank..
First it copy all range data to A temp sheet and Create a pivot table..
then it will delete that temp sheet..
With Pivot table all data will store in Pivot Cache
Thanks noorain...
Regards
anjul
On Tue, Jan 31, 2012 at 12:51 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Anjul,
Please try it and change email Id as per your requiremrnt..
Sub maildata()
Dim a As Workbook
Dim data As Range
Set data = ThisWorkbook.Sheets(1).UsedRange
Hi expert,
Can u make Pareto-chart- for attach data.
Regads,
Anjul
--
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
First assign a password to the sheet before hiding it, so that when other
user unhide's it, the sheet will be in read only mode and if the user want
to do changes it will prompt for password.
You can do this by using keyboard shortcut: ALT+T,P,P and set the password.
Hope it will help u.
On
Thanks Rajan, but data not display in PivotSheet, anything wrong with me?
Ashish Bhalara
On Tue, Jan 31, 2012 at 12:59 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Press Shift + Ctrl P and add the ranges to list box.. Range should have
same column.. Not a single heading should be blank..
81 matches
Mail list logo
