Dear Vabs
Very very thanks for reply and sorry to post wrong question.
let me put it again
1 .In a workbook I have 10 sheets out of which 7 are hide.Now I want to
unhide all the sheet at one go is it possible
2.Thanks for coding is there any other way to sort the sheets (other than
Macro)
Regards
Hi Everyone,
Rahul Sharma from New Delhi, working in Maharaja Whiteline Industris Ltd.
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
Hey all new and current posters,
Welcome to excel group,one of the largest online community of excel Fans!
I hope you enjoy your time
Amol shrivastava from Mumbai
On Fri, Sep 21, 2012 at 2:10 PM, Rahul Sharma bindassladk...@gmail.comwrote:
Hi Everyone,
Rahul Sharma from New Delhi, working in Maharaja Whiteline Industris Ltd.
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
Hey all new and current
Hi All
I wonder if its possible to have color coding on REPT function. e.g. I'd like
to have 30 gs in red, 45 gs in green and 25 gs in orange. If you have any
ideas I'll be appreciated.
Pawel
PS. I don't want to use a graph for it.
--
Join official facebook page of this forum @
Hi,
Can any body guide me,how to attach the variables that are used in the
Form and need to consolidate and send to the another user in Mail (without
using outlook).
Thanks,
Vignesh.S.R
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Apology for delay response.
Please find the example of how to use max function with conditonal.
note: these is an array formuale.
Regards
CK
On Fri, Sep 21, 2012 at 3:31 AM, dguillett1 dguille...@gmail.com wrote:
And just HOW is it MORE dynamic??
Don Guillett
Microsoft Excel Developer
Hi
Pl refer following link for more details:
http://www.rondebruin.nl/sendmail.htm
Rgds//Vabs
On Friday, September 21, 2012 2:37:26 PM UTC+5:30, Vignesh S R wrote:
Hi,
Can any body guide me,how to attach the variables that are used in the
Form and need to consolidate and send to the
Hi
Code for unhiding all sheets at once..
Sub WorksheetUnhide() Dim WS_Count As Integer Dim i As Integer
WS_Count = ActiveWorkbook.Worksheets.Count For i = 1 To WS_Count
Sheets(i).Visible = True Next iEnd Sub
I dont think any other way to sort all sheets without macro.
Hi,
In last code given put Y agaist promoter u will get data for only
promoters..
Rgds//Vabs
On Friday, September 21, 2012 10:10:50 AM UTC+5:30, amar takale wrote:
Hi Vabz
I create file with index formula now I want to In Output(2) sheet all
promoter in one shot for all Qtr.I used Data
Thanks so much Vabs for making your valuable time helping out me
working fine !!
cheers
On Fri, Sep 21, 2012 at 11:20 AM, Vabz v...@vabs.in wrote:
Hi Jayaprakash S,
Your query was challenging for me hence i tried solving it..
Read Instruction sheet carefully before running macro on
Cheerz
Thanks for acknowledgment..
Rgds//Vabs
-Original Message-
From: Jayaprakash S bhat.jayaprak...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 21 Sep 2012 15:17:30
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Dear Friends,
I have an excel file which I saved working in Xlsb version to save space on
email. Will it have any impact on formula results or anything because of xlsb
version?
Best Regards,
Amit
Disclaimer: This message and its attachments contain
Dear Sirs,
I show the *Chandoo.Org. *There is nice example but I can not understand
how to prepare it.
Would u Please explain me the steps with a single example.
Thanking you
Regards,
Sanjib
-- Forwarded message --
From: Kuldeep Singh naukrikuld...@gmail.com
Date: Fri,
the differences between xlsx and xlsb is the ability to save macros with
the file.
it has no affect on Excel formulas or functions, unless they're Custom
functions (User Defined Functions)
The differrence between xlsm and xlsb is that xlsb is a binary format,
while .xlsm allows the use of xml.
Very Very thanks sir.
On Fri, Sep 21, 2012 at 3:13 PM, Vabz v...@vabs.in wrote:
Hi
Code for unhiding all sheets at once..
Sub WorksheetUnhide()Dim WS_Count As IntegerDim i As Integer
WS_Count = ActiveWorkbook.Worksheets.**CountFor i = 1 To WS_Count
Sheets(i).Visible = True
Thanks a lot Paul.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: 21 September 2012 16:58
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU); Amit Desai (MERU)
Subject: $$Excel-Macros$$ Re: xlsx Xlsb
You cannot do either without a macro.
You have to have at least one sheet visible.
To hide or unhide all sheets you can use:
For sht = 2 to sheets.count
sheets(sht).visible = false '(or true)
next sht
To sort sheets, I would first load the sheet names into an array,
sort the array,
then
Dear Sanjeeb,
Please subscribe email updates from Chandoo.org - Learn Excel Charting
Online http://chandoo.org/wp
and learn step by step.
On Fri, Sep 21, 2012 at 4:39 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sirs,
I show the *Chandoo.Org. *There is nice example but
Hellow Guys,
While copying formula in my excel work book, formula is taking fixed
reference but not the relative reference.
while saving the file, it gets automatically corrected.
Pls. clarify what is the issue here?
thanks in advance
regds.,
Johnson
--
Join official facebook page of this forum
Hi
Its not possible i guess..
But you can do with UDF..
for multiple fonts/colours etc in a single cell you use the
cells(x,y).characters(start,length).font function
The following code makes the first 10 characters BOLD and colour 56 and the
rest not bold and colour 12
With
Hi Joshnson,
Which version of excel you are using?
Rgds//Vabs
On Friday, September 21, 2012 6:20:20 PM UTC+5:30, johnson wrote:
Hellow Guys,
While copying formula in my excel work book, formula is taking fixed
reference but not the relative reference.
while saving the file, it gets
Thanks a lot for that, I didn't thnik is possible but I needed to try.
Thanks
Pawel
From: Vabz v...@vabs.in
To: excel-macros@googlegroups.com
Cc: pawel lupinski lupins...@yahoo.com
Sent: Friday, September 21, 2012 2:01 PM
Subject: $$Excel-Macros$$ Re: color
Send me you file as you have it now and I’ll give you a nice solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: resp...@gmail.com
Sent: Friday, September 21, 2012 3:02 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time high
Use conditional formatting with Len() FUnction
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vabz
Sent: 21 September 2012 6:32
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Subject:
saving file will CALCULATE
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: johnson john
Sent: Friday, September 21, 2012 7:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula not being copied down
Hellow Guys,
While copying formula
hi experts,
please help me in this concern, i have data spread from A to AB columns
from one of the column i want to apply filter select one region in column e
against that region i want to place as excluded in another column AS.
can any one help me with vba code in this.
i am attaching
HI
Try this..
Sub Copy_Filtered_Cells()
Dim SourceRange As Range, TargetRange As Range
Dim Cell As Range
If ActiveSheet.FilterMode = True Then
Set SourceRange = Range(CopyRange)
Set TargetRange = Range(PasteRange)
With Application
ScreenUpdating = False
For Each Cell In
Hi John,
Please send a sample work book.
Regards,
Kuldeep Singh
On Fri, Sep 21, 2012 at 7:49 PM, dguillett1 dguille...@gmail.com wrote:
saving file will CALCULATE
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* johnson john johnsond...@gmail.com
Hi
Company name is final drill down filters which you have created there is
no name defined agst yor end result viz. 3M India Ltd.
The given method is used to create dependent dorp down list and you are at
the last step.
There you have to use formula vlookup to get result in cell
Wow.Vabs. This will be grt.Now I know my mistek
Thanks a lot very much
Best Regards,
Amar
On Sat, Sep 22, 2012 at 11:15 AM, Vabz v...@vabs.in wrote:
Hi
There was error in formula..
Pl check..
Rgds//Vabs
On Saturday, September 22, 2012 10:58:59 AM UTC+5:30, amar takale
30 matches
Mail list logo
