to the OP.
Sam Mathai Chacko
On Tue, Feb 14, 2012 at 9:59 PM, dguillett1 dguille...@gmail.com wrote:
I, for one, do not understand the question.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Philehof phile...@gmail.com
*Sent:* Monday, February 13, 2012 2:12 PM
*To:* excel-macros
),
Columns(b:c).Replace,
Regards,
Sam Mathai Chacko
On Fri, Feb 10, 2012 at 12:20 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Thank you for the quick reply.
regards
Sanjib
On Fri, Feb 10, 2012 at 12:23 AM, dguillett1 dguille...@gmail.com wrote:
Or, even simpler without
This does exactly what you need
http://www.ozgrid.com/forum/showthread.php?t=144212
Regards,
Sam Mathai Chacko
On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote:
Divide from lac =165221/10 (1.65221)**
*From:* Ashish Bhalara ashishbhalar...@gmail.com
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 2:18 PM, Veeru TOC veerub...@gmail.com wrote:
Dear Group
i can use below vba code get txt from All wbk to
1 sheet , Excel wbk name into A Coulumn how its possible
VBA Code:-
Sub GetTextFromAllWbs()
Dim
to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
The easiest way is to uncheck the show zeroes in the Excel option.
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 6:31 PM, Shaik Waheed waheedb...@gmail.com wrote:
Thanks noorain
thats wonderful,
On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear
Noorain, if you are using AB as your search criteria to split the cells,
why do you need such a long formula
Use
Name
=TRIM(SUBSTITUTE(SUBSTITUTE(A2,MID(A2,FIND(AB,A2),9),),CHAR(160),))
Reg.No =SUBSTITUTE(MID(A2,FIND(AB,A2),9),CHAR(160),)
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 8
), )), ,+1,255)
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 10:10 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Noorain, if you are using AB as your search criteria to split the cells,
why do you need such a long formula
Use
Name
=TRIM(SUBSTITUTE(SUBSTITUTE(A2,MID(A2,FIND(AB,A2),9),),CHAR
)), _
TrailingMinusNumbers:=True
With Range(B1:C Cells(Rows.Count, 1).End(xlUp).Row)
For Each rng In .Cells
rng.Value = Evaluate(=TRIM(SUBSTITUTE( rng.Address(0, 0)
,CHAR(160), )))
Next rng
End With
End Sub
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 10:25 PM
*.htm
www.contextures.com/xlFunctions05.html
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 10:26 AM, Manasa Yes yesmaa...@gmail.com wrote:
Dear Team,
Good Morning...
I would like to thank one and all for excellent tips, advise timely help
on excell really proud to be part
, Sam Mathai Chacko samde...@gmail.comwrote:
OKAY
On Wed, Feb 8, 2012 at 12:41 AM, dguillett1 dguille...@gmail.com wrote:
Sam, pls go back and test your MATCH
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, February 07
personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai
select all the cells, right click, format cell, protection tab, uncheck the
locked status
Now select only those cells that need to be protected, right click, format
cell, protection tab, now check the locked status
Finally, protect the sheet. now those cells cannot be editted.
Sam Mathai Chacko
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
*Sent:* Monday, February 06, 2012 9:42 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
** **
A more appropriate event for this case would be the Exit event. You can
need to add in error condition, otherwise it will
error out when there is no 'cell' in the text. Check Noorain's solution
where he suggested using IFERROR along with the SEARCH function.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 11:15 AM, Excel_Lover idforex...@gmail.com wrote:
=IF(FIND
is
concerned. It is just performing an action, but there is no output. Unless
you specifically need to select the next cell in that column, you can take
out that code, which is redundant.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 7:34 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
Grm.xls
You don't format the value using TEXT function in this case. Use format
cells to format. Check the attachment.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 8:49 PM, hilary lomotey resp...@gmail.com wrote:
Hello Experts,
i have a data, i want the data to read decrease when the % change
I have added two named ranges for activities and the states.
The formula for percentage will then be
=COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),Yes)/COUNTA(Activities)
and for the status will be
=IF(C2=1,Complete,Incomplete)
OR
=IF(C21,Incomplete,Complete)
Regards
Sam Mathai Chacko
, there are only 14 activities in the sample
provided.
3. Least intervention from an end-user perspective should be considered as
one of the criteria for a solution to be considered optimal.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 11:09 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote
OKAY
On Wed, Feb 8, 2012 at 12:41 AM, dguillett1 dguille...@gmail.com wrote:
Sam, pls go back and test your MATCH
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, February 07, 2012 11:28 AM
*To:* excel-macros
Just checked it Don. Couldn't figure out what you were referring to. Could
you please let me know.
Sam
On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko samde...@gmail.comwrote:
OKAY
On Wed, Feb 8, 2012 at 12:41 AM, dguillett1 dguille...@gmail.com wrote:
Sam, pls go back and test your
To keep it shorter, and more efficient, one could write
Sub ClearSubTotal()
ActiveSheet.UsedRange.RemoveSubtotal
End Sub
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 2:16 PM, Maries talk2mar...@gmail.com wrote:
Hi,
**
*Try this code:*
**
Sub Macro1()
Cells.Select
as Asa mentioned (in the Exit event that is).
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 2:27 PM, Asa Rossoff a...@lovetour.info wrote:
Hi charlie,
Got it.
Ok, the error is just indicating that the vlookup failed to find the
Part#. It failed for at least two reasons: (1
Microsoft comes out with an object model that checks the existence of
SUBTOTAL in the sheet/range, we have to use this.
So, just to show how I'd do it out of laziness
Sub ClearSubTotal()
On Error Resume Next
ActiveSheet.UsedRange.RemoveSubtotal
End Sub
Regards,
Sam Mathai Chacko
On Mon
from my side.
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 4:15 PM, Idhrees Mohamed idhrees...@gmail.comwrote:
Dear Friends,
I am using excel 2007 and my files are not opening in the first attempt if
i minimize the window and maximize or right click inside open or new then
once
The text can be formatted by having the space *within* the format
=CHOOSE(A1,C2,C3,C4,C5)TEXT(C10/I1, 0,0.00)
or using Don's suggestion
=INDEX(C2:C5,MATCH(D12,D2:D5))TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)),
0,0.00)
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 10:31 PM, resp
an
obsession for user forms. There are lots of ways you can do this without a
user form.
Anyway, I leave that to your discretion.
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 7:07 PM, dguillett1 dguille...@gmail.com wrote:
Your life would be simpler if you designed withOUT all
matched the value as
C3 with wildcards around it in the column header of the rate sheet data
table.
Here's how the formula would look like
=VLOOKUP($G$2,RATESHEET!$B$6:$C$9,MATCH(*C3*,RATESHEET!$B$5:$F$5,0),0)
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 10:18 PM, NOORAIN ANSARI
otherwise.
I hope you will understand and respect the sentiments of the community.
Regards,
Sam Mathai Chacko
On Sun, Feb 5, 2012 at 4:04 PM, Hemant hemantda...@yahoo.com wrote:
Just thought you might want to see this
http://tartalotxantrea.com/home.work.php?rogoogleid=85i1
--
FORUM RULES (986
This should work
=INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18OFFSET($D$5:$D$18,1,0),ROW(INDIRECT(1:ROWS($D$5:$D$18))),),COUNTA($I$4:I4)))
Regards,
Sam Mathai Chacko
On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi,
please help ASAP.
please find attached sheet
I second Don. please keep in mind that the volunteers here 'lend' their
time to the forum to help. So it would be best to give that extra bit of
information in a clear and concise manner, so that it is easy for the
volunteers.
Sam
On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko samde
Here's a formula based solution. No pivots
Regards,
Sam Mathai Chacko
On Thu, Feb 2, 2012 at 5:23 PM, Lakshman Prasad lakshman...@yahoo.comwrote:
Dear anjul
Plz See the attached file with your solution.
*From:* Anjul Porwal porwalan...@gmail.com
*To:* excel-macros@googlegroups.com
Didn't see you had posted one Don. I thought the solution intended was
without using the third column.
Sam
On Thu, Feb 2, 2012 at 9:05 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's a formula based solution. No pivots
Regards,
Sam Mathai Chacko
On Thu, Feb 2, 2012 at 5:23 PM
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
created that will take
the pivot, the fields and what to change to as arguments.
Regards,
Sam Mathai Chacko
On Wed, Feb 1, 2012 at 3:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Lional,
Can you share any sample workbook with excel macro group.
On Wed, Feb 1, 2012 at 3:27 PM
A mammoth effort Noorain. Congratulations.
Congrats to Rajan also. Great support to the forum, you both.
Sam Mathai Chacko
On Wed, Feb 1, 2012 at 10:27 PM, krishnanm2...@gmail.com wrote:
**
Congrats Noorian !! Keep the flag flying !!
Regards,
Krishnan
Sent on my BlackBerry® from
Regards,
Sam Mathai Chacko
On Wed, Feb 1, 2012 at 10:27 PM, Kiran Kancherla srkira...@gmail.comwrote:
Hi All,
If any of have Macro ''click'' or ''navigate'' internet explorer...
My requirement is to click 3 hyper links and copy the data to Excel
I have tried googling
,
=MAX(--MID(A2,ROW(INDIRECT(1:LEN(A2))),1)) as CSE, similar to Rajan's,
will also work.
Regards,
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 12:09 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Pravesh,
Try it..UDF
*For Minimum Value..*.
Function Minval(x As String
).Copy
Cells(Rows.Count, 1).End(xlUp)(2)
Next lngCols
rngSource.Offset(, 2).Delete xlUp
End Sub
Regards,
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 10:10 PM, Mukesh Kumar mukeshka...@gmail.comwrote:
Dear Kris,
Following error is coming after macro execution
Run time error '9
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
(Sheets.Count))
.Name = col.Item(lngRow)
Worksheets(strSheetName).Range(A2:K
Worksheets(strSheetName).Cells(Rows.Count, 1).End(xlUp).Row).Copy .Cells(1)
End With
Next lngRow
Worksheets(strSheetName).AutoFilterMode = 0
End Sub
Regards,
Sam Mathai Chacko
On Tue
If
strArray(lngCount, 1) = strArray(lngCount, 1) rngSource.Offset(,
1).Value rngSource.Offset(, 2).Text ,
Next rngSource
Range(E4).Resize(lngCount + 1, 2).Value = strArray
End Sub
Regards,
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote
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 duraichan
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
the conversion wouldn't really
make a difference if the values were either some numeric value, or blank.
Also, there's no point converting it to a long value if the value is a text
entry. In that case it would anyway throw an error if you use Clng.
Regards,
Sam Mathai Chacko
On Mon, Jan 30, 2012 at 7:00 PM
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
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
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 vtorral
@googlegroups.com
--
Sam Mathai Chacko
--
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
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
, if you use relative reference, the macro will say you selected a
cell that is offset by 3 rows and 3 columns.
Hope that's clear.
Regards,
Sam Mathai Chacko
On Sat, Jan 28, 2012 at 5:25 PM, Venkat CV venkat1@gmail.com wrote:
Hi Vijay,
Look Below about relative refrence..
*What
Here's a simple example where you can SETFOCUS on a user form control
Regards,
Sam Mathai Chacko
On Sat, Jan 28, 2012 at 5:46 PM, Shankar Bheema shankar.n...@gmail.comwrote:
Hai Asa.
May I have one example pls. Because I tried but I did not get.
regards
shankar sb
On Sat, Jan 28, 2012
(G6,0)+H6-ROUNDDOWN(E6,0)-F6
Regards,
Sam Mathai Chacko
On Sat, Jan 28, 2012 at 6:16 PM, Yahya Muhammad yahya...@gmail.com wrote:
Dear Yasir
Please find the solution in the attached file.
On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee
yasir.shah...@gmail.comwrote:
Respected Masters
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
of
boolean values will either give 0 or 1. 1 only when both the equations give
a TRUE. And you can only get 2 or more if there are duplicates. Otherwise
it will always be 1.
Hope that explains ($A$2:$A2=A2)*($B$2:$B2=B2)
Regards,
Sam Mathai Chacko
On Sat, Jan 28, 2012 at 7:21 PM, dguillett1 dguille
wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete
Next
objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls
objWorkbook.Close
Next
objExcel.Application.Quit
WScript.Echo Finished.
WScript.Quit
Regards,
Sam Mathai Chacko
On Fri, Jan 27, 2012 at 7:43 AM, yogananda muthaiah
Use in F3 and drag down and across
=SUMPRODUCT((Data!$A$2:$A$37=$E3)*(Data!$B$2:$B$37=Total)*OFFSET(Data!$A$2:$A$37,0,MATCH(Dashboard!F$2,Data!$B$1:$L$1,0)))
Regards,
Sam Mathai Chacko
On Thu, Jan 26, 2012 at 8:48 PM, John A. Smith johnasmit...@gmail.comwrote:
Thank you for your valuable help
(H40) = .txtda
End With
With Sheet2
Sheet1.Range(F4).Value = .txtpay
Sheet1.Range(G22).Value = .txtpay
Sheet1.Range(G27).Value = .txtpay
End With
End With
End Sub
End Sub
Regards,
Sam Mathai Chacko
On Wed, Jan 25, 2012 at 11:04 AM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear experts
I
Put in C3 and drag down
=SUMPRODUCT(IF(A3B3=A2B2,C2,IF(B3=B2,C2+1,1)))
Regards,
Sam Mathai Chacko
On Tue, Jan 24, 2012 at 5:03 PM, yasir_shahjee yasir.shah...@gmail.comwrote:
Still waiting
On Tue, Jan 24, 2012 at 4:06 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi, can u tell how u r
=INDEX(OFFSET('dia 28 en8 bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8
bgt'!$A$1:$J$1,0)-1),MATCH(9E+300,OFFSET('dia 28 en8
bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8 bgt'!$A$1:$J$1,0)-1),1))
Regards,
Sam Mathai Chacko
On Tue, Jan 24, 2012 at 4:56 PM, hemal shah hemali...@gmail.com
End If
Next
For Each rng In wks.Cells.SpecialCells(-4123, 1)
If IsNumeric(rng.Text) Then
rng.NumberFormat = 0.00
End If
Next
Next
End Sub
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:31 PM, NOORAIN ANSARI
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
PFA
On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Prince,
Please select filtered data, press alt+; then copy
Mathai Chacko
On Mon, Jan 23, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote:
Without looking too close, try /30
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Monday, January 23, 2012 4:06 AM
To: excel-macros@googlegroups.com ; Sam Mathai Chacko
Next
End Sub
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 7:04 PM, Zafar Iqbal ziqba...@gmail.com wrote:
Dear Sir,
I have already tried it. Yet, as per your instructions, I did the same
again. There are two problems.
First is that decimals in print view are surely two only but in actual
Zafar, your numbers are all coming correct. For the date format, all you
need to do is format the series to d-mmm
Why do you need a macro for that? Keep the custom format, and it will
always remain.
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:15 PM, Zafar Iqbal ziqba...@gmail.com wrote:
We
Which means you do not have Acrobat 9 installed. The code will not work
without that.
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:27 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Noorain,
Unable to find anything as reference in tools option in Acrobat 9.
Please suggest.
Regards
From what Don intended, I believe it is
Dim i as long, lr as long, lc as long, mf as range
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:47 PM, Zafar Iqbal ziqba...@gmail.com wrote:
Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I
think that first three
And for printing
Private Sub CommandButton2_Click()
Worksheets(Page1).PrintOut
Worksheets(Page2).PrintOut
End Sub
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Bheema,
use below code format for your query
--
Sam Mathai Chacko
--
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) Don't post
It's about adding single quotes.
Check http://www.excelfox.com/forum/f2/excel-application-onkey-parameter-285/
Regards,
Sam Mathai Chacko
On Sun, Jan 22, 2012 at 2:16 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi
Save your file in xlsm or xls format
-Original Message-
From
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
, 'MainProcedure b'
End Sub
Sub MainProcedure(strLeter As String)
MsgBox Pressed Ucase(strLeter)
End Sub
Sam Mathai Chacko
On Sun, Jan 22, 2012 at 10:50 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Nathan,
Problem #1 is that your MainProcedure has strLeter as the parameter name,
but you
Private Sub SpinButton1_Change()
TextBox2.Text = SpinButton1.Value
End Sub
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 12:01 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
How to use spin button with text box in a user form.
Attached is the sheet in which I need
personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),)
Regards,
Sam Mathai Chacko
On Sat, Jan 21, 2012 at 5:25 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
In the attached excel sheet the maturity value is working fine for years
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
You don't need such an elaborate code to create your control. Here's a
cleaner version...
Sub indrajit()
With Application
On Error Resume Next
.CommandBars(Sam Mathai Chacko).Delete
With .CommandBars.Add(Sam Mathai Chacko, 4)
.Visible = .Enabled
Here's how you do it.
Regards,
Sam Mathai Chacko
On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde
shrinivas...@gmail.comwrote:
Dear Rohan
I was trying to do it for me but I could not I am attaching the work sheet
Please do it and please let me know what is the problem Why I could not do
-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
object can be embedded
on a sheet, but I have seen it work on a user form.
Regards,
Sam Mathai Chacko
On Mon, Jan 16, 2012 at 8:34 PM, dguillett1 dguille...@gmail.com wrote:
That is what will happen with xl2003.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* santosh subudhi
email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
Try in vb script? I have no idea what you are trying to convey.
On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah
yogananda.mutha...@gmail.com wrote:
Thank you sam
Can you please try in vb script on same
On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote:
Sub DelRows
\Desktop\DelAllRowsExcelA1.xls
objWorkbook.Close
objExcel.Application.Quit
WScript.Echo Finished.
WScript.Quit
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah
yogananda.mutha...@gmail.com wrote:
Hi sam
As you provided in excel vba .. I would need
- 1, 1)
.Value = Worksheets(Deleted report).Range(A2:A
lngRows).Value
.AutoFilter 1,
.EntireRow.Delete
.Parent.AutoFilterMode = 0
End With
End With
End Sub
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 6:39 AM, Lokesh Loki
(Rows.Count,
E).End(xlUp).Row, 2)).Clear
With .Range(E2).Resize(lngRows - 1, 1)
.Value = Worksheets(Deleted report).Range(A2:A
lngRows).Value
.SpecialCells(2, 2).Delete xlUp
End With
End With
End Sub
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 9
Try this, Cells(Ultimalinha, 15).Value = BemImovel ^ 1
Regards,
Sam Mathai Chacko
On Fri, Jan 13, 2012 at 10:40 PM, Marcio Bandeira
marciobandeir...@gmail.com wrote:
Hi, thanks for any help.
I have a form to input data in a worksheet. One of this data is a
number, but when I put
(Sheet1!$Q4,Sheet1!$C$5:$C$27,0),0,1))*(OFFSET(Sheet1!$D$4:$O$4,MATCH(Sheet1!$Q4,Sheet1!$C$5:$C$27,0),0,1)),0))
Regards,
Sam Mathai Chacko
On Fri, Jan 13, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Try this :
=INDEX(C4:N4,MATCH(Q3,INDIRECT(C MATCH(P3,$B$4:$B$28,0)+4
Sub DelRows()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
With wks
.Range(A2,
.UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete
End With
Next wks
End Sub
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 8:07 AM
You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it
will work in Excel 2003 or 2007+
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Gurus,
Please find the attached querY
Thanks in adv.
--
FORUM RULES (986
for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
If you are using Excel 2003 or lesser, use
=SUMPRODUCT('OWN MACHINERY'!$F$3:$F$467,--('OWN
MACHINERY'!$B$3:$B$467=Sheet1!$B3),--('OWN
MACHINERY'!$G$3:$G$467=Sheet1!C$2))
Regards,
Sam Mathai Chacko
On Mon, Jan 9, 2012 at 11:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
You can use sumifs
With
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jan 8, 2012 at 9:02 AM, RAJA SHEKAR jrsjrs...@gmail.com wrote:
Hi Team,
Any update per my below mail. Need your help..
Regards,
Shekar
-- Forwarded message --
From: RAJA SHEKAR jrsjrs...@gmail.com
Date: Wed, Jan 4, 2012
-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
in Excel 2003,
however, the pagelayout view wasn't. So if you use Excel 2003, you will not
find this option.
Hope that helps.
Regards,
Sam Mathai Chacko
On Sat, Jan 7, 2012 at 2:38 PM, JAVED KHAN john.he.ma...@gmail.com wrote:
it has some kind of excel sheet setting..so go into option
On Sat
Rajan,
Excellent work buddy. Keep up the great work. Your contribution here is
once again proven outstanding.
Regards,
Sam Mathai Chacko
On Wed, Jan 4, 2012 at 12:22 AM, Dilip Pandey dilipan...@gmail.com wrote:
Congratulations Rajan..!!
Keep up the good work. Have a wonderful year ahead
objControl.Name is an ActiveX control.
ElseIf objControl.Type = msoFormControl Then
MsgBox objControl.Name is a Form control.
Else
MsgBox objControl.Name is neither an activeX control or a
Form control.
End If
Next
End Sub
Regards,
Sam Mathai Chacko
=SUBSTITUTE(D9,*,)
or
=--SUBSTITUTE(D9,*,) if you want to ensure it is equivalent to the date
value
Regards
Sam Mathai Chacko
On Fri, Dec 9, 2011 at 5:16 PM, tan dennis tanbh...@yahoo.com wrote:
Hi All
I have a spreadsheet with 4000 row of records, I need to remove the
character
(, lngColOffset)
.Formula = =' rng.Value '
.Copy
.PasteSpecial -4163
End With
Next rng
With Application
.CutCopyMode = 0
.ScreenUpdating = 1
End With
End Sub
Sam Mathai Chacko
On Thu, Dec 8, 2011 at 6:34 PM, dguillett1
://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Sun, Dec 4, 2011 at 7:45 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Dear All,
Hope you all are doing good.
Requesting a favor. Does anyone of you have some study material on
Solver, Goal Seek and Subtotals? I already have
201 - 300 of 570 matches
Mail list logo
