For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End If
End
s you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
>
By the way, the code to Zoom the window is
ActiveWindow.Zoom= 120
which means 120%
Regards,
Sam
On Thu, Nov 10, 2011 at 10:54 PM, Sam Mathai Chacko wrote:
> You CAN increase the font size if it is an Activex Control. Form Controls
> like mentioned earlier, don't allow font size
questions regarding breaking or bypassing any
>> security measure.
>> >
>> >
>> > >
>> >
>> >
>> > >
>> >
>> >
>> > > >
>> >
>> >
>> > > >
>> >
>> >
>> > > >
>> >
>> >
>>
Two options try
If Not IsEmpty(Range("A1")) Then
Range("B5").Value = 8
Else
Exit Sub
End If
*OR*
If Len(Trim(Range("A1"))) Then
Range("B5").Value = 8
Else
Exit Sub
End If
Regards
Sam Mathai
Cells(lngLoop, 2).Value = Worksheets("Sheet2").Cells(lngLoop,
2).Value
End If
Next lngLoop
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 10, 2011 at 7:42 PM, vijayajith VA wrote:
> hi
>
> I have tried using pastespecial its NOT WORKING
> its copying only two cells
;t ever post 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
There are clear instructions not to post queries related to password
hacks. Please ensure forum decorum.
Sam
On Nov 10, 12:15 pm, jocky Beta wrote:
> Hi Team,
>
> I had made one PPT file few days ago and now i had forgot the password
> of that PPT. Hence request you anybody help me on this
Please upload your sample workbook. Without that, it will be difficult
to understand exactly what you require.
Sam
On Nov 10, 11:11 am, "smitha.kumari"
wrote:
> If name in a cell is Simon in a work sheet 2 then the designation already
> allotted for Simon in worksheet 1 should appear there in wo
if you just want to do a sum of all the same cells across multiple sheets,
you could use something like this
=SUM(Sheet2:Sheet5!A2)
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:59 PM, dguillett1 wrote:
> Do you want to copy a range from each sheet to a master or do a
> summar
Hehe, Don, I'm sure he meant 'new'
Clinton,
Is there any sheet movements in your macro? Maybe worth posting your VBA
code.
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 wrote:
> You need to post your file or a least your code
> How does a jew w
is forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------
In Noorain's solution, the name of the defined name formula would be *
SheetNames*
Also, you can find here a UDF through VBA as well
http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/
Regards,
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 11:40 PM, NOORAIN ANSARI
s you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> -
n't ever post 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@google
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
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread ti
Like I mentioned yesterday, you can use hyperlinks with custom screen tips
in small shapes placed on top of your actual image, and make those shapes
transparent. If you need an example of how this can be done, revert.
Regards,
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 10:34 AM, wrote:
>
Well, we try to be fast enough! Anyway, on second thought, you could make
it even simpler with this *
*=DATE($P$1,MONTH("1-"&$A8)+1,
0)
Regards
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 2:33 AM, Dave wrote:
> Thanks brilliant!!
> I just dont know how you guys ca fig
Well, we try to fast enough! Anyway, on second thought, you could make it
even simpler with this *
*=DATE($P$1,MONTH("1-"&$A8)+1,0)
Regards
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 2:33 AM, Dave wrote:
> Thanks brilliant!!
> I just dont know how you guys ca fig
quot;&$P$1&"")+1,0)
Regards,
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 1:43 AM, dguillett1 wrote:
> Assuming you DO have the analysis toolpak installed or can otherwise use
> the EOMONTH function, then this will do copied into each moth end block
> where a8, a29, etc.
w number will dynamically change, but as we
go across column, G will remain static, thereby evaluating =$G9<30, =
$G10<30, =$G11<30 so on and so forth
Similarly, for sheet 2157, A8:P105, and used formula =$Q8<30. Same
logic as above.
Regards,
Sam Mathai Chacko
On Nov 7, 7:22 pm, "dgu
year, and so on and so forth, depending on how many you need.
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 11:51 PM, Dave wrote:
> Hi experts,
>
> I have a spreadsheet in which employees record their daily work
> inventory. I have 12 sections for each month.
> I calculate
You can use hyperlinks with custom screen tips in small shapes placed on
top of your actual image, and make those shapes transparent.
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 9:02 AM, wrote:
> All is there a resolution for this??
>
> Krishnan
> Sent on my BlackBerryŽ f
t get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-prom
With a little modification, you can chance up on this site
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 3:41 PM, jmothilal wrote:
> Dear Friend
>
> when i try 2 this #\,##\,##\,###.00 format
With a little search, you can chance up on this site
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 3:41 PM, jmothilal wrote:
> Dear Friend
>
> when i try 2 this #\,##\,##\,###.00 format
ers are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Sam Mathai Chacko
--
FORUM RULES (925+ members already BANNED
Another easy way to build this would be to use Pivot Tables
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 10:43 PM, xlstime wrote:
> Please find the attachment..
>
>
>
> On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar > wrote:
>
>> Dear,EXCELERS
>>
>
Use in D20
=SUMPRODUCT(('GIFT DATA'!$B$9:$B$193=Summary!$C20)*('GIFT
DATA'!$E$9:$E$193=Summary!D$15)*('GIFT DATA'!$F$9:$F$193))
and drag down and across
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar
wrote:
> Dear,EXCELERS
>
quot;G41:G68").Value, 0)) Then
wks.Tab.ColorIndex = 5
Else
wks.Tab.ColorIndex = 6
End If
Next wks
End Sub
Regards,
Sam Mathai Chacko (GL)
On Nov 4, 6:19 pm, Paul Schreiner wrote:
> "Assuming" you want to search all sheets for the value th
So to ensure only the correct number of days are added, use
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW(INDIRECT("1:"&DAY(DATE(YEAR(B1),MONTH(B1)+1,0))=6))
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 12:48 AM, Paul Schreiner wrote:
> He's using the fir
Sub NameInMe()
Dim nm As Name
For Each nm In ThisWorkbook.Names
If nm.Parent.Name = ThisWorkbook.Name Then
MsgBox nm.Name & " is workbook level"
Else
MsgBox nm.Name & " is sheet level"
End If
Next
End Sub
Just a small modification to your original formula
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),MONTH(A1),1)&":"&DATE(YEAR(A1),MONTH(A1)+1,0))))=6))
Regards
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 11:43 PM, dguillett1 wrote:
> try
> =4+(DAY(B$1+34)
>
ks great on sheet1 but doesnt work on others...
>
> On Nov 3, 5:21 pm, Sam Mathai Chacko wrote:
> > Did you try this?
> >
> > Sub PasteStat()
> >
> > Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f"
-
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help
t; On Nov 3, 4:36 pm, "dguillett1" wrote:
> > Sub cc()
> >Sheets("start").Range("h6:l6").Copy cells(activecell.row,”f”)
> > end sub
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> > Fro
=N(E8)+N(K8)
Score=IF(ISNUMBER(Sheet1!$E$2),(IF(Sheet1!$E$2<=2,3,IF(Sheet1!$E$2<=3,1,IF(Sheet1!$E$2<=4,0,IF(Sheet1!$E$2>4,-3,0),0)
Score1=IF(ISNUMBER(Sheet1!$J$2),(IF(Sheet1!$J$2<=0.5,-2,IF(Sheet1!$J$2<=0.75,0,IF(Sheet1!$J$2<=1,1,IF(Sheet1!$J$2>1,2,0),0)
Regard
Sub PasteStat()
Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
Selection.Row)
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote:
>
> Sub PasteStat()
>
>Sheets("start")
Here's a simulated refresh to give you the idea of how it can be done. Now,
my trigger is the click of a button. But in your case, it could be the
query refresh.
Regards
Sam
On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko wrote:
> For that you'll have to first tell how yo
--------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Sam Mathai Chacko
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need He
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),"00\:00")+(B23/(60*24)) in
mm/dd/ hh:mm format
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 5:52 AM, Haseeb Avarakkan wrote:
> Hello
>
> ** **
>
> I really appreciate your patience with this issue.
>
> Thank you!
>
> Kent
>
> ** **
>
> ** **
> ------
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam
Mahreen, I am getting 1 and -2 as answers, and after looking at the
formula, I don't think there's anything wrong with the result. I am also
able to select NA, or the Scores. Are you facing some other problem? If
yes, please explain.
Regards,
Sam Mathai Chacko
On Wed, Nov 2, 2011
-
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Sent from my mobile device
Sam Mathai Chacko
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Form
its a text
> thatsy but is there any possibility i can show the result ignoring the NA
>
>
> On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko wrote:
>
>> Here's how you do it Mahreen.
>>
>> Create a named range using the formula you already have. And in
>&g
Ah! You have already posted while I was typing. Good that we all are on the
same page :D. Happy posting
Sam
On Tue, Nov 1, 2011 at 11:02 PM, Sam Mathai Chacko wrote:
> Dave,
>
> How I couldn't agree more with Paul.
>
> Let me put it this way. October is NOT more than a mo
(Date), Month(Date), 1)
Regards,
Sam Mathai Chacko
On Tue, Nov 1, 2011 at 10:34 PM, Paul Schreiner wrote:
> It's ok then?
> The original post said:
>
> 1, Every month I want to copy all files that are 1 month old (these
> are all .PDF files) from folder A to folder B.
>
>
le for any loss.
>
>
> --------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Sam Mathai Chacko
--
FORUM RULES (925+ members already BANNED for violation)
elp, Formula Problem, Code Problem, and Need Advice will
> not get
> > quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> m
;
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
> *Sent:* 01 November 2011 12:41
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Convert amount to Million
>
> ** **
>
> Aamir,
>
>
Sub CopyFromSheetToAnotherSheet()
Selection.Copy Sheets(2).Range(Selection.Cells(1).Address)
End Sub
Regards,
Sam Mathai Chacko (GL)
On Tue, Nov 1, 2011 at 10:42 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Members,
>
> I have two sheets in
Here's one that takes care of both the unique list and the concatenation
Regards,
Sam Mathai Chacko
On Tue, Nov 1, 2011 at 9:11 AM, Sundarvelan N wrote:
> Asish Thankyou so much!
>
> Very Very Thanks
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
&
ce
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are pr
=TEXT(TEXT(A2,"\/00\/00"),"dd-mmm-yyyy")
Regards,
Sam Mathai Chacko
On Mon, Oct 31, 2011 at 12:52 PM, Aivi wrote:
> hi
>
> i have a column in excel with the following date format--
>
> Invoice Date 20111003 20111003 20111003 20111003 201
excel, and transposing it at
the same time? Not sure if that can be done!
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 31, 2011 at 7:33 PM, dost wrote:
> I want to set one worksheet cell range reference to another worksheet
> using aspose.cells.For example i have two worksheet(wrk1 and wr2
gt; --
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
> *Sent:* October 28, 2011 5:52 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Number Formats in F
Cells(Rows.Count, 1).End(xlUp).Row
For lngRow = *Application.Max(4,* lngLastRow*)* To *3* Step -1
With Cells(lngRow, 1)
If .Value = 0 Then .Offset(-2).EntireRow.Font.Bold = True
End With
Next lngRow
End Sub
Regards,
Sam Mathai Chacko (GL)
On Sat, Oct 29, 2011 at
Here's a more accurate formula, though longer
=A3*((MONTH(C3)+(12*(YEAR(C3)-YEAR(B3)))-MONTH(B3))+((DATE(YEAR(B3),MONTH(B3)+1,1)-B3)/DAY(DATE(YEAR(B3),MONTH(B3)+1,0)))-((DATE(YEAR(C3),MONTH(C3)+1,0)-C3)/DAY(DATE(YEAR(C3),MONTH(C3)+1,0
Regards,
Sam Mathai Chacko (GL)
On Sat, Oct 29, 20
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
--
FORUM RULES (925+ members already BANNED
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
--
FORUM
There's a custom version here... I'm sure you can make the minor tweaks
from here on
http://www.excelfox.com/forum/showthread.php?142
Regards,
Sam Mathai Chacko (GL)
On Sat, Oct 29, 2011 at 3:38 AM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:
> Dear Sa
m
>>
>>
>> On Sat, Oct 29, 2011 at 3:20 AM, Aamir Shahzad
>> wrote:
>>
>>> Can I create another "Module 2" in the same add in & write code there?
>>>
>>> Aamir Shahzad
>>>
>>> On Sat, Oct 29, 2011 a
> Thanks SAM,
>
> I missed that part. please find the updated format.
> Regards
> Chethan Kumar BN
> On Sat, Oct 29, 2011 at 3:15 AM, Sam Mathai Chacko wrote:
>
>> The OP had requested for the decimal separator to be a comma (,)
>>
>> Sam
>>
>>
>>
her "Module 2" in the same add in & write code there?
>
> Aamir Shahzad
>
> On Sat, Oct 29, 2011 at 2:43 AM, Sam Mathai Chacko wrote:
>
>> Not sure what procedure you require, but if you knew the range, this is
>> how you'd call this
>>
&g
to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---
thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibite
ange)
Dim rngCell As Range
For Each rngCell In Target
If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then
rngCell.Value = Replace(UCase(Trim(rngCell.Text)), "M", "") * 10
^ 6
End If
Next
End Sub
Sam Mathai Chacko (GL)
On Sa
Yes you can
Sam
On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad wrote:
> Can I enter this code with another add in?
>
>
> On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote:
>
>> Something like this might do the trick
>>
>> Private Sub Worksheet_Change(ByV
in Red font.
>
> Aamir Shahzad
>
> On Sat, Oct 29, 2011 at 2:19 AM, Sam Mathai Chacko wrote:
>
>> Just change =MultiResultLookedUp(B3,2,$F$3:$I$42,*1*) to
>> =MultiResultLookedUp(B3,2,$F$3:$I$42,*3*) to look at second column and
>> pick value from 3rd column
>>
>
", "") * 10
^ 6
End If
Next
End Sub
Regards,
Sam Mathai Chacko (GL)
On Sat, Oct 29, 2011 at 2:52 AM, Aamir Shahzad wrote:
> Dear Experts,
>
> Is it possible in excel that if I write in cell "1M" & press tab or enter
> it automatically converted this
now to
picked up the right side values from columns 2nd or 3rd. Because this code
is not giving the values from right side now.
>
> On Sat, Oct 29, 2011 at 1:24 AM, Sam Mathai Chacko
wrote:
>>
>> Is this just for whims? Or are you just intrigued?
>>
>> =MultiResultLookedUp
instructions; it would be
> greatly appreciated.
>
>
>
>
> On Oct 28, 2:10 pm, Sam Mathai Chacko wrote:
> > Instead of putting a custom format, why don't you change the comma
> separator
> > and decimal separator to space and comma respectively?
> >
> > R
MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp)
- 1)
End Function
Sam Mathai Chacko (GL)
On Sat, Oct 29, 2011 at 1:44 AM, Aamir Shahzad wrote:
> Now resolved thanks. Any possibility for pickup the left side values?
>
> Aamir Shahzad
>
>
> On Fri,
MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop,
lngDefaultCol) & "/"
End If
End If
Next lngLoop
MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp)
- 1)
End Function
For example, =MultiResultLookedUp(B3,$G$3:$I$42,3) will pick
tion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> -------------
"savijay" Then
> Sheets(sht).Protect Password:="Sample"
> End If
> Next
> End Sub
> --------
>
> On Fri, Oct 28, 2011 at 9:51 PM, Sam Mathai Chacko wrote:
>
>> It means the sheet is protecte
o this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post 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
nfidential 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
/www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-mac
Here's how you create the named range
=OFFSET(Sheet1!$B$1,1,,MAX((LEN(TRIM(Sheet1!$B$1:$B$200))>0)*(ROW(Sheet1!$B$1:$B$200)))-1,1)
Check the attachment
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 28, 2011 at 12:46 AM, dguillett1 wrote:
>
> Attach your file with a copy of this
ResultLookedUp & "/", "/" & varArray(lngLoop, 2)
& "/") = 0 Then
MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop, 2) &
"/"
End If
End If
Next lngLoop
MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp) -
1)
End
And here's the VBA version
Function EVALUATER(rngCell As Range)
EVALUATER = Application.EVALUATE("=" & rngCell.Value)
End Function
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 27, 2011 at 9:49 PM, Sam Mathai Chacko wrote:
> Bravo Noorain
>
> Rgds,
> Sam
>
links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks a
IE.Visible = True
Do While objIE.busy: Loop
objIE.Document.getElementById("quote_currency_input").Value = "Gambian
Dalasi"
objIE.Document.getElementById("flipper").Click
Do While objIE.busy: Loop
End Sub
Regards,
Sam Mathai Chacko (GL)
On Thu,
icks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exc
No, do not create an xlsb. Create an xlam. The add it to the add-in list.
Sam
On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad wrote:
> created as xlsb now tell me how to use, I mean how to use now
>
> Aamir Shahzad
>
> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote:
&g
hed file may be doing some thing wrong. In your
> previous mail you instructed to create xlsb file why?
>
>
> On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko wrote:
>
>> Aamir, you have to past the code in the code module, not the
>> workbook/sheet module
>>
>&
e it go in sub folders also ???
>>
>>
>>
>> On Wed, Oct 26, 2011 at 21:08, Haytham Zoromba
>> wrote:
>>
>>> Supper, thanks
>>>
>>> Bregards,
>>> Haytham
>>>
>>>
>>> On Wed, Oct 26, 2011 at 21:01, Sam M
hzad
>
>
> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko wrote:
>
>> OK. Click on record macro from the developer tab. Short cut key ALT+T+M+R
>>
>> Then in the option to select store macro in, select personal workbook.
>> Then click OK. Then do anything o
Are you looking for this?
http://www.excelfox.com/forum/showthread.php?196-List-Of-All-Files-In-A-Folder
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 27, 2011 at 12:27 AM, Haytham Zoromba
wrote:
> Dears,
>
> does any one know how to make an index of folder an its sub
ed in .xlsx format cannot contain VBA, except that it can be a
place holder while it is yet not saved.
Regards and Happy Diwali to all,
Sam Mathai Chacko (GL)
On Wed, Oct 26, 2011 at 7:43 AM, xlstime wrote:
> excel 2007 not support VBA coding so save ur in excel 2003 or xlsb
>
>
&g
------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel
event, but a
workbook event, like Workbook activate or deactivate.
Regards.
Sam Mathai Chacko (GL)
On Tue, Oct 25, 2011 at 9:48 PM, Chris Boxall wrote:
> My macro needs to know when the user changes sheet.
>
> ** **
>
> I have located the Workbook_SheetActivate event but I’m
With a bit modification to Noorain's formula, you can make it a little more
smaller
*=--SUBSTITUTE(A2,CHAR(160),"")*
Regards,
Sam Mathai Chacko
On Tue, Oct 25, 2011 at 7:32 PM, dguillett1 wrote:
> I have this in my personal.xls file assigned to a custom button
> Selec
=DATEVALUE(TEXT((LEFT(A2,11)),"MM/DD/"))
OR
=DATEVALUE(LEFT(TRIM(A2),10))
rEGARDS,
Sam Mathai Chacko
On Tue, Oct 25, 2011 at 9:22 PM, John A. Smith wrote:
> Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real
> date format). Please see atta
.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on f
,
Sam
On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad wrote:
> SAM please further brief step by step procedure which are you saying as I
> am very new in macro.
>
> Aamir Shahzad
>
> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko wrote:
>
>> Aamir, copy the entire code
.
Regards,
Sam Mathai Chacko (GL)
On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad wrote:
> thank you very much SAM for this wonderful solution. But I want to make
> this to permanent function you can say by means of add in, I want to make
> add in to use this "MultiResultLookedup"
ion, we
get
LEFT(A1,MIN(75,84)). The 75 and 84 are hypothetical positions of (h and 0x,
which then gives LEFT(A1,75)
Hope you now have deciphered the entire bit.
Regards,
Sam Mathai Chacko (GL)
On Tue, Oct 25, 2011 at 12:47 AM, Zeunasc wrote:
> You assumed correctly, and the resulting code wor
No response. Had to assume. Here's the assumption as well as the file.
=IF(LEN(A1)<>LEN(SUBSTITUTE(UPPER(A1),"REMARK","")),A1,LEFT(A1,MIN(IF(ISERROR(SEARCH("
0x",A1)),255,SEARCH(" 0x",A1)),IF(ISERROR(SEARCH(" (h",A1)),255,SEARCH(&q
401 - 500 of 610 matches
Mail list logo