excel vba

  • Thread starter Thread starter bforster1
  • Start date Start date
B

bforster1

Tom O. Thanks for all your suggestions they are perfect. Can you tel
me how to hard code the % of revenue numbers??

Thank
 
Assume the calculation result (% of Revenue) will be in B9

and you want to begin recording results in column M

Further assume that you will have some identifying entry in A9 and you want
those in column N

N1: Title
M1: % of Revenue

Private Sub CommandButton1_Click()
Application.CalculateFull
set rng = cells(rows.count,"M").end(xlup)(2)
rng.Value = Range("B9").Value
rng.NumberFormat = Range("B9").NumberFormat
rng.offset(0,-1).Value = Range("A9").Value
End Sub
 
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

remove VBA codes while saving 1
PowerPoint Printing PPT to PDF without losing quality 1
Technology giants face European 'digital tax' blow 2
Autofilter using a value from a list. 2
Transposing hundreds of addresses in a column using VBA 7
Change Formula in sheet by adding a new part 2
VBA for index match and an IF statement to make a cumbersome formula easier 2
need help on delimited 3

Back
Top