By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 137 - Concatenate a string to create a range

Range("A22:C35").select

first_row = 22
last_row = 35

Range("A" & first_row & ":C" & last_row).Select