Dear Suresh,
Attachment has been solved and re-attached. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/27/09, suresh k wrote:
>
> Sorry,
> Now with attachment
>
> On Thu, Aug 27, 2009 at 8:23
Test
On Thu, Aug 27, 2009 at 1:17 PM, vivek agrawal wrote:
> it prompts because it needs the SAP Records worksheet to be opened when it
> executes the statement...
> excel checks all the open workbooks and tries to find the workbook
> referenced hence you need to keep the workbook open befor
Vivek,
I wanted to thank you for this - it works much better than what I had
written :P
On Jul 21, 6:58 am, vivek agrawal wrote:
> Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com - Saving energy-Save Earth
>
> -- Forwarded message --
> From: vivek
Hi Liuxin,
This is because, when you use absolute reference ($ref$), conditional
formatting logics on the entire row is checking if that particular reference
is meeting the logics or not. Moreover, when you apply that logic towards
right direction to cover entire row, the logic still checks only
I end up getting a circular reference when I try to code this
I have certain reports that recur every 9 days, 16 days, 22 days, 43
days and 76 days respectively. Some of these are workdays and some of
them are calendar days.
I have a weekly report tracker that lets me track which report is due
on
Hi
As per what you want... my answers are in red with yellow background
The best way for what you want is that sort the column and then apply the
formula in red with yellow...
Hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-S
One of you requested that I post my macro code, so here it is. What
this macro is supposed to be doing is populating comboboxes on another
worksheet. It does that, but when I save and reopen the workbook they
are no longer populated. I think I need to be doing something on a
more global level, but
Hi Dilip,
Can you check this attachment. Its having three options "TRUE", "FALSE" and
"Not available. In this case is it possible to highlight entire rows in
different color based on the result.
On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote:
> Hi Suresh.
>
> Attached file has the scenari
This might be helpful.
http://www.cpearson.com/excel/TimedClose.htm
Norman
On Thu, Aug 27, 2009 at 7:50 AM, Jack wrote:
>
> i need some vb to check if the time is greater than eg IF Application
> TimeValue > ("08:00:30") Then
> activeworkbook.close
>
> Any ideas
>
> Many thanks
>
> >
>
--~--~
i would like to have a list say of 50 stocks defined either within the
macro or in a column, and then i would like to pull the data from
yahoo. currently the way im doing this is:
cell1=http://ichart.finance.yahoo.com/table.csv?s=
cell2=ERY <-- stock symbol
cell3= &a=00&b=1&c=2009&d=…
then cell
Suresh,
This might help you
http://www.mrexcel.com/hof001.php
Norman
On Thu, Aug 27, 2009 at 7:21 AM, suresh k wrote:
> Hi Guyz,
>
> Whenever we use conditional formatting it will be applied for current cell
> only.
>
> Is there anyway that if the condition is true the entire row should be
> co
Hi all,
I am working on a report with many pivot tables in different worksheets.
Request your help in:
1. Refresh all the pivot tables of all the sheets.
2. Autofit all the colums of the pivot table( Column fields, datafields and
rowfields)
Would really appreciate you help in this matter.
--
Dim i, j, k As Integer
For j = 9 To 500
For i = 1 To 200
ActiveCell(i, 0).Value = Application.WorksheetFunction.Average
(Range("r[-i]c[j+5]:r[2000]c[j+5]"))
Next i
Next j
im guessing its pretty straight forward
--~--~-~--~~~---~--~~
-
I have a question.
When I use the relative reference in the formula, there is only one
cell colored.
While if I use the absolute reference, the complete row is colored,
why?
On 8月27日, 下午10时53分, Dilip Pandey wrote:
> Dear Suresh, I think you forgot to attach the file. Please re-attach and
> sen
Dear Suresh, I think you forgot to attach the file. Please re-attach and
send. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote:
> Hi Dilip,
>
> Can you
What "format" is your time (TimeValue)?
Where are you getting it?
Keep in mind that in an Excel worksheet,
a cell may LOOK like time but it really isn't.
It is a numeric value that represents a fraction of a day
for instance:
What you SEE as 8:00:27
is actually .3336458333
Or it COULD be 40052.333
i need some vb to check if the time is greater than eg IF Application
TimeValue > ("08:00:30") Then
activeworkbook.close
Any ideas
Many thanks
--~--~-~--~~~---~--~~
--
Some important
Hi Suresh.
Attached file has the scenario and the explanation for your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote:
> Hi Guyz,
>
> Whenever w
You could hide all sheets and set password protection.
then, in the VBA macros, unprotect the sheets.
Set Password protection on your VBA code.
then, the ONLY Way for the user to see the sheets is for the macros to be
turned on.
You could create a cover sheet that tells the user to turn on macros
Hi guys,
thanks a lot for your help.
That's exactly what I wanted!
Regards,
Epi
On 27 Aug., 06:39, Dave Bonallack wrote:
> Hi Epi,
>
> One way is to use the Union thingy
>
> Union(Range(Cells(1, 1), Cells(2, 2)), Range(Cells(3, 3), Cells(4, 4))).Name
> = "RangeName"
>
> Regards - Dave
>
>
>
>
Hi Guyz,
Whenever we use conditional formatting it will be applied for current cell
only.
Is there anyway that if the condition is true the entire row should be
colored???
Regards,
Suresh
--~--~-~--~~~---~--~~
-
Hi
I am using vba and Reuter data everyday. I didn't get your question that
clearly.
normally I would use =RtGet("IDN",RIC,FieldName) to get live market
data.
I've never use application.evaluate(RIC) ...what is for?
On Thu, Aug 27, 2009 at 10:15 AM, thedoc wrote:
>
> Hi,
> I'm lo
Thanks Vidyut..!!
Your second query is also solved and the spreadsheet containing solution is
attached herewith. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 27, 2009 at 12:03 PM, vidyut mo
Thanks Vidyut...!!!
SumProduct formula will work in Excel 2003. But SumIFs will work only on
Excel 2007. For better understanding of availability of the function in
different functions, try Microsoft Site or google. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 981092974
Hi,
I'm looking for a way to link to Reuters live market data in vba.
Doing this from a workbook is relatively straightforward, however I
don't want any links in my spreadsheet as this slows things down
considerably.
Currently, I'm using the following vba code:
Application.Evaluate ("Reuters Co
it prompts because it needs the SAP Records worksheet to be opened when it
executes the statement...
excel checks all the open workbooks and tries to find the workbook
referenced hence you need to keep the workbook open before executing the
sub procedure
hope this helps
Thanks and Regards,
V
Hi Everybody,
Can you please help me with the below formula
Thanks and Regards
Sanjay Singh
On Tue, Aug 25, 2009 at 12:44 PM, Sanjay Singh
wrote:
> Hi Everybody,
>
> I need help with below Vlookup function in macro.
>
> Following is the code I am presently using
>
> ActiveCell.FormulaR1C1 = "=
27 matches
Mail list logo
