Get instant live expert help on I need help with excel macro format

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a macro that would format the selected column as follows; the column lists hours worked in this format 45 minutes = .45, 3 hours and 40 minutes = 3.4, 1 hour and 1 minute = 1.01. I need to format this column so I'll be able to sum up hour and minutes.
Solved by I. J. in 15 mins
I am making an excel macro on a spreadsheet to format weekly data imports - these weekly imports will vary in their # of rows. I need to edit the macro's code so that it adapts to the weekly (and hence different) #of rows rather than the # of rows that were on the original file that the macro was built on :) can you help me ?
Solved by E. Y. in 23 mins
3. Create a macro (in this worksheet and assign to the shortcut key Ctrl+h) name it Headings. The macro formats cell A1 to Bold, 18 pt, pink font colour then inserts the heading PRICE LIST, then formats cell A2 to Bold, 14 pt then inserts the subheading Cross Stitch Kits. 4. Create a macro (in this worksheet and assign to a button on the toolbar) named Format. The macro formats the Cost figures to currency. Test the macro works by selecting the Retail figures and running the macro.
Solved by G. H. in 11 mins
How to compare 2 sheets using excel macro
Solved by O. J. in 25 mins
I need help on excel macro which send email
Solved by M. H. in 27 mins