Get instant live expert help on How do I left$ vba

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

I have a vba code to sort some sheets automatically in the background. The vba works but when I use it, if I scroll around on the active sheet before selecting an input cell, the cell I think I have selected doesn't become active once the code has completed. Instead, the cell which would have been in that place on the original screen view is selected. Example: If A1 is the cell in the top left of the screen and I scroll to make AB11 in the top left cell. I then click to select AB11 but it doesn't select AB11 and instead selects A1. How do I correct the vba code to prevent this?

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?

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?

VBA CODE HELP. I need help in looping a VBA.