Hi Ashish,
Thanks for the reply. If u don't mind can u pls help me with the code which
has in attached excel file, because I am little bit confused with both the
codes.
Thanks in advance.
On Tue, Aug 9, 2011 at 2:32 AM, ashish koul wrote:
> check this
>
> http://www.rondebruin.nl/notes.htm
>
>
On 6 Aug., Excel 009 wrote:
> > > I have the following data and want to create a scatter chart.
> > > I am using either 2003 or 2007.
> > >
> > > Person X1 X2
> > > -- --- ---
> > > a2 4
> > > b8 2
> > > c9 3
> >
Please Attach Your excel file..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Wednesday, August 10, 2011 10:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached
Your can probably use the following Code.
Sub LockMacro()
Dim dt As Date
Dim i As Integer
Dim nr As Integer
Dim r As Range
i = 6 'range->F
While Cells(4, i) <> "" And Cells(1, i) < dt '---Row4
i = i + 1
Wend
Set r = Range(Cells(1, 1), Cells(30, i - 1))
Dear Sir
CTRL+PageUP/PageDN may be tried for a change
On Wed, Aug 10, 2011 at 2:59 AM, Dsastray wrote:
> I would like to be able to press a hotkey and have a sheet pop up that
> allows me to navigate to any sheet in my workbook. (A shorter version
> to bring up the "Activate" dialog you get wh
Hello EXPERTS
I have a workbook wherein there are thee sheets (Database, Mapping &
Employee Name). In the Database sheet, I pull out the data from the tool and
put that data in Database sheet. The mapping sheet consist a list of
employee who are basically associated with one group or more than one
See the attached file, Press Shift+CTRL +S ,
Hope it will help you
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dsastray
Sent: Wednesday, August 10, 2011 2:59 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Want a short
can you attach the sample worksheet
On Wed, Aug 10, 2011 at 12:50 AM, AJ wrote:
> There are dates in calendar order stored in row 4, beginning in column
> F through column BR. How can I write a code so that it locks a
> certain amount of cells below the date if it occurs in the past. For
> exa
The add in is awesome, but I can't see all the details because its
showing black on my PC too...It would be very nice and kind if you
could post an updated version
Thanks
On Aug 9, 3:01 am, "Rajan_Verma" wrote:
> Hi Anil,
>
> Later I will provide you a updated Code , I had created that code A
I would like to be able to press a hotkey and have a sheet pop up that
allows me to navigate to any sheet in my workbook. (A shorter version
to bring up the "Activate" dialog you get when you right click on tab
arrows and select "More Sheets...")
For simplicity sake, we'll say I'm using the follow
There are dates in calendar order stored in row 4, beginning in column
F through column BR. How can I write a code so that it locks a
certain amount of cells below the date if it occurs in the past. For
example: January 14th is in cell O4. If todays date was January
14th, i would want to lock a
Hey Jaysheel,
-- Forwarded message --
From: Alp Management Consultants Pvt Ltd
Date: Tue, Aug 9, 2011 at 6:02 PM
Subject: Excellent Opportunity for Vb in Pune&U.K
To: noorain.ans...@gmail.com
The sender of this email is registered with Naukri.com as Alp
Management Consultants
hi Everyone,
Please let me know do we have any opening in Pune for MIS
On Tue, Aug 9, 2011 at 4:33 PM, Venkat CV wrote:
> - Original message
> From:""I View Technologies""< care...@i-viewtechnologies.com >
> Date: 9 Aug 11 15:59:19
> Subject: Opening for MIS Executive
> To:
>
Thanks for the reply...the issue is all previous documents (to which there are
many 1000's are in Word. My predecessor however wrote work instructions in
Excel, but all written procedures should really be in a Word processing
program, hence my question!
There are still several hundred Excel
try
Sub GetUnique()
Application.ScreenUpdating = False
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
'get unique
Cells(2, 1).Resize(lr).AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("D2"), Unique:=True
'sort
Cells(3, "d").Resize(lr).Sort Key1:=Range("D3"), _
Order1:=xlAscendi
hu
On Tue, Aug 9, 2011 at 4:06 AM, dguillett1 wrote:
>
> Homework?
>
> -Original Message- From: XLS S
> Sent: Monday, August 08, 2011 3:38 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Question
>
> Q-1 ) Can I write VBA code to protect or unprotect my VB Pr
Hi,
its better to use advance filter Manually again and again if we are
Increasing Our Range,
Suppose we need a List Validation of Unique Number From a Range , we can use
this Function To Get Unique Values instantly , See the attached File For
Example :
Manual Work in Excel is not in our scop
Will data>advanced filter>unique work for you?
-Original Message-
From: Rajan_Verma
Sent: Tuesday, August 09, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ UNIQUE values in Array
Hi,
I was trying to Get Unique List by Using Array Function and the Output i
I don't have a Very Good Experience with Charting with VBA and I have tried
this Macro Exist in trail mail, its giving an error "Series Order Must be An
Integer 0 to 255" , Can anybody explain this :
Regards
Rajan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros
On 6 Aug., Excel 009 wrote:
> Hi All,
>
> I have the following data and want to create a scatter chart. I am
> using either 2003 or 2007.
>
> Person X1 X2
> -- --- ---
> a2 4
> b8 2
> c9 3
> d1
Hi,
I was trying to Get Unique List by Using Array Function and the Output is
below , it's a array Function To Get Unique values List From Given Range
Function GetUniqueList(rng As Range) As Variant
On Error Resume Next
Dim Arr() As Variant
Dim cell As Range
Dim r, c As Integer
Can you clarify with examples
From: Sunny
Sent: Tuesday, August 09, 2011 5:51 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compute combinations, permutations
Hi ,
I am very new to combinations, permutations in Excel, Need help on the attached
file.
I have 3 different compon
Hi ,
I am very new to combinations, permutations in Excel, Need help on the
attached file.
I have 3 different component(s) with 2 different supplier(s) with multiple
cavity.
I need all combinations & permutations with respect part.
Eg.,
A -> Part A, Tool 1, Cavity 1, I -> Part B, Tool
try
$F$4581="Lost")+(Data!$F$2:$F$4581="
From: Shiek Peer Mohd
Sent: Tuesday, August 09, 2011 1:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ sumproduct issue
Hi Experts,
I have the issues in using the multiple criteria in sumproduct. Sample file
attached.
Regards,
Sh
See if this helps, haven't tested it though.
On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need one help.
>
> I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
> should pop up. Please help me.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
--
- Original message
From:""I View Technologies""< care...@i-viewtechnologies.com >
Date: 9 Aug 11 15:59:19
Subject: Opening for MIS Executive
To:
For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079 Personal Folde
26 matches
Mail list logo
