copying a macro to several cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Kibui,

You proably do not need VBA for this.

In Excel, look at help forVlLookup Worksheet Function..
 
Hi Kibui,
In Excel, look at help forVlLookup Worksheet Function..
Click to expand...

should read:

In Excel, look at help for the VLookup Worksheet Function..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnTime Change_Event macro AND copy to sheet2 macro trouble 7
VBA set thick borders around non empty cells in range 0
Macro storing as a date? 11
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Need Macro... 8
how to convert COUNTIF() into VBA macro 0
Macro 2
Slope from a range of cells 1

Back
Top