Actually, the other suggestion is better
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: venkat1@gmail.com
Sent: Thursday, March 15, 2012 9:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Vba code to count
Start by looking in the help index for VLOOKUP, make a table and apply the
formula.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: krabbus
Sent: Thursday, March 15, 2012 7:03 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ As
Glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ChilExcel
Sent: Thursday, March 15, 2012 5:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sum hours weeks
Excellent !!! dguillett1 is what I need
Thank you very much for your
Are you saying that if
b7=annual
b8=quarterly
b5=5000
you want d13:d15 to be ___5000?
or ??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Friday, March 16, 2012 9:51 AM
To: excel-macros
Subject: $$Excel-Macros$$ FVOA -withdrawal pro
if you are saying you put a value in d13 then maybe b14 formula copied
down is??
=IF(A14="","",FV($E$2,A14,,-$B$2+SUM($D$13:D13),1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Friday, March 16, 2012 9:51 AM
To: excel-macros
What we have here is “a failure to look in the help index”
excel 101
=LOOKUP(E6,G5:G12)
=MATCH(E6,G5:G12)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Scruffy Huffy
Sent: Saturday, March 17, 2012 6:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
the simplest is
sub nameit
cells(7,4).name="whateveryouwanttonameit"
end sub
=whaeveryounamedit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: tangledweb
Sent: Sunday, March 18, 2012 5:22 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Exce
See attached
=SUM(1*(F2<$F$2:$F$9))+1+IF(ROW(F2)-ROW($F$2)=0,0,SUM(1*(F2=OFFSET($F$2,0,0,INDEX(ROW(F2)-ROW($F$2)+1,1)-1,1
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Secret Shot
Sent: Sunday, March 18, 2012 4:02 PM
To: excel-mac
Shorter. Also enter using CSE (ctrl+shift+enter)
=COUNTIF($F$2:$F$9,">"&F2)+SUM(IF(F2=$F$2:F2,1,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Secret Shot
Sent: Sunday, March 18, 2012 4:02 PM
To: excel-macros@googlegroups.com
Subj
If xl2003,
tools>options>security> remove
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Chidurala, Shrinivas
Sent: Monday, March 19, 2012 9:21 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Error while running macro
Divaker,
I am facin
One possible formula to use vlookup if there is a match. See att
=IF(ISNA((MATCH($J4,'Week One'!$A:$A,0))),0,VLOOKUP($J4,'Week
One'!$A$2:$C$118,2,0))+IF(ISNA((MATCH($J4,'Week
Two'!$A:$A,0))),0,VLOOKUP($J4,'Week Two'!$A$2:$C$118,2,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...
A small primer in the use of specialcells
Sub DeleteBlanksUsingSpecialCellsSAS()
Cells.SpecialCells(xlBlanks).Delete
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Tuesday, March 20, 2012 2:13 AM
To: excel-macros@googlegroups.com
S
You may prefer using radio button instead.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Tuesday, March 20, 2012 1:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ checkbox query
Dear experts
I have attached an excel file c
>From looking at your files it appears that you haven’t given us much info to
>go on.
what data do you want from the data file and where do you want it?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Monday, March 19, 2012 11:51 PM
To: excel-m
Using the sub below,anytime you make an entry in col A you get now in col B.
It’s automatic.
Goes in the sheet module. See attached.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 _
Or Target.Row < 2 _
Or Target.Column <> 1 Then Exit Sub
If Len(Application.Trim(Target))
Sounds like homework
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Atul Patel
Sent: Tuesday, March 20, 2012 4:24 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:Help to find position of a particular number in a
given data set
Hi,
I need help
and Time
macro.
Thanks @ Ranjan, but I don't track it in MS-Access File, can you incorporate
this codes for MS-Excel?
Thanks @ dguillett1, but I'm not able to use the same code for Logout time
tracking in a different column, can you please help me once again?
@ Abdulgani Shai
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range("a2:a10")
c = Application.Trim(c)
fs = InStr(c, " ")
ls = InStrRev(c, " ")
c.Offset(, 1) = Mid(c, fs, ls - fs)
Next c
Columns("b").AutoFit
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
You are doing a good job with a good forum.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Wednesday, March 21, 2012 5:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ** FIVE YEARS COMPLETION**THANK YOU**
Dear member
In the absence of a better explanation you might try sitting on them
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Sent: Thursday, March 22, 2012 12:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compress of images
Dear Group
I already posted a reply
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range("a2:a10")
c = Application.Trim(c)
fs = InStr(c, " ")
ls = InStrRev(c, " ")
c.Offset(, 1) = Mid(c, fs, ls - fs)
Next c
Columns("b").AutoFit
End Sub
Don Guillett
Microsoft MV
e
dguille...@gmail.com
From: Indrajit $nai
Sent: Thursday, March 22, 2012 1:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.
@ dguillett1, PFA for your reference.
On Thu, Mar 22, 2012 at 4:28 AM, dguillet
good to see this resolution but can anyone explain this in simple way
Regards
Modi
On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 wrote:
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range("a2:a10")
c = Applicat
And what if both?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vinod rao
Sent: Thursday, March 22, 2012 9:35 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel conditional formatting-Urgent plz
Hello Experts,
I need a conditional cell color
I would suggest a table such as with numbers in col 1 and d in col2 I col 3,
etc (easier to change in future)
then use match index
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: LAKSHMAN PRASAD
Sent: Friday, March 23, 2012 2:25 AM
To: excel-macros@googlegroups.co
From the comments, I only wish I could read it.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, March 22, 2012 1:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो
गय
http://contextures.com/xlDataEntry02.html#Fill
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Jim Schug
Sent: Thursday, March 22, 2012 8:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Simple VBA to Fill in blanks
Hi,
I'm nearly brain dead (tir
Glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Thursday, March 22, 2012 5:59 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.
Thanks @ dguillett1
...its not easy to reproduce a masterpiece
2012/3/23 dguillett1
From the comments, I only wish I could read it.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, March 22, 2012 1:42 PM
To: excel-macros@google
Makes me wonder what this is for. Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Pascal Baro
Sent: Friday, March 23, 2012 8:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Cash allocation - your advice
Hi Cyberspace,
Please find a wo
I haven’t followed this but I think Charlie has a older version ( if that makes
a difference) ??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Saturday, March 24, 2012 2:27 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Turn
try
=IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$B$9,B6)=1,COUNTIF($E$12:$E$15,F9)),1,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, March 24, 2012 5:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formu
try this simpler version where I rewrote the formulas in the c:e and then
copied that block to each of the other blocks
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Lokesh Loki
Sent: Saturday, March 24, 2012 11:25 AM
To: excel-macros@googlegroups.com
Subject: $
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Saturday, March 24, 2012 11:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Is there a way to tell excel the first row is
definitely data and not column names?
Excel keeps wanti
Are you saying that you start with the final amount, ie 309.84 then use the
required values @ 66 to find the amount of each various amount needed to get to
the difference to come up with (bottom row shown here)
66
20 10 5 1 50p 20p 10p 5p 2p 1p total
20.00 10.00 5.00
Although usually not maybe in this case deleting one row/column at a time from
the bottom up or last col to left ? Worth a try.
Sub DeleteBlankRowsAndColumnsOneAtATime()
Dim i As Long
Application.Calculation = xlManual
For i = Cells.SpecialCells(xlLastCell).Row To 1 Step -1
If Application.Cou
Show us your before/after data and/or send a file with explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: karunanithi ramaswamy
Sent: Tuesday, March 27, 2012 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REG:$$Column to table formul
Sub InitRefs()
dim fv As long
dim lv As long
With Sheets(“ChartData”)
fv= .Application.Match("Stopval", .Rows(1), 0) ‘notice the dot (.) before rows
End With
With Sheets(“Results”)
lv = .Application..Match("ReverseDate", .Rows(1), 0) ‘dot NOT needed on
ACTIVE sheet but needed here.
End Wit
May be useful to test LEN of cell (1051)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Tuesday, March 27, 2012 1:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
See if attached sheet is useful by formula
, dguillett1 wrote:
Sub InitRefs()
dim fv As long
dim lv As long
With Sheets(“ChartData”)
fv= .Application.Match("Stopval", .Rows(1), 0) ‘notice the dot (.)
before
rows
End With
With Sheets(“Results”)
lv = .Application..Match("ReverseDate", .Rows(1), 0) ‘dot NOT needed
Why not just use data>filter>autofilter
see att
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Wednesday, March 28, 2012 1:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula for Unique Values with Condition
Hi All,
more info on the AFTER look.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ram
Sent: Wednesday, March 28, 2012 12:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd:
Can you help on below. I want to convert
the data in the big table bel
on my BlackBerry® from Vodafone
Thanks & Regards.
Kiran
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Mar 2012 14:07:13 -0500
To:
ReplyTo: excel-macros@googlegroups.co
sub findd()
dim c as range
for each c in range(“a2:a22”)
if ucase(left(c,1))=”D” then msgbox c
next c
end sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Preston Moore
Sent: Wednesday, March 28, 2012 12:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel
what about
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, March 28, 2012 3:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
Hi All,
thanks a lot for everyone, special to Aamir yes this what
'Assumes this in DV list
'DC36U
'DC44U
'AC42U
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DC36U As String
Dim DC44U As String
Dim AC42U As String
'??DC36U = "Tekelec Eagle XG 870-3040-06 (DC)"
'??DC44U = "Tekelec Eagle XG 870-3068-06 (DC)"
'??AC42U = "Teke
Do you mean values >0 such as 2 for the last example?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ravi Kumar Vandavasi
Sent: Tuesday, March 27, 2012 10:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Reading custom format as it appears in a c
https://www.google.com/#hl=en&sugexp=epsugrstma&gs_nf=1&tok=yQU8bSdwbrVg0d2-9kIpdg&cp=17&gs_id=25&xhr=t&q=excel:+dbf+to+csv&pf=p&output=search&sclient=psy-ab&oq=excel:+dbf+to+csv&aq=&aqi=&aql=&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=7fb1484f2d5d4b11&biw=1066&bih=670
Don Guillett
M
http://x61.ch/ee9a3f
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Garcia
Sent: Thursday, March 29, 2012 3:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA
Hi,expert,
can you help me to read sap ta
BTW. You could use data validation to guide them to ONLY input as desired. Or,
an input box macro.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Thursday, March 29, 2012 7:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Maybe you could just change the format for all
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ravi Kumar Vandavasi
Sent: Thursday, March 29, 2012 7:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reading custom format as it appears in a c
Read the forum rules at the bottom of each msg.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: vikin...@gmail.com
Sent: Thursday, March 29, 2012 10:50 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Thanks in advance
ou used range instead of target for your select but I would write it like this
Or even simpler by
‘dim AType As Range
‘set AType = Range("S8:AL8")
If Not Intersect(Target,range(“s8:al8”) is nothing then
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim SAType As Range
Set SAType = Ran
try
http://tinyurl.com/85lubjc
‘https://www.google.com/#hl=en&sugexp=epsugrstma&gs_nf=1&tok=fmljWU-Ihu1jot1KsCdb-w&cp=46&gs_id=9&xhr=t&q=read+sap+ECC6+table+content+to+excel+using+VBA&pf=p&output=search&sclient=psy-ab&oq=read+sap+ECC6+table+content+to+excel+using+VBA&aq=&aqi=&aql=&gs_l=&pbx=1&ba
Send ME to MY email your file with my macro and this msg
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anil Pandit
Sent: Friday, March 30, 2012 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of obj
Show AFTER examples and why
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Friday, March 30, 2012 6:45 AM
To: excel-macros@googlegroups.com
Cc: LAKSHMAN PRASAD
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
sir,
Here i attach an e
Start over by telling us what you are trying to do... Code can be greatly
simplified. Pls do not use “urgent” in your request. It is rude.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Zibraan
Sent: Friday, March 30, 2012 7:00 AM
To: excel-macros@googlegroups.com
20 still sounds like a lot to me. I suggest a TOC on a menu sheet with a
doubleclick macro to goto the sheet desired.In fact, you may even want the
sheets to be named 1,2, etc.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, March 30,
Dis you NOT read what Sam said about what you just did???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ChilExcel
Sent: Friday, March 30, 2012 3:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unprotect - VBA Password
Please see
http://si
glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Preston Moore
Sent: Friday, March 30, 2012 1:58 PM
To: excel group ; dguille...@hmail.com
Subject: RE: $$Excel-Macros$$ Test to see if cell value starts with a "D"
Don,
Thank you for your help; it works
more than one value
please find the attachment . i am facing the problem for the repetation
On Fri, Mar 30, 2012 at 7:09 PM, dguillett1 wrote:
Show AFTER examples and why
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Friday, Mar
lease one time to take the value . its not
working
On Sat, Mar 31, 2012 at 4:27 PM, dguillett1 wrote:
=IF(COUNTIF($A$1:$A1,A11)>1,"",SUMPRODUCT(($A$1:$A$4=A11)*($B$1:$B$4)))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finu kodo
Copy/paste this into a module in an file saved as .xlsM
Sub deleterowsif()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Len(Application.Trim(Cells(i, 2))) < 1 _
Or Cells(i, 1) = Cells(1, 1) Then Rows(i).Delete
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dgu
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finos
Sent: Saturday, March 31, 2012 12:53 PM
To: excel-macros@googlegroups.com
Cc: dguille...@gmail.com
Subject: sumproduct.xlsx
Thanks for ur
for January use 1 in cell a1
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ASHOK PHALKE
Sent: Monday, April 02, 2012 2:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ CONDITIONAL SUM
Hi,Pl
One way to learn is to record a macro while doing manually
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kremstep
Sent: Sunday, April 01, 2012 11:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816
Say
If desired, reply directly to me with your file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Monday, April 02, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
I am sending you excel s
Assuming column 1. Filter on begins with and insert r>unfilter
‘=
Option Explicit
Sub InsertRowsSAS()
Dim lr As Long
Dim r As Range
Application.ScreenUpdating = False
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("a2").Resize(lr)
.AutoFilter Field:=1, Criteria1:="=category*"
For Each r In
Option Explicit
Sub InsertRowsSAS()
Dim lr As Long
Dim r As Range
Application.ScreenUpdating = False
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("a2").Resize(lr)
.AutoFilter Field:=1, Criteria1:="=category*"
For Each r In .SpecialCells(xlVisible)
Rows(r.Row + 1).Insert
Next r
.AutoFilter
En
Use cell instead due to text box limit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Thursday, April 05, 2012 6:51 AM
To: excel-macros
Subject: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Good Afternoon Experts
In the
How?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Thursday, April 05, 2012 8:03 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Hi please find the attached sheet
Rajan
Not much info but you can probably change the format.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, April 05, 2012 10:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ to remove time
Hi ,
12/2/2001 12:00 PM
of words in Rectangular Shape box problem
I have seen the code he used, i think its
Sub ListBox1_Change()
Sheet2.Shapes("shpMyShape").TextFrame.Characters.Text = Sheet1.Range("A24")
End Sub
On Thu, Apr 5, 2012 at 3:20 PM, dguillett1 wrote:
How?
Don Guillett
Should do it
sub clearallbuttoprow()
Sheets("Results").UsedRange.Offset(1).Clear
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Thursday, April 05, 2012 6:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ how to clear all
would offset(0,1) mean skip the first column?
On Thu, Apr 5, 2012 at 5:01 PM, Domain Admin wrote:
That works, thanks. How do you find out all the properties or
functions or whatever of usedrange etc.?
On Thu, Apr 5, 2012 at 4:47 PM, dguillett1 wrote:
Should do it
sub clearallbuttoprow
Try either of these. If you want more than one incorporate AND
Sub DeleteFilteredRowsSAS()
With Range("B5:B" & Cells(Rows.Count, 2).End(xlUp).Row)
.AutoFilter field:=1, Criteria1:="*SETOUTS*"
.Offset(1).SpecialCells(xlVisible).EntireRow.Delete
' MsgBox "hi"
.AutoFilter
End With
End S
Or automatic by simply entering the number and using a change_event macro
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Friday, April 06, 2012 8:52 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ need excel dyanmic web query
Charlie Harris
On Sat, Apr 7, 2012 at 1:02 AM, dguillett1 wrote:
Try either of these. If you want more than one incorporate AND
Sub DeleteFilteredRowsSAS()
With Range("B5:B" & Cells(Rows.Count, 2).End(xlUp).Row)
.AutoFilter field:=1, Criter
Did you delete rows using the row indicator at the left of the sheet?
Did you SAVE the file after so doing?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Saturday, April 07, 2012 4:24 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I would probably design the project differently but
Put this is c2 and copy across and down
=SUMPRODUCT((Data!$A$2:$A$270=$A2)*(Data!$B$2:$B$270=$B2)*(Data!$C$2:$C$270=C$1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, April 07,
If you mean { } this is because it is an array formula where you do NOT put
in the brackets. You save or change the formula using ctrl+shift+enter instead
of just enter.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, April 07, 20
Provide a file with examples
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Domain Admin
Sent: Saturday, April 07, 2012 3:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ runtime error on assignment trying to find
- use long
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Saturday, April 07, 2012 2:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ runtime error on assignment trying to find
the
end of a
Sub roundvalues()
Dim c As Range
For Each c In Range("a2:z22").SpecialCells(xlConstants, xlNumbers)
c.Value = Application.Round(c, 2)
‘OR vba round which may round down instead of rounding OFF
‘ c = Round(c, 2)
Next c
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.c
mple other
than the removal of application.
On Mon, Apr 9, 2012 at 7:21 AM, dguillett1 wrote:
Sub roundvalues()
Dim c As Range
For Each c In Range("a2:z22").SpecialCells(xlConstants, xlNumbers)
c.Value = Application.Round(c, 2)
‘OR vba round which may round down instead of rounding
I haven't followed all of this but it seems to me that there is no reason
for separate files. To get reports or print you can use filtering
with/without macros and use only ONE file. Good design???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
way to create a used range on each column?
On Mon, Apr 9, 2012 at 9:42 AM, dguillett1 wrote:
read this
http://support.microsoft.com/kb/194983f
simple change. Keep the special cells just in case or try without
For Each c In activesheet.usedrange
but blanks will now be 0 instead of blank
Sub
info. The
separate files so created will be saving lot of our SPACE .Currently
anyway I am doing it MANUALLY [ rathersorry state!! ] Print out of
the repo, we do at our HdOfice. and w/o a macro it takes too much of
time...[ over five hundred LEFT clicks alone!! ]
=mangal ho
On 4/9/12, dguill
this loop be replaced by some range
method?
No need. I figured out my last question and your method works fine, thanks.
On Mon, Apr 9, 2012 at 11:40 AM, dguillett1 wrote:
Send your file to ME with an explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
If you REALLY need a macro, let me know.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
Sent: Tuesday, April 10, 2012 8:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to calculate amount
Dear experts,
I need a macro for f
This is an excel forum. Pls post excel files.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Patil MG
Sent: Friday, April 13, 2012 1:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed
Hi Kumar / Ra
You may send you file to ME with a complete explanation
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Bhalara
Sent: Friday, April 13, 2012 7:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Error while inserting raw
Dear expert
Please
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mr Excellent
Sent: Friday, April 13, 2012 5:22 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Index function help needed
Hi All,
Need a simple index function with a drop given to auto publish the va
You need to provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nikhil Shah
Sent: Saturday, April 14, 2012 2:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Quarter Classification
Dear Friends,
I want to make the whole year classif
Provide your file with examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ITP Abdulgani Shaikh
Sent: Saturday, April 14, 2012 1:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If date in One then another cell to be unlock
Dear Freinds,
On your protection, why not just leave unprotected...
On your macros, see attached (Sent direct to OP)
‘---
Option Explicit
Sub AddSheetSAS()
ActiveWorkbook.Save
Dim i As Long
Dim s, k As String
s = InputBox("Please Enter INITIALs of Employee as Sheet Name to be added")
For i = 1 To Workshe
Thanks to all who have responded or will.
Someone must have know that it is my 76 th birthday today.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Saturday, April 14, 2012 3:36 AM
To: excel-macros
Subject: $$Excel-Macros$$ Most helpful Member -
nstants, 1).ClearContents
Please guide
Thanks a lot for everything, that's what I want really.
Regards
On Sat, Apr 14, 2012 at 8:34 PM, dguillett1 wrote:
On your protection, why not just leave unprotected...
On your macros, see attached (Sent direct to OP)
‘---
Option
I haven't paid much attention to this so..
If you are still having a problem with this you might consider using the
FIND method to get the last value you want
Send your file direct to me if desired with a complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmai
If your request is for a reply, I did reply.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Abdulgani Shaikh
Sent: Saturday, April 14, 2012 5:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Pl.re
101 - 200 of 1086 matches
Mail list logo
