selecting column down to variant cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 3 Aug 2005 07:49:21 -0700

Is it possible to find the bottom of a sheet, say there are 1500 entries in
column A... and then select F9:F1500 if column F doesn't have values in every
row?

For example, the next time the macro is run thier maybe 1505 rows in the
sheet...

here is a test code that doesn't work for me... but may help convey my idea.

Dim c As Variant

Range("A9").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 5).Select
Set c = ActiveCell
Range("f9").Select
Range(Selection, Selection.c(xlDown)).Select
.

Follow-Ups:
- Re: selecting column down to variant cell
  - From: Ron de Bruin

Prev by Date: Re: How do I set Excel cell format to "Text" from VB.NET?
Next by Date: Re: Version Control
Previous by thread: Incorporating DATE into formula
Next by thread: Re: selecting column down to variant cell
Index(es):
- Date
- Thread

Relevant Pages

Re: SORTING MACRO TO CLEANUP MESSY SHEET
... Sport, not ok. ... all the data are contained in the sheet, only the order inside the line has ... macro from another forum wizzard...please read my first post... ... Have a look at the script of that macro called "sandy" ...
(microsoft.public.excel.programming)
Re: Print macro wont work
... The *fast* way to do page setup in Excel is to use the XLM (Excel 4 Macro ... macro sheet is active; syntax 2 applies if a chart is active; syntax three ... Foot specifies the text and formatting codes for the workbook footer. ...
(microsoft.public.excel.misc)
Re: Print macro wont work
... The *fast* way to do page setup in Excel is to use the XLM (Excel 4 Macro ... macro sheet is active; syntax 2 applies if a chart is active; syntax three ... Foot specifies the text and formatting codes for the workbook footer. ...
(microsoft.public.excel.misc)
Re: Entering Debug after delete sheet
... On the 'Lists' sheet is a command button. ... Private Sub cmdBuildLists_Click ... ' Macro created 2/24/2009 by John ... On Error GoTo ErrThisSub <-- BreakPoint. ...
(microsoft.public.excel.programming)
Re: Entering Debug after delete sheet
... I had the same problem with no code in the worksheet module. ... On the 'Lists' sheet is a command button. ... ' Macro created 2/24/2009 by John ... On Error GoTo ErrThisSub <-- BreakPoint. ...
(microsoft.public.excel.programming)