Thread: simple Macro needed
View Single Post
  #2   Report Post  
stnkynts stnkynts is offline
Junior Member
  
Posts: 6
Default
I am not quiet sure why you cant just use a function in cell L20
=G17*.4

But since you asked here is a macro to do it.

Code:
Sub Macro1()

Range("L20").Value = Range("G17").Value * 0.4

End Sub
Reply With QuoteReply With Quote