Hello I have inherited and tweaked some VBA code which copy and pastes a range of cells into an email for me. (I have attached a picture of how it is formatted)
I would like to make a dynamic cell reference which concatenates the letter A with the number I have written in the yellow highlighted cell next to the word row(Cell G1). Hence the output would be A2...
Applying this to the below, if I change the number in cell G1 to 4 the VBA Range would then change to A4:C4 as opposed to the current A2:C2? My goal is to make the below Cell Reference dynamic... Is that possible?
ActiveSheet.Range("A2:C2")
I tried using both the concatenate function and & sign but neither seemed to do the trick. Would appreciate any guidance here!
Attempt 1:
ActiveSheet.Range(""A"&"G1":"C"&"G1")
Attempt 2: ActiveSheet.Range("Concatenate("A",Activsheet.Range("G1")):Concatenate("C",Activsheet.Range("G1"))")
