VB Syntax to select a range

X

xjetjockey

I am trying to select a range from E294 to E314. I have set the two
cells to"
FFR = E294
FTR = E314
These have been Dim'd as Variants, and will be re-used elsewhere in the
procedure later.

I want to select the entire range so that I can do a copy/paste
function.

Can you please tell me how to code this?

Thanks.

Robert
 
D

Don Guillett

Sub cr()
mc = "e"
ffr = 2
ftr = 14
Range(Cells(ffr, mc), Cells(ftr, mc)).Select
End Sub

better yet, with no selections.

Range(Cells(ffr, mc), Cells(ftr, mc)).copy range("x2")
 
C

Chip Pearson

Robert,

I do Excel consulting full time. Feel free to call me at the number on my
web site.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Top