selecting and showing cells 
Author Message
 selecting and showing cells

starting with the following code:

With Worksheets("Jobsheet1")
.Range(.Cells(1, coljs), .Cells(25, coljs + 5)).Activate

how can I then have the above range brought into view ready for use at the
end of the procedure.

Thanks

Craig



Sat, 04 Jun 2005 07:00:15 GMT  
 selecting and showing cells
Application.Goto Worksheets("Jobsheet1").Range(.Cells(1, coljs), .Cells(25,
coljs + 5))


Quote:
> starting with the following code:

> With Worksheets("Jobsheet1")
> .Range(.Cells(1, coljs), .Cells(25, coljs + 5)).Activate

> how can I then have the above range brought into view ready for use at the
> end of the procedure.

> Thanks

> Craig



Sat, 04 Jun 2005 07:30:00 GMT  
 selecting and showing cells

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 04 Jun 2005 10:39:24 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. protection: select locked cells, select unlocked cells.

2. displaying cell contents based on mouse/cell selected in another cell

3. Select one cell to select a part of a row

4. Problem selecting a cell using Range.Select

5. Selecting a cell if a chart is selected

6. SELECT.ALL or SELECT(!$A$1:active.cell())

7. Select the cell in a tabel 1 when you select a value in tabel 2

8. Cell formula to show value of any cell within range

9. getting values form two cells so both values show in one cell

10. show formula on a cell-by-cell basis


 
Powered by phpBB® Forum Software © phpBB Group