Hi, here is another one:
http://excel-macros.googlegroups.com/attach/4d97bd1a51c32c86/O%27Reilly+-+VB+%26+VBA+In+A+Nutshell.zip?part=4
On Sep 15, 7:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote:
> Would anyone be able to recommend a good book to purchase wrt to
> Macros and VBA?
>
> Thanks i
The simplest way to learn about macrol is as follow:
1st plan what you want to record? For example I want to create a macro for copy
data from sheet 1 to sheet 2.
2nd Go to Tools menu-Macro-Record new macro and write the name of macor
3rd Select sheet1 or Cotrol A than past it on the second sh
Hi, in this lik there is a good manual:
http://excel-macros.googlegroups.com/attach/4d97bd1a51c32c86/O%27Reilly+-+VB+%26+VBA+In+A+Nutshell.zip?part=4
On Sep 18, 10:31 pm, "v sheeba" <[EMAIL PROTECTED]> wrote:
> Hi all,
> I would like to learn excel macros. Its any one teach me the simplest way
>
Sheeba
The best way to learn VBA in excel is
set record macro on
and do what you want to do
then see the code
Improvise
When you get stuck
email here in the forum and some body will help you through
All the best Happy macroing.
sbaloo
On Fri, Sep 19, 2008 at 10:01 AM, v sheeba <[EMAIL PROTE
You can use the following function as a solution. There might be better
ones.
1. Open VBA editor ; Insert a module and then copy-paste the following code.
'-
Option Explicit
Function lastWord(r As Range, sWord As String)
Dim i As Integer, j
Hi all,
I would like to learn excel macros. Its any one teach me the simplest way
to learn macros. I don't know visual basic.
On Thu, Sep 18, 2008 at 8:23 PM, Balachander S <[EMAIL PROTECTED]> wrote:
> try this
>
> To return the week number of a date we can use the WEEKNUM formula. It will
> r
