View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Solutions Manager Solutions Manager is offline
external usenet poster
 
Posts: 27
Default last row of sheet1 to use in a formula in sheet2

You were right and the answer is perfect. As for the other, this is me not
typing well. SLRow and LRow should have been the same. Thank you for your
help and patience. This forum is an oasis in a desert.

"Dave Peterson" wrote:

Just a typo that was in the original that was carried over in your response:

Range("A1:E(" & SLRow & ")")
should be:
Range("A1:E" & SLRow)
or
Range("A1:E" & LRow)

I'm know that the ()'s shouldn't be there. I'm confused by the SLRow/LRow
stuff, though.