Dear Grup,
'---naming a range, example
Dim NotCtr1 As Range
Dim IsSameRange as Boolean
Set NotCtr1 = Range(A1:C2)
Range(A1:C2).Name = Ctr1
'---refering a named range, example
Range(Ctr1).interior.ColorIndex = 16
IsSameRange = (NotCtr1 = Range(Ctr1))
MsgBox IsSameRange
On Feb 25, 10:36
I just got a new job after a years layoff. By trade I'm a unix person
but have now entered the microsoft world.
I'm currently having to d a lot of work in excel. One thing I
consistantly have to do is to put the current time into 1 cell and the
date into another cell. This has to be an easy
Hi
I have been trying to make these but have failed. ^ ^;;
I’d like to create a macro
A21 has a word called ‘Date’
And somewhere down in column A has a cell with a word ‘FBT Details’.
The location of FBT details depends on the amount of data between
these two headings. I’d like to remove any
*Hi Mike,
Simple function like this
12 Roosevelt Ave* *
=RIGHT(A1,14)* *
=LEFT(A1,2)* 12 Roosevelt Ave Roosevelt Ave 12
Hope it can help
Worawat
2010/2/25 Mike foehamme...@yahoo.com
Hi folks,
Looking for a function(if it exists) that will grab the first letter
in a string and
Dear All,
I have data around 5000 rows in excel file and i am using Microsoft office
2003 and in Microsoft office 2003 filter limit is upto 1000
is there any alternate to extent this filter limit in Microsoft office 2003
i am unable to upgrade Microsoft office 2003 to higher version because
i got the code
thnks
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 23, 2010 at 4:02 PM, ankur ankurpande...@gmail.com wrote:
hi experts,
i had one pdf file converter
pdf to different type of file like
thnks for handy tips
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 23, 2010 at 11:07 AM, Ayush Jain jainayus...@gmail.com wrote:
Ayush Jain has sent you a link to a blog:
Dear Group, An amazing tip to use
hi skanda
=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))
this is array formula use ctrl+shift+enter
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 10:15
Hi Markkim,
Would you please send the sample file containing this data?
Best regards,
Ayush Jain
On Feb 26, 6:18 am, Markkim mark@gmail.com wrote:
Hi
I have been trying to make these but have failed. ^ ^;;
I’d like to create a macro
A21 has a word called ‘Date’
And somewhere down in
ATTACHE ARRANGED DATA
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 11:56 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Sudesh,
Your data is not arranged properly. If this is not an ad-hoc
how can we minimize that window?
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Feb 20, 2010 at 9:54 AM, ankur ankurpande...@gmail.com wrote:
good one
Have A Nice Time Enjoy Life
Regards:
CMA Ankur
check youtube.com.there are very good examples
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Feb 17, 2010 at 6:00 PM, Puttu puttu...@gmail.com wrote:
Hi Team,
Can you send me any step by step procedure
our file section has very good material on macros and vba .download
stuff from there
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Feb 17, 2010 at 3:44 PM, chethan Bhadravathi
chethan...@gmail.com wrote:
Hi,
hi umesh
for learning vba , u can download books from our file section
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 16, 2010 at 4:45 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Please find attached
yes,
there is no problem with pirated software
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 9, 2010 at 11:51 PM, Harpreet Singh Gujral
harpreetguj...@gmail.com wrote:
Hi,
Will this work on pirated
ya sure
this is the code
127418901528
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 11:43 AM, Harshad K
harshadpl...@gmail.com wrote:
can you share with me
regards
harshad
check this link
http://excel.tips.net/Pages/T002403_Increasing_the_AutoFilter_DropDown_Limit.html
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 10:09 AM, gurdev singh gurdevha...@gmail.com
this has solved answer
http://en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 12:18 PM, ankur ankurpande...@gmail.com wrote:
hi abhishek
luckily i got
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 12:28 PM, ankur ankurpande...@gmail.com wrote:
hi abhishek
thanks for nice words...
this is downloaded software..i dont
19 matches
Mail list logo