Get instant live expert help on I need help with excel vba left

“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

Excel VBA How do I resize a range of cells to remove the first two (left) columns in a range? Do I have to resize to Range.Columns.Count - 2 and then offset +2 columns, or is there another way to do it?
Solved by E. C. in 19 mins
hi i am looking for vba expert . i need to modify an vba excel file.
Solved by X. E. in 21 mins
I have an excel spreadsheet for a rugby competition with multiple sheets that is running a vba code to sort group tables automatically when match results are entered and then return which teams progress to the next round. The vba code to sort the teams works. However, there is an issue with then using the scrollbar to select an input cell. The cell selected is always the one which would be in the original view and not the view I'm in. Example: If A1 is in the top left corner of the screen and then I scroll to make AB11 the top left cell. I would then select AB11 and the computer would instead select A1. How do I amend the vba code to fix?
Solved by O. L. in 22 mins
by vba ,i need to copy and fill down this formula ActiveCell.FormulaR1C1 = "=RC[-1]/1.17/52" or any other formula by selecting any cell only from the next left cell having data not blank thanks Sumbo
Solved by C. L. in 14 mins
VBA Excel. I have request from my boss to have a button on the VBA Excel Form to print a work order and put the Equipment Name that is on the VBA form in the Work Order (a word doc) and print it.
Solved by F. F. in 26 mins