=MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),TRANSPOSE(CH
OOSE({1,3,2,4},TRANSPOSE($B$9:$F$9),TRANSPOSE($B$10:$F$10),TRANSPOSE($B$11:$
F$11),TRANSPOSE($B$12:$F$12
With CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [m
please help by providing microsoft navision notes
Thanks
Regards
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
See attached for desired solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent: Monday, August 27, 2012 11:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Required a search option in excel file
Hi Praveen,
Pleas
So that I do NOT have to waste time looking for the file, please provide the
one you need solved.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Friday, September 07, 2012 3:14 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macr
YES
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anjali .
Sent: Saturday, September 08, 2012 5:57 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Merged Cell
Mr. David,
Is it the rule of this group???
if it is, then definitely i will d
Sorry - that was Z5 not Z25
On 8 September 2012 21:42, David Grugeon wrote:
> Ok. I know that one.
>
> You need to get a column way out to the right, perhaps col Z set it to
> the same width as the merged cell and the same font etc. Say your
> merged cell is in B5 then in the cell Z25 you put =
Ok. I know that one.
You need to get a column way out to the right, perhaps col Z set it to
the same width as the merged cell and the same font etc. Say your
merged cell is in B5 then in the cell Z25 you put =B5 Now the
autoheight will work on the copy of the merged cell and you should see
the
There are many starter articles on which can be found with google.
check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then
search the ARCHIVES for EXCEL VBA.
More free tutorials and resources available at:
http://www.mousetra
Hi Group,
I am trying to Auto Fit Row Height, which is a merged cell, & formated with
wrap text
I want that cell to be auto fit automatically by clicking on the row header
or any other easy method.
Please help me out to get the same.
Thanks & Regards.
On Sat, Sep 8, 2012 at 4:56 PM, David Grugeo
Hi Anjali
No, as far as I know, it is not a rule.
I was just pointing out the steps you could take to make it more
likely that you would get assistance with your problem.
Please remember we are volunteers, and you really need to make it easy
for us to help you.
There is another reason. Frequen
Well, I guess then it's up to Paul to clarify what he's finding hard to do
here.
Sam
On Sat, Sep 8, 2012 at 2:34 PM, David Grugeon wrote:
> This is an array option in the formula and does not have to be entered
> with CSE. It is just overloaded. You put the curly brackets in
> manually.
>
> Da
I would imagine you don't need a rule to be polite God!!!
Sam
On Sat, Sep 8, 2012 at 4:27 PM, Anjali . wrote:
> Mr. David,
> Is it the rule of this group???
> if it is, then definitely i will describe it in the email.
>
>
> On Sat, Sep 8, 2012 at 3:19 PM, David Grugeon wrote:
>
>> Hi Anjali
Mr. David,
Is it the rule of this group???
if it is, then definitely i will describe it in the email.
On Sat, Sep 8, 2012 at 3:19 PM, David Grugeon wrote:
> Hi Anjali
>
> I don't want to open your workbook until I know what your problem is.
> Please describe it in the email.
>
> Thanks.
>
> On
don don don, i did't find it thats why am asking, why u take all the
thing in wrong way.
On 9/7/12, dguillett1 wrote:
> Is there some reason you cannot “google” it yourself
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> From: maksood alam
> Sent: F
hi Sujit,
I think you are trying to use ..UDF .First check the program in module
..its written or not...
Thanks
On Sat, Sep 8, 2012 at 3:27 PM, wrote:
> Dear Excel Gurus,
>
> Greetings!!!
>
> Can you pls tell me know how to convert numbers to text ? Eg: '23' to
> 'Twenty Three'.
>
> I tri
This article from Microsoft should help
http://support.microsoft.com/kb/213360
On 8 September 2012 19:57, wrote:
> Dear Excel Gurus,
>
> Greetings!!!
>
> Can you pls tell me know how to convert numbers to text ? Eg: '23' to 'Twenty
> Three'.
>
> I tried doing it with '=spellnumber' but its not
Dear Excel Gurus,
Greetings!!!
Can you pls tell me know how to convert numbers to text ? Eg: '23' to 'Twenty
Three'.
I tried doing it with '=spellnumber' but its not working in MS office 2007.
Regards,
Sujit Mazumdar
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this
Hi Rajan,
Thanks for the formula, it actually works great...only if i could be able
to interpret the rational used in the formula. Thanks very much.
The last column is not material as some cells had only one figure to total
trans amt without any figures for Tot Dep Trans Amt and Tot W/D Trans Amt
w
Hi Anjali
I don't want to open your workbook until I know what your problem is.
Please describe it in the email.
Thanks.
On 8 September 2012 18:26, Anjali . wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already
I think MScomt2 is a version of mscomctl, not really sure.
Seems we're all agreed things won't work in 64 bit office. Which is not
great for developers. It would take MS days to sort this out, as opposed to
developers and clients spending months sorting it out - not to mention us
developers wh
Hi - I missed that it was 64 Bit office. i am using the 32 bit 2010
office because I read about the things that were not going to work in
it. not crowing. Just apologising for not noticing the 64 bit
version.
It sounds from the article as though the 32 bit version will work but
then you are us
Hi David,
On the ultrabook if you go to Excel File->Help under where it says About
Microsoft Excel it tells you the version of Office. My guess is that yours
says (32-bit) is that right?
It appears MS have not released and have no intention of releasing a 64 bit
mscomctl and this means Treev
This is an array option in the formula and does not have to be entered
with CSE. It is just overloaded. You put the curly brackets 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.
Hi James
Yes - I have put a working Treeview in a user form on 2 different computers
One is a 32 bit win7 laptop and one is 64 bit win7 ultrabook. Both
run Office Professionsl 2010
The process is similar but different.
Basics - to register an OCX or DLL you have to run the command prompt
as ad
Month, Day, year format.
Select the column to date format (mm / dd / ) then use the macro
name is DayMonthYear
Code:
Sub DayMonthYear()
'Ðinh dang ngày tháng nam
'Day, Month, year format
Selection.NumberFormat = "mm/dd/"
End Sub
Select the column to the month, day, year (dd / mm / yy
--
Join official facebook page of this forum @
https://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 n
ok, this thread confirms to me, MS have completely screwed VBA developers
who used "common controls" and now use 64 bit Office. Seems they are not
going to make any solution - so we are all left with distributed code that
is just going to cease working
http://social.technet.microsoft.com/Forum
In fact, until someone with Windows 7 and 64 bit office 2010 tells me they
can make this work, I think it's impossible.
I was just reading something that tells me MS haven't released 64 bit
versions of controls (since they stopped supporting them ages ago) so given
that my Office 2010 is 64 bi
Hi Sam,
I just deleted all .EXD files, still the same
Can someone confirm to me, that they have an mscomctl.ocx that allows use
of a treeview with Windows 7 and Office 2010? If so, perhaps they could
send it to me? If a working file on an identically setup machine works that
is a good pl
James, MS had released a hotfix in April/May, and one of the libraries that
changed was the mscomctl.ocx, following which a lot of vba developers
started complaining about issues regarding ListView controls and treeview
controls.
Can you try deleting all the .EXD files in your VBA forms folder in
This doesn't work. It gives me a treeview on the new page in the control
toolbox, but when I try and put it on a form it says Invalid Argument.
I think I need to make some more points:
This is not unique to my machine - I have seen it on 3 totally independent
machines
I am trying to ascertain
I mean!
How to load the controls on the "Toolbox" when "Additional Controls
..." do not actually be in VBA
2012/9/8, Bé Trần Văn :
> 2012/9/8, james D :
>> Hi David,
>>
>> I already tried that too. Can you tell me, are you on windows 7 with
>> office
>> 2010 and seeing a treeview? I have been
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, David Grugeon
Hi David,
I already tried that too. Can you tell me, are you on windows 7 with office
2010 and seeing a treeview? I have been on 3 machines today none of which can
do it.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
34 matches
Mail list logo
