Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a macro to several cells
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a macro to several cells
Hi Kibui,
You proably do not need VBA for this. In Excel, look at help forVlLookup Worksheet Function.. --- Regards, Norman "Kibui" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a macro to several cells
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" wrote in message ... Hi Kibui, You proably do not need VBA for this. In Excel, look at help forVlLookup Worksheet Function.. --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying filtered four cells by means of macro | Excel Discussion (Misc queries) | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Copying cells with a macro | Excel Discussion (Misc queries) | |||
Trouble with a macro - copying cells | Excel Programming | |||
stuck on final prat of spreadsheet "macro copying cells" | Excel Programming |