copying a macro to several cells

[Kibui]

Hi All,
I want to copy a macro to several cells with the results showing next to the
columns
e.g.
marks grades
85 A
75 B
65 C
50 D
instead of me running the macro every time for each student.

[Norman Jones]

Hi Kibui,

You proably do not need VBA for this.

In Excel, look at help forVlLookup Worksheet Function..

---
Regards,
Norman



"Kibui" <Kibui@discussions.microsoft.com> wrote in message
news:7A5C2AA9-B220-4431-850F-A65D1541644E@microsoft.com...
> Hi All,
> I want to copy a macro to several cells with the results showing next to
> the
> columns
> e.g.
> marks grades
> 85 A
> 75 B
> 65 C
> 50 D
> instead of me running the macro every time for each student.
>
>
>
>
>
>

[Norman Jones]

Hi Kibui,

> In Excel, look at help forVlLookup Worksheet Function..

should read:

In Excel, look at help for the VLookup Worksheet Function..


---
Regards,
Norman



"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:u6rxDon%23EHA.1604@TK2MSFTNGP12.phx.gbl...
> Hi Kibui,
>
> You proably do not need VBA for this.
>
> In Excel, look at help forVlLookup Worksheet Function..
>
> ---
> Regards,
> Norman