Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

Thank you Ashish it works perfectly. I will save this info so I don't repeat my question in the future. Much appreciated. -- John On Friday, November 4, 2016 at 4:08:49 PM UTC-4, ashish wrote: > try > > Range("A" & bottom & ":M" & bottom).Select > > On Sat, Nov 5, 2016 at 1:34 AM, Johnny

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

try Range("A" & bottom & ":M" & bottom).Select On Sat, Nov 5, 2016 at 1:34 AM, Johnny wrote: > I searched for the answer to this before posting. I know what I'm trying > to do can work, it's just that the syntax is kicking my butt > > I find the bottom row number (in my

$$Excel-Macros$$ Help with Proper Syntax for Range function with variables

I searched for the answer to this before posting. I know what I'm trying to do can work, it's just that the syntax is kicking my butt I find the bottom row number (in my case 462) using Column E in this example, and I'd like to select the Range from Column A to Column M with that row