VB Syntax to select a range

[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

 

[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")

 

[xjetjockey]

Thanks for your help with this. Do you happen to know anyone who does
VBA coding that I could hire to work on some projects? Thanks.
Robert
(e-mail address removed)

 

[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)