Hi OE,
Progmatically toggle what button?
VBA can change a button completely - the text, colour, shape, and the macro it
activates.
Regards - Dave.
> Date: Tue, 19 Jan 2010 12:37:55 -0800
> Subject: $$Excel-Macros$$ "Reset Ignored Errors" Excel Error Checking Options
> From: bruce.tay...@down
Hi Abhishek,
Did you try giving the complete path to the cell references directly?
like ='C:\DOCUME~1\PKARAN~1\LOCALS~1\Temp\notes327EC1\[Training
curriculum.xls]Sheet3'!$A$82
You can give the complete pathto the location of your masterfile directly.
Let me know if this works.
Regards,
Praveen
HI Ayush
Well, I thought I found a link so.. tried.. but still can not get it.
I googled it and found some links.. but still can not get what I
need.
Will you be able to provide me a link (probably video)??
cheer,
On Jan 17, 9:48 pm, ayush jain wrote:
> Hi Makkim,
>
> Have you ever used add-
Hi,
I need some assistance in unlocking a range of cells based on date
conditions
For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.
It should not allow the user to enter data for yesterday or
tomorrow...
Hello All,
While this may sound silly, I'm trying to concatenate values in 3
columns into a single cell to essentially create a list using a
formula.
A B C
1 Area1 Value1 Inadequate
2 Area2 Value2 Adequate
3 Area3 Va
Using Excel 2003
How do I programatically toggle this button. I can't find any
documentation and the macro recorder doesn't log the action.
thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER f
Hi everybody,
I'm facing a problem in updating data in two separate workbook can
anyone help me in this ?
I have 2 excel files one is Master file and other is the snapshot
file. All the working are done in the master file and in the snapshot
file all the different scenarios are show, in which val
Dear Ankkur, Thanks for the encouraging words...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jan 19, 2010 at 4:50 PM, ankur wrote:
> hi Dilip Sir
>
> Brilliant formula...
>
>
>
> On
hi Dilip Sir
Brilliant formula...
On 19/01/2010, Dilip Pandey wrote:
> Hi Rahul,
>
> Considering the following points, below is the formula designed to cater
> them all.
>
> 1) There may be digit 9 which can come earlier also.
> 2) There may by spaces and periods after "A/C No."
>
> =MID(MID
Hi Rahul,
Considering the following points, below is the formula designed to cater
them all.
1) There may be digit 9 which can come earlier also.
2) There may by spaces and periods after "A/C No."
=MID(MID(C7,FIND("A/c",C7),30),FIND(9,MID(C7,FIND("A/c",C7),30)),10)
Above formula assumes that
Thanks Dave
It's wonderful for and my work done very easy.
On 1/19/10, Dave Bonallack wrote:
>
> Hi Sudhir
> Have a look at the attached. It took some sorting! Hopefully it's what you
> need.
> Regards - Dave.
>
> --
> Date: Mon, 18 Jan 2010 14:12:24 +0530
> Subject
HI Sudir
plz check the attached file
you can hide red shaded column your original data will reflect the total
i had used this formula in cells
+IF(ISTEXT(B3),VALUE(+IF(B3="-",0,LEFT(B3,FIND("(",B3,1)-1))),B3)
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not t
12 matches
Mail list logo
