Excel VBA is not recording macro properly

Question

I ran across some issues while recording a macro in Excel. Although I followed numerous YouTube lessons, I was still unable to effectively record and execute macros. Here's an illustration: I should get something like this in the VBA editor when I record the action of choosing one interval: Range("C3:E7"). The range can be found in the VBA editor instead of Select ("C3:E7"). DataFields, which when executed obviously doesn't function.

The same thing happens when I attempt to record the process of calculating an average from an interval; the result is some weird code, like Bold. = "=AVERAGE(R[-2]C[-1]:R[1]C[-1])"

What do I lack? Is there anything I missed?

Answer 1

The "awkward code" is an R1C1 notation formula. This is the simplest method for writing relative formulas in VBA.

The macro recorder is not a tool that is faultless. When a macro is played back after being recorded, many things that worked perfectly while it was being recorded would not work. Additionally, there are some activities that the macro recorder completely misses. In certain circumstances, you must manually fix the code in accordance with the VBA documentation.

There isn't enough information in your code sample regarding the Range Select to tell what went wrong. Troubleshooting won't be possible without access to your data and details about your precise steps.