PDA

View Full Version : VBA/Excel Workbook Help



tbawayne76
09-24-2017, 07:18 PM
Hi guys, Im extremely new to VBA and fairly new to excel. My question is how do I insert a formula (or perhaps write the code to do so) in my VBAProject to display the result of Hourly Rate * Hours Worked in my Excel Workbook and into a specific range say "B4"?

Also, how can I assign headers to certain rows in my excel worksheet from my VBAproject?

Feel free to answer one of the questions or both!

Thanks!

LouCziffra
09-25-2017, 03:50 AM
Why not record the macro. That will give you the code for the formula. While you are about it you could add the headers and the recorder will write the code for that too.

mdmackillop
09-25-2017, 04:06 AM
Post a sample workbook showing your data and also the expected outcome. Go Advanced / Manage Attachments