havent heard, still waiting for the answer, wake up...
--- On Tue, 4/14/09, shannu shannu shannur...@yahoo.com wrote:
From: shannu shannu shannur...@yahoo.com
Subject: Urgent help filter macro
To: excel-macros@googlegroups.com
Date: Tuesday, April 14, 2009, 10:16 AM
Hi All,
Hi Guys,
Can any one help me on the conditional formatting .
Cheers
Surya
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and
Hi All,
I have a requirement to work with internet and to enter some text,
need to select option buttons, need work with check boxes and to click
the buttons and all.
Could you please send me how to do it taking Google.com as an example.
Waiting for your reply.
Thanks Regards,
Krishna.
Rightly said Harmeet,
Because if the file is not attached, then we have to do Data Clensing
Data Processing... and it involves considerable time dedication, which
will ultimately restrict and shorten our time that can be utilised to give
solutions to others... right harmeet??
Pls attach the
Thank you!
However this is a link describing a code to create palindromes instead
detect them.
Luciano
On 14 abr, 20:28, ddadmin2009 ddadmin2...@gmail.com wrote:
check the below
linkhttp://funwithexcel.blogspot.com/2009/04/macro-to-write-mathematical-...
You might tweak or extend from
Hi Ayush, thnks for sharing this information, II am using your idea to
update a table which contains employee and amounts column, here I need one
more help I have a chart and I need to colour few bars if the amount is
greater than 50 or 40 USD every day, and I want help where in if the table
is
This is Rahul Kumar Sureka , I want to learn from the start the basic
fumctions of excel and also MACRO's as it is useful in my job . My
basic requirment is PIVOT Tables and learning Macros Could you guys
please help me out of this.Waiting for your prompt reply.
Srinivas,
Oh WOW.. I don't think you're getting the power of this tool AT ALL!
Copy/paste makes a DUPLICATE of the data selected.
The duplicate can then be modified so that it is then DIFFERENT than the
original.
This tool seems to act like a web-cam, in that it shows you what the area LOOKS
There's LOTS of reasons for wanting to do this.
Hmm... I take exception to ddadmin's comment
writing a code around save is not recommended...
I use the Workbook_BeforeSave event in many of my applications.
(I'm currently maintaining about 130,00 lines of VBA code!)
Here's a couple of uses:
1) I
hi,
see this link :
http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/
with regards
Bala
On Apr 15, 11:16 am, kris krishna.agnihot...@gmail.com wrote:
Hi All,
I have a requirement to work with internet and to enter some text,
need to select option buttons,
Dilip, How can u read my mind. awesome..
On Wed, Apr 15, 2009 at 3:51 PM, Dilip Pandey dilipan...@gmail.com wrote:
Rightly said Harmeet,
Because if the file is not attached, then we have to do Data Clensing
Data Processing... and it involves considerable time dedication, which
will
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
check the article above for color conditional formatting with an example
(steps 3 and 4). Tell me your specific case so that I can tell you what to
keep in the formula or cell value.
On 4/15/09, Suryaprasad.bv
Hello,
I have a macro to reformat the height of a group of merged cells which
makes up the comments section. All the others cells on the worksheet
are locked apart from this one and the sheet protected. However when
the macro runs to re-format the box height, the cell becomes locked
disabling
Hi,
use this code
Tools -- Referance
Add
Microsoft Internet Controls
Microsoft HTML Object Library
Dim brs As InternetExplorer
Sub IE()
Set brs = New InternetExplorer
With brs
.Visible = True
.Navigate http://Google.com;
End With
Do While brs.Busy Or brs.ReadyState
please check the attached example and let me know is that you needed
thanks
Regards
Santosh Bahuguna
On Wed, Apr 15, 2009 at 11:46 AM, kris krishna.agnihot...@gmail.com wrote:
Hi All,
I have a requirement to work with internet and to enter some text,
need to select option buttons, need
Your reasons seems to be very much valid Paul - I was just cautioning - but
here you already have a check after every save - thatz really good.
On 4/15/09, Paul Schreiner schreiner_p...@att.net wrote:
There's LOTS of reasons for wanting to do this.
Hmm... I take exception to ddadmin's comment
Hi Surya,
Please find the solution attached. I have tested it also and it is working
fine.
Note: You may find that some of the time entered by you in the earlier rows
have changed, it is because of the testing done.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91
Hi
pl find the file attached, soultion is, first replace - with (space)
then
put a formula next to date row, that is hour(a1), it will fetch hour from
the date n time part then
apply conditional formatting on hour, if hour is greater then 7 then it will
color the cell.
regards,
Deepak Rawat
Formula dekh ke chakar aa gaye.hahahahaa
I must say awesome work.
Cheers.
On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Surya,
Please find the solution attached. I have tested it also and it is working
fine.
Note: You may find that some of the time
Hi
I want excel dumps for certification
advance excel 2007
plz help me???
On Wed, Apr 15, 2009 at 9:58 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Formula dekh ke chakar aa gaye.hahahahaa
I must say awesome work.
Cheers.
On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey
Rahul --
There is an area on my web site to help you begin ...
Getting to Know VBA
www.beyondtechnology.com/vba.shtml
-- particularly for you ...
Beyond that, I can recommend anything written by John WALKENBACH
... he does an excellent
Hi Surya,
As long as your data is in the format provided in your sample file, the
solution in the attached will be ok.
Regards - Dave.
Date: Wed, 15 Apr 2009 12:59:11 +0530
Subject: $$Excel-Macros$$ Color Conditional Formatting
From: suryaprasad...@gmail.com
To:
u can use input box for entring a date while running macro
On 4/16/09, Steve sspatri...@yahoo.com wrote:
Hi,
I need to insert a message box in the middle of a macro that will
request the user to enter a Start Date or give them the option to
skip it and
let the macro continue running. Any
23 matches
Mail list logo