Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows("12:18").Hidden =
Worksheetfunction.countif(Range("A1:G2"),"ABC") > 0
End Sub
On Apr 2, 2016 19:18, "NIJ" wrote:
>
>
> On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>>
>> I want to aply below macro to cells A1 to
received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to e
group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.
workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to e
=--TEXT(RIGHT(A1,6),"00\/00\/00")
On 27 Feb 2015 11:47, wrote:
> I have a data like below where I need only date.
>
> S270215
> R270215
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://
any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to
Dan, you can get it yo work in Excel 2010 or above. There is a property
they introduced which will help to identity the actual interior color or
the color rendered by conditional format.
Regards
Sam
On 7 Aug 2014 06:57, "Daniel Parmet" wrote:
> I have a macro (first I've ever written!) that work
or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because y
ta in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
>
iled.
Dim SrcCmod As VBIDE.CodeModule
Dim DstCmod As VBIDE.CodeModule
Thanks,
Sam Mathai Chacko
On Mon, Apr 28, 2014 at 1:30 PM, Vaibhav Joshi wrote:
> Hi
>
> Check reference is given to Microsoft Visual Basic for Applications
> Extensibility 5.x"
>
> Thanks
>
>
Ondrej, for that you'll have to enable programmatic access to VBA. Just
search the internet how to do that, or post back. Someone will help you.
Regards,
Sam Mathai Chacko
On Apr 27, 2014 7:49 PM, "Ondrej" wrote:
> HI buddies
> there is an error in the last sequence of th
Read Rule No. 3
Regards,
Sam Mathai Chacko
On Wed, Feb 12, 2014 at 1:00 AM, Bernardo Pereira wrote:
> Here's the file I need to crack!! Please help me!!
>
> Tks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT
re subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit t
Srini, are you looking to subtract dates in column C from column B or vice
versa, ie, B-C or C-B? In addition, some values are coming as #N/A. What to
do with those?
Regards,
Sam Mathai Chacko
On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde wrote:
> Dear all
> I want to subtract one dat
:$A$4))
Regards,
Sam Mathai Chacko
On Sun, Dec 1, 2013 at 8:56 PM, Nishant Sharma
wrote:
> 1 4
> 2 3
> 3 2
> 4 1
>
>
> On Sun, Dec 1, 2013 at 8:34 PM, ashish koul wrote:
>
>> can u share sample file ?
>>
>> On Sun, Dec 1, 2013 at 7:54 PM, Nishan
The property TopLeftCell in itself is of type range. The code above can be
shorter.
Sub test()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
MsgBox shp.TopLeftCell.Address
Next
End Sub
Regards,
Sam Mathai Chacko
On Tue, Nov 19, 2013 at 2:22 PM, Chandra Shekar <
chandrashek
Are you looking for this?
=COUNTIF($D$2:$D$15,"S")
Regards,
Sam Mathai Chacko
On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes wrote:
>
>
> First of all thank you. I am, at best, a novice user of excel. Even though
> we use it for its most basic functions daily. I am a
---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to exc
PFA
On Thu, Oct 31, 2013 at 11:50 PM, Hilary Lomotey wrote:
> thanks Sam, can you send it in excel format, i typed indirectvba=then i
> refered to the datavalidation, but am getting an error. kind;y send me the
> file. thanks
>
>
> On Thu, Oct 31, 2013 at 6:15 PM, Sam M
Function INDIRECTVBA(strSource As String)
INDIRECTVBA = Evaluate("=" & strSource)
End Function
Regards,
Sam Mathai Chacko
On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey wrote:
> Hello Experts,
>
> i need an assistance with an alternative way of getting the indir
g emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
Hi mum,
The 5 digit number is the equivalent value of the corresponding date in
that cell. You should see the correct format if you press CTRL+`
` is normally found just about the TAB key
Regards,
Sam Mathai Chacko
On Fri, Sep 20, 2013 at 8:31 PM, Dawn wrote:
> Hi!
> Im updating my
Hi Dave,
Since many of us have switched to Excel 2007 or above, it would be nice if
you can attach a picture of this bespoke menu, and then try to relate to
what you are expecting in your new version of Excel.
Regards,
Sam Mathai Chacko
On Thu, Sep 19, 2013 at 8:38 PM, Dave Tomlinson wrote
Interesting. I've worked through 8 to 14, never got a chance to work on 15.
Did you try changing the modal property of the userform? Or a line in the
end saying UserForm.activate?
Sam Mathai Chacko
On Sep 7, 2013 8:01 AM, "John Wilson" wrote:
> I'm in the process of
understand -- I want to learn it though, not just
> use it :)
>
> Thanks Sam,
>
> Clark
>
> On Sunday, September 1, 2013 3:03:53 PM UTC-5, Sam Mathai Chacko wrote:
>>
>> Try this Clark
>>
>> With Range("A1:A" & Cells(Rows.Count, &qu
r any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to
Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm
On Aug 21, 2013 11:04 AM, "P.VIJAYKUMAR" wrote:
> Respected Mog-Godiva,
>
> You can find the digitizer from the following links,
> http://digitizer.sourceforge.net/
> http://www.mathtools.net/Excel/Graphics_and_Visualization/
>
Cross-posted at
http://www.excelfox.com/forum/f2/extract-unique-values-based-on-dependant-combobox-selections-1353/
Please read http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/
Regards,
Sam
On Saturday, 10 August 2013 02:18:19 UTC+5:30, Ricardo Fourie wrote:
>
> good day
>
> i h
My understanding was that Don was actually looking for a result that is in
M/Y format, not date format. So the solution should be =TEXT(DATE(2013,1,*No.
Of Days*), "m\/d") where *No. Of Days* is the range where the numbers are
listed, for example A2.
Regards,
Sam Mathai Chacko
On
In fact you probably don't need that - 1. Remove it. I'm just typing this
on my handset, so please don't mind.
On Aug 8, 2013 6:50 AM, "Sam Mathai Chacko" wrote:
> Don, try passing the number of days to the date function like this.
>
> =TEXT(DATE(2013,1,No. Of
Don, try passing the number of days to the date function like this.
=TEXT(DATE(2013,1,No. Of Days - 1), "m\/d")
Sam MATHAI CHACKO
On Aug 8, 2013 4:11 AM, "Don Barton" wrote:
> Greetings,
> I work at a hospital laboratory and we have an expiration date barcode on
>
XCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com
"MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.
To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, vis
mail to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Sam M
oup.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more op
ow any good site from where i Learn array in vba.
>
>
> On Sat, Jun 22, 2013 at 1:22 PM, priti verma wrote:
>
>>
>> Thanks sam its working fine,
>>
>>
>> On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko wrote:
>>
>>> Range("A1").Cu
Range("A1").CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum,
TotalList:=Array(4, 5, 6)
Sam Mathai Chacko
On Sat, Jun 22, 2013 at 1:08 PM, priti verma wrote:
> Hi group,
>
> pleaase help me to solve this .see attachment for more clarification.
> I want a macro f
u get in to
> cell edit mode. So sheet change event stops, if you want to copy data to
> destination more than once you can achieve it with right click.
>
> Cheerz.
> On 16 Jun 2013 17:28, "Sam Mathai Chacko" wrote:
>
>> It wasn't Single click that Sajid
e
Set rng = Range("E" & Cells(Rows.Count, "E").End(xlUp).Offset(1, 0).Row)
cancel = True
With Selection
Selection.Copy Destination:=rng
End With
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jun 16, 2013 at 4:09 PM, VBA VABZ wrote:
> Hi
>
> Try this code:
>
&g
subscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit
members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googleg
And this one too =MROUND(A1-0.25/2,0.25)
Regards,
Sam Mathai Chacko
On Wed, Apr 17, 2013 at 10:28 PM, Kanwaljit Singh wrote:
> Much Better Paul :)
>
>
> On Wed, Apr 17, 2013 at 10:24 PM, Paul Schreiner
> wrote:
>
>> since you're rounding to .25,
>> then you
ers and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsub
ooglegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Sam Mathai Chacko
--
Are you =EXP(E:
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5)
should be fine
Regards,
Sam Mathai Chacko
On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma wrote:
> Hi Kuldeep
>
> I think this formula fullfil your requirement.
>
> =ROUNDUP((A2*2)/1
If you want to look for exact matches, you must use =VLOOKUP(Lookup_Value,
ArrayRangeToLookAt, Column_Index, Whether Approximate Match Or Not)
So try =VLOOKUP(A1,$E$1:$F$17,2,FALSE)
Regards
Sam Mathai Chacko
On Wed, Apr 10, 2013 at 5:51 AM, wrote:
> I am really confused about the behavior
If your static workbook is opened from the code, then you probably are
keeping the 'dynamic' workbook open first. So it would be best to replace
your underlined code above with *Set wb = ActiveWorkbook*
Regards,
Sam Mathai Chacko
On Sun, Apr 7, 2013 at 7:28 AM, LJGIT wrote:
>
So what xlstime is saying is that you can use something like this in your
row 5 cells
D5=Offset(E7,Column()-Column($D$5),0) and copied across
or
D5:AX5=Transpose(E7:E250)... this has to be entered as an array formula
Regards,
Sam Mathai Chacko
On Sat, Mar 30, 2013 at 10:40 PM, xlstime wrote
nds.
>>
>> My question was to get sheet name which is left of my current sheet by
>> formula.
>>
>>
>> Any how i found solution completed my project by other way.
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>> On Wed, Mar 27, 201
w i found solution completed my project by other way.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
> On Wed, Mar 27, 2013 at 9:49 PM, Sam Mathai Chacko wrote:
>
>> You could also use the MID function instead of REPLACE
>>
>> example
>>
>> =MID(CELL(&qu
uming the reason you wanted to do it using formula was to avoid having
to do anything to do with macro in the first place)
Regards,
Sam
On Wed, Mar 27, 2013 at 9:44 PM, Sam Mathai Chacko wrote:
> I would agree with Paul. The best thing to do is to write a function like
> this
>
> Fun
And in your sheet (starting from the second sheet of course), use the
formula =INDEX(SheetNames,MATCH(SheetName,SheetNames,0)-1)
Regards,
Sam Mathai Chacko
On Wed, Mar 27, 2013 at 7:01 PM, Paul Schreiner wrote:
> How do you define "Previous Sheet Name"?
> Do you mean the name of
Here's an explanation to a similar but not exactly same formula. I'm sure
you can decipher your equation once you go through the link below.
http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/
Regards,
Sam Mathai Chacko
On Wed, Mar 20, 2013 at 8:15 PM, Chris wr
and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/gr
Rightclick on desktop, click on new then shortcut, then put the entire file
path and next... and an appropriate name for the link.
On Wed, Mar 13, 2013 at 8:32 PM, jayendra gaurav
wrote:
> how can i do it
>
>
> On Wed, Mar 13, 2013 at 7:37 PM, Sam Mathai Chacko wrote:
>
>&g
eceiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_o
Why don't you use the option
'Show zero in cells that have zero value', in the advanced tab of Excel
options (Excel 2007)
Sam Mathai Chacko
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar wrote:
> Dear Sir,
>I have ANY excel sheet ,some cells have value ZERO [ n
idential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from
workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ex
(lng), rng, 0)
If lngI <> 0 Then
WLOOKUP = rng.Cells(lngI)
Exit Function
End If
Next lng
End Function
Regards,
Sam Mathai Chacko
On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K wrote:
> Hi Friends,
>
> Need a help to create macro i
cribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this g
Divaker, can you post this file?
Regards,
Sam Mathai Chacko
On Wed, Nov 14, 2012 at 2:57 PM, Divaker Pandey wrote:
> Hello Exprets,
>
> I am struggling with the following strange problem in MS Excel 2007
> (rarely occurs).
>
> I have an excel Application with a userdefin
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
Is this what you wanted??
Sub CopyToRows()
Dim strRange As String
strRange = Selection.EntireRow.Address(0, 0)
Range(strRange).Value = Range("2:2").Value
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 1, 2012 at 12:50 AM, key log wrote:
> Hi all,
>
> This i
e the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : D
;>
>>>>>
>>>>
>>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use
r post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to ex
http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/
On Wed, Oct 17, 2012 at 8:39 PM, Sam Mathai Chacko wrote:
> Similar Thread here too
>
>
> On Wed, Oct 17, 2012 at 7:24 PM, Vabz wrote:
>
>> Hi
>> I have created a function to find our invali PAN.
>
ROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
--
Sam Mathai Chacko
--
Join official facebook page of this forum @
https://www.facebook.com/discussex
This is a link by Lalit Mohan, one of the members of this forum
http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/
Regards,
Sam Mathai Chacko
On Mon, Oct 8, 2012 at 11:05 PM, sreekanth m
wrote:
> Hello Friends,
>
> Can anyone help me to Open Gmai
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
--
Sam Mathai Chacko
--
Join official facebook page of this forum
=(I3-J3)/J3<0 (RED)
=AND((I3-J3)/J3>=0,(I3-J3)/J3<=2%) (YELLOW)
=(I3-J3)/J3>5% (GREEN)
Find attachment also
Regards,
Sam Mathai CHacko
On Sat, Sep 29, 2012 at 8:39 PM, vinod rao wrote:
>
> Any suggestions?
>
>
> I need conditional formating Yellow when the delta
http://www.excelfox.com/forum/f2/conditional-format-based-percentage-variance-585/
Regards,
Sam Mathai Chacko
On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote:
> Hi,
>
> I want to know how to do a conditional formatting on numbers based on the
> calculated percentage %
> Plea
received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
&
Yeah, when you go to a particular forum in the site, like Word Help, on the
top of the table, you'll find Forum Tools > Subscribe to this Forum
Regards,
Sam Mathai Chacko
On Tue, Sep 25, 2012 at 1:09 AM, V S Rawat g wrote:
> On 9/24/2012 11:09 PM India Time, _Sam Mathai Ch
http://www.excelfox.com/forum/f5/
Sam Mathai Chacko
On Mon, Sep 24, 2012 at 10:30 PM, V S Rawat g wrote:
> Sorry for OFF TOPIC post.
>
> Please suggest to me a similar active group for MS WORD Macros issues that
> I have to ask?
>
> Thanks.
> --
> Rawat
>
> --
&g
D10=MAX(0,MIN(D$8,$C2)-MAX($B2,D$7)+1)
And drag down and across
Regards,
Sam Mathai Chacko
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after
End If
MYFUNC = Join(.keys, "|")
End With
End Function
Regards,
Sam Mathai Chacko
On Sun, Sep 16, 2012 at 7:40 PM, dguillett1 wrote:
> Put this function in a REGULAR module. Then =myfunc(a1)
>
> Function myfunc(xx)
> Dim nodupes As New Collection
>
ss-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a work
The threads in this link talk a lot about Ribbon development in very simple
steps
http://www.excelfox.com/forum/f10/
Regards,
Sam Mathai Chacko
On Tue, Sep 11, 2012 at 10:50 PM, wrote:
> **
> Visit
>
> www.rondebruin.nl/ribbon.htm
>
> Sent on my BlackBe
ts in
> manually.
>
> David
>
> On 8 September 2012 17:44, Sam Mathai Chacko wrote:
> > Dave, I guess Paul's issue is more on not being able to enter this as an
> > array formula. Changing the vector array elements to strings probably
> > doesn't really make a di
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
> s
tps://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 no
Dave, I guess Paul's issue is more on not being able to enter this as an
array formula. Changing the vector array elements to strings probably
doesn't really make a difference if the issue is about entering the CSE
formula.
Regards,
Sam Mathai Chacko
On Sat, Sep 8, 2012 at 1:38 AM, Dav
an,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Sam Mathai Chacko
> *To:* excel-macros@googlegroups.com
>
IsNumeric(Mid(strText, lngLen, 1)) Then
lng = lng + 1
If lngLeaveDigits < lng Then
Mid(strText, lngLen, 1) = "*"
End If
End If
Next
ASTERIK = strText
End Function
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:57 PM,
Didn't you find my solution worthwhile?
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:52 PM, maksood alam <786maks...@gmail.com> wrote:
> Paul,
>
> I want excel function solution.
>
> On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote:
>
>> superb answer sam..
>&g
Shouldn't they be strings?
=LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{"#","#","#","#","#","#","#","#","#"})
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:37 PM, Paul Schreiner wrote:
> Odd...
> I
HTH
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:08 PM, james D wrote:
> Hi.
>
> I am a VBA developer (Excel mainly) - I have built an Excel dashboard
> which contains a userform with a treeview on it. It all works fine pre
> Windows 7 with Office 2010, but with Window
Would this help?
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786maks...@gmail.com> wrote:
> Partially correct, but it show as per below
>
>*Numbers*
> *Required out put*
> 555-55-5505
> ***-***-5505
> 555-55-125-0
> ***-
gt; NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this
No it won't. Try using
var = Worksheets("Name").UsedRange.Formula
Regards,
Sam Mathai Chacko
On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88 wrote:
> Hi sam,
>
> Thanks for the reply, but this would not give me information about other
> cell parameters like dependents.
Try taking all the values of the used range to a variant variable.
Example
Sub T()
Dim var As Variant
var = Worksheets("Name").UsedRange.Value
End Sub
Regards,
Sam Mathai Chacko
On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi wrote:
> Hello everyone,
>
> I am designing
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
> measure.
>
> 4) Acknowledge the responses
number, you can use a
simpler formula
=MODE(--SUBSTITUTE(ROUND(B3:B21,2),MODE(ROUND(B3:B21,2)),MAX(B3:B21)+ROW(INDIRECT("1:"&ROWS(B3:B21)))))
Regards,
Sam Mathai Chacko
On Fri, Aug 17, 2012 at 7:07 PM, dguillett1 wrote:
> Looks like homework to me also but this should do
uot;))
.DisplayAlerts = 0
Sheets(var).Delete
.DisplayAlerts = 1
End With
End Sub
Regards,
Sam Mathai Chacko
On Tue, Aug 14, 2012 at 8:02 PM, Rajan_Verma wrote:
> Hi Guys,
>
> Challenge is to Delete all Sheets Except one without any loop a
.
If VBA isn't there, something will be there that will be similar. And as
software evolves, people evolve. So, I for one, don't tend to be
apprehensive about changes, or rather, potential changes, such as those.
Regards,
Sam Mathai Chacko
On Sun, Aug 12, 2012 at 2:01 AM, yog
or any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr.
=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
Regards
Sam Mathai Chacko
On Mon, Aug 6, 2012 at 9:41 PM, ashish koul wrote:
> =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
>
1 - 100 of 610 matches
Mail list logo
