Thanks Praveeen,
It is mostly same what I was trying for. Just one more thing..
It sud be lik if i change the True to Flase or blank the Dropdown sud be
removed.The cell sud b completly empty.
Doki
On Mon, Jan 4, 2010 at 11:18 AM, kvc praveen kumar wrote:
> Hi Doki,
>
> Please check the attach
Hi Doki,
Please check the attached workbook and let me know if this is what you were
expecting.
Please run macro1
Regards,
Praveen
On Mon, Jan 4, 2010 at 9:38 AM, Doki wrote:
> Im stuck with one problem..I guess togather we can solve it..
>
> Prob is:
>
> I want a Dropdown (may be "Yes" n "No"
Im stuck with one problem..I guess togather we can solve it..
Prob is:
I want a Dropdown (may be "Yes" n "No") in the Worksheet with a if
condition.
Like If( TRUE) then I'll have a Dropdown (or list) says YES No but if
(FALSE) then Blank cell should appear...
Anyone need further clarification d
Consider using INDIRECT to refer to ranges. You can also use ADDRESS with ROW
and COLUMN functions with INDIRECT.
Regards,
Alokeshwar
9891442001
_
"There are known knowns. These are things we know t
dude, sumproduct was there to verify the result , i had already changed the
macro as per ur requirement, plz chk
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Thu, Dec 31, 2009 at 5:40 PM, Harmeet Singh wrote:
> Hi Madhu,
>
> pfa file.
> done some minor ch
Thanks Suresh,
To work with text, add following into the macro code, at the right place.
Selection.SpecialCells(xlCellTypeFormulas, 23).Select
Selection.ClearContents
Note:- Either you can exclude Formulae-as per available options OR Text
enteries (including Numbers, Text etc).
Let me kn
Hello Friends,
I am facing a problem in MS excel. I have one workbook with more than
10 worksheets. I had create a master sheet in which I have more than
200 rows contains the information pertains to different – different
worksheets. All worksheets are linked with master sheet. Each row
figure of
Hi...Dilip thanks 4 u r solution . nice indeed...
how to exlude the text from the clear selection
On Jan 1, 10:00 pm, Karthik Naidu wrote:
> Hi all am new to this grp..
> Happy New Year.
>
> Query: in macros how it can be programmed to clear the cells , except cells
> containing formulae
It's Ok and you are welcome to get back in case of any other quer(ies).
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1/3/10, San Pat wrote:
>
> Hi Dilip,
>
> I understood now and it was my
