Hi Hari,
Thanks for the Excel Book. Can you please mail me the Advance Book of Excel as
well ?
Thanks a lot in advance
Regards
Vineet
- Original Message -
From: hari kumar
To: excel-macros@googlegroups.com
Sent: Saturday, May 09, 2009 9:57 AM
Subject: $$Excel-Macros$$ Re:
Hi I have been watching this thread for a long time. While doing a little
research on Google. I came up with two links that I thought can help you
guys.
http://www.eggheadcafe.com/conversation.aspx?messageid=31624005threadid=31623988
Hi Everyone,
I have a following problem: I have to find the average from the range,
say: B2:J10, without taking into account a few cells from that range.
Is there any simple formula (vba macro) which calculates it?
Thank you
Damian
--~--~-~--~~~---~--~~
kindly help by sending Ebook on Excel.
regards,
B.SRINIVASA RAO
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
Use =indirect(b1c1)
On 5/6/09, Yu vincent2...@gmail.com wrote:
Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
has. Now B1 has valueA, and C1 has value 1, I want D1 has the
formula =A1
It doesn't work when I type =B1C1 in D1... Can anyone gives
Hi Damian,
could you explain the part without taking into account a few cells from
that range
Is there any specific parameter for that... or is that random.
It would be better if you attach a sample worksheet that will help visualize
the data properly.
Regards,
Andy
On Sun, May 10, 2009 at 7:13
HI Harmeet,
The code is giving a Run time error '445'
the object doesn't support this action.
the error is in the fllowing line:
With Application.FileSearch
Regards,
Kunal
On May 9, 9:11 pm, Harmeet Singh harmeet.hew...@gmail.com wrote:
below is the code
Dim ownf, raws, cc, cno As
All,
I need some help. I am on a tight deadline, I have a handful of excel
spreadsheets with several thousand records in each.
For each spreadsheet I need to select the row of data that occurs
every fifty rows, and copy it to a new workbook. So, dataset A; I need
to copy Row 51, 101, 151, 201
Hi All,
i know excel very well expect marcos can any one please send me a book so
that i can learn MACRO ASAP.
Regards,
Surendra
On Sat, May 9, 2009 at 9:57 AM, hari kumar prekkeh...@gmail.com wrote:
Hi Prateek,
FYI.
This book covers basics. if need more details or advanced, let me know.
Hi All,
I have a small query in MS Access.
I have 2 tables
1.Test1
2.Stable
The title column in Test1 table have few titles which are same as Title
column in STable. I want to lookup the title in STable and update the
Scolumn in Test1 Table with Yes or No.
That is if the Title is present in
kindly help by sending Advance Ebook on Excel.
-- Forwarded message --
From: bathina srinivasa rao ask_...@rediffmail.com
Date: Sun, May 10, 2009 at 5:48 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com
kindly help by sending Ebook on Excel.
regards,
B.SRINIVASA
Hello,
I want to use conditional formatting for the below issue:
eg: If say given cell of a row has value Friday then i want that
entire row to be in Blue in color.
Is the above function possble using conditiona formatting or mix of
standard excel features, wihout using macros
Thanks
balla
Hi,
If your 'Given Cell' is A1:
Select the row you want to format
In the Conditional Format window, select 'Formula is'
In the formula thingy, put:
=$A$1=Friday
Set the formatting you want.
Click ok.
Hope this helps.
Regards - Dave.
Date: Sun, 10 May 2009 19:43:56 -0700
13 matches
Mail list logo