How a macro auto-determine unspecified range

  • Thread starter Thread starter eric c
  • Start date Start date
E

eric c

Hi,
I have some data in column a & b, but the nos of input is no
specified; in column c a formula a*b is made. Can anyone advise me ho
a macro to copy the formula to the range in column C that just match al
data in column a&b?
Thank you
 
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

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Macro storing as a date? 11
Excel 2013 Merge Data 2
Transfer array element offset value to a matched value 3
Advice on multiple macros, same code just a different column 9
Excel Macro: insert formula into first blank cell in column & auto 2
Copy columns and paste with blank column between 5
Paste in column B using Last row of either column B, C or D. 10

Back
Top