Thanks Dilip,
It is on the same line of my requirement. just one more thing. Can we make a
refresh button , by clicking that All the selected cell having the dropdown
will get blanked.
Thanks for your time.
Regards,
Saurabh
On Tue, Jan 5, 2010 at 2:51 PM, Dilip Pandey wrote:
> Dear Doki,
>
>
Bro Attach File
On Tue, Jan 5, 2010 at 5:07 PM, Prathap . wrote:
> Hi There..
>
>
>
> I have excel file which is protected.
>
>
>
> Can anyone please help crack the password. If possible, then pls tell
> me. Keeping the confidentiality in to consideration i can mail the excel
> file to the concer
please send the file.
On Tue, Jan 5, 2010 at 5:07 PM, Prathap . wrote:
> Hi There..
>
>
>
> I have excel file which is protected.
>
>
>
> Can anyone please help crack the password. If possible, then pls tell
> me. Keeping the confidentiality in to consideration i can mail the excel
> file to the
better use google for this
On Tue, Jan 5, 2010 at 5:07 PM, Prathap . wrote:
> Hi There..
>
>
>
> I have excel file which is protected.
>
>
>
> Can anyone please help crack the password. If possible, then pls tell
> me. Keeping the confidentiality in to consideration i can mail the excel
> file to
There was a typo. Please read step 6 as following:
6. Scroll and look forMicrosoft Word 10.0 Object Library. Check the box to add
it to VBA project.
_
"There are known knowns. These are things we kn
There's several ways to approach this.
the first question is:
How insistent are you on using VBA?
I have a list of 12 names that I need to sort "randomly".
what I did was to put column next to the name with =rand()
I then sort by this value.
In fact, I created a button that "calculates" the sheet
I have a list of 10 items and I want to select randomly (and
repeatedly) from the list.
Once I have selected an item, I want to be able to select randomly
from the other 9 items. After 10 tries i should have selected all
items once.
For the 11th try I should be able to select randomly from all 1
Your highlighting didn't come across in the email
(or on the post for that matter)
but I can guess...
it's the Cells(i,"E").Value = line isn't it?
I think we have a LOT to talk about.
First of all.. to your problem:
You're starting in row 1 (i = 1)
do you happen to have column headings?
if so, the
Hi There..
I have excel file which is protected.
Can anyone please help crack the password. If possible, then pls tell
me. Keeping the confidentiality in to consideration i can mail the excel
file to the concerned .
Thanks in advance
--
---
Hi Alokeshwar
Tried the command button. Got an error "Compile error: Cant find project or
library" line highlighted was .Wrap = wFindStop
The excel version I am using is Excel 2000 incase its required.
Also, thanks for the effort. Looking forward to hearing from you again.
Thanks
Ashish
On
simple = a2*b1 will help
On Tue, Jan 5, 2010 at 2:45 PM, manoj kumar wrote:
> Hi all
>
> I have some data in cell a2, a3, a4 and also b1,b2,b3,b4
>
> Now I want to multiply these no with each other with a single drag.
>
> Please help
>
>
> --
>
>
It looks like you have:
A B
10
05 20
10 30
15 40
What do you want to multiply? where do you want to put the results?
You said you want to "multiply these # with each other"
does that mean you want to multiply A2 with B1 and B2 and B3 and B4?
or A2 * B2,
A2 * B2 ...
??
Paul
On Jan 5, 4:15
pls help me its very urgent pls
On Wed, Dec 16, 2009 at 3:58 PM, ruben dasan wrote:
> pls help me out gurus
>
>
>
> -- Forwarded message --
> From: ruben dasan
> Date: Mon, Dec 14, 2009 at 1:03 PM
> Subject: $$Excel-Macros$$ Reg : Help in excel macro
> To: excel-macros@googlegro
Hi all
I have some data in cell a2, a3, a4 and also b1,b2,b3,b4
Now I want to multiply these no with each other with a single drag.
Please help
--
--
Some important links for excel users:
1. Follow us in TWITTER
Dear Doki,
Required validation (drop down) is there in the attached workbook.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jan 4, 2010 at 9:38 AM, Doki wrote:
> Im stuck with one prob
You are welcome Ashish,
I have tested the macro as well and it is working fine.
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 5, 2010 at 12:34 AM, Ashish Sharma
wrote:
> Hi Dilip,
Hi Dave,
Attached please find the file with sample data, I have seprated titles
Character wise...we have 3 categories..
ENGLISH, EUROPEAN (Diacritics) and Multibyte (Chinese, Japanese, Korean
etc).
Please have a look and help me if it is possible.
Thank you very much!!
ANISh
On Mon, Jan 4, 2010 a
I get "Run Time Error 13 Type Mismatch" when I run the following code,
the code actually takes an input date and a column filled with date
values is supposed to be subtracted from the input date value; the
value obtained after the subtraction has to be stored in the next
column. Can anyone help me?
You are welcome Suhas..!!
As it is done using Data- Validations only, hence you would find it quite
easy.
Reach out to me in case of any issues.
Best of Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
Thanks you very Much Mr Praveen and Mr Dilip, Its so easy :(
On Jan 5, 12:28 pm, kvc praveen kumar wrote:
> Hi,
>
> Please find attached the solution for your request. I implemented this
> using sheet events. So it will not work in other sheets. Only in sheet1 this
> will work.
>
> Please chec
20 matches
Mail list logo
