| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Syntax to select a range
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Syntax to select a range
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") -- Don Guillett SalesAid Software "xjetjockey" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Syntax to select a range
Dim s as String
s=FFR & ":" & FTR Range(s).Select -- Gary''s Student "xjetjockey" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Syntax to select a range
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 Gary''s Student wrote: Dim s as String s=FFR & ":" & FTR Range(s).Select -- Gary''s Student "xjetjockey" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Syntax to select a range
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) "xjetjockey" wrote in message ups.com... 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 Gary''s Student wrote: Dim s as String s=FFR & ":" & FTR Range(s).Select -- Gary''s Student "xjetjockey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
| Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
| how to select a range that start in diferent row | Excel Discussion (Misc queries) | |||
| keyboard command used to select a range of nonadjacent cells? | Excel Discussion (Misc queries) | |||
| keyboard command used to select a range of nonadjacent cells? | Excel Discussion (Misc queries) | |||
Hybrid Mode
