Hi Shiv,
Please find attached solution..
i am using indirect function,
About Indirect Function
Returns the reference specified by a text string. References are
immediately evaluated to display their contents. Use INDIRECT when you want
to change the reference to a cell within a formula without
Did you mean to attach the file?
Regards
David Grugeon
On 17 May 2013 14:32, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Prabhu,
Hope this file will be of little help to u.
Regards,
VIJAYKUMAR
On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Hi
Dear experts and all,
I am trying to learn excel macros from initial steps. please provide
some advance tips to learn the source from initial. Actually, i am learning
by recording the macros and trying to get the logic, but it does not make
me fullfil to learn. even i reading ebooks and
Two major things will help you. One is the help files which are invoked
whenever you click on a word in a macro and then press F1. I am sure you
have found that, but do you use it whenever you do not understand all about
a keyword such as Dim?
The other thing is intellisense. When you are
Thanks David sir,
yes you are right. self practice is the best platform for learning
initial steps. thanks for the advice. and henceforth i will keep learning
with the culture. but of all this, i think there should be a guidance which
helps in learning by understanding the concepts.i mean
Firstly, take a breath. Keep calm. Just because you're reading e-books,
googling for 2 months and you don't know how to use 'Dim'...doesn't mean
you should be ashamed. Humans are strange. They went to moon before
figuring out that it would be handy to install little wheels in luggage. My
point is
*Hi experts,
in the below code, am getting error on highlighted lines.. pls help*
Sub PROTECT_EACH_SHEET()
' Loop through all sheets in the workbook
For i = 1 To Sheets.Count
' Activate each sheet in turn.
Sheets(i).Activate
response = MsgBox(Do you want
Try replacing it with:
ActiveSheet.Protect , DrawingObjects:=True, _
Contents:=True, Scenarios:=True
OR
ActiveSheet.Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True
Whenever part of a syntax is appended in a second line, it is mandatory to
end the first line with an underscore
Dear Abhishek,
Your tips are brilliant, thanks for sharing those clues. it will be a
great inspiring, rhythm of elevation towards preparing self thorough in
aspect of macros. The cited *link* above is a great aspiration for a macros
beginners.
thanks for sharing and bringing back the life
What error are you getting? (I think I know the answer, but you should really
have provided that with your question)
Ask yourself:
What is Contents?
What is Scenarios?
I THINK, you'll find that Contents = True and Scenarios = True
are intended to be part of the ActiveSheet.Protect statement.
Dear Vijaykumar,
which file u refer to..? i dont find any attachment.
On 17 May 2013 10:02, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Prabhu,
Hope this file will be of little help to u.
Regards,
VIJAYKUMAR
On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky
Hi Abhishek,
the link http://www.excel-pratique.com/en/index.php; you given is really
useful.
Please suggest more link like this...
Regards,
Prabhu R
On 17 May 2013 17:43, Chaya chayamon...@gmail.com wrote:
Dear Abhishek,
Your tips are brilliant, thanks for sharing those clues. it
The link was shared with me by Priti. She is an active learner and finds
such stuff.
Priti - please share more links like this, if you have.
Regards,
Abhishek
On Fri, May 17, 2013 at 7:26 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Hi Abhishek,
the link
Very UsefulThanks to both of you.
Regards
Eugene
On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain abhishek@gmail.comwrote:
The link was shared with me by Priti. She is an active learner and finds
such stuff.
Priti - please share more links like this, if you have.
Regards,
*Hello*
*Have you ever thought of you as a Computer Scientist contributing to
flourish music and get benefited? And how if my second conjecture is that a
person who knows dance can know programming better? Or to make the two
together, “Computing could be taught and learned by using Music and
How it is to be used?
On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Use it *
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
*Sent:* 17 May 2013 10:19
*To:* excel-macros@googlegroups.com
16 matches
Mail list logo