VBA excel

E

emmcee

Joined
Sep 6, 2011
Messages
5
Reaction score
0
Hey guys,

I wrote this code that works to calculate the average total hours using the dates which obviously works however, I just wanted to be able to change the range "E3" and E34" so that if I apply to another file WITHOUT knowing the range I could still get the answer and the code will work, without changing the range in the module. Could anybody help me with that. I want the answer to go in the cell "B15"


Sub CalculateHours2()

Range("B15").Value = DateDiff("h", Range("E3").Value, Range("E34").Value)

End Sub

Thanks!
 

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

Excel VBA 1
correct syntax for LEFT in vba 3
Excel VBA - Problem with Closing Print Preview 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
VBA set thick borders around non empty cells in range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
worksheet change 1
VBA Excel - Cell input from another worksheet 1

Top