viktoryeung
04-01-2003, 01:02 PM
Given a cell, how can I find the column # that it is in to give to a variable?
Count Columnsviktoryeung 04-01-2003, 01:02 PM Given a cell, how can I find the column # that it is in to give to a variable? Mikecrosoft 04-01-2003, 01:04 PM Are you talking about..... ?? viktoryeung 04-01-2003, 01:09 PM I have a Range that is a single cell. This cell moves to different Columns all the time. I would like to know what Column # the cell is in. :( viktoryeung 04-01-2003, 01:27 PM VB reads Column A as 1 Column B as 2 Column C as 3 etc.. If my cell switches Columns all the time, Is there way to target the Column Number it is in? loquin 04-01-2003, 01:34 PM Are we talking about VB-Excel in this thread??? viktoryeung 04-01-2003, 01:37 PM sorry, yeah this is Excel Im talking about viktoryeung 04-01-2003, 01:52 PM Got IT! this seems to work for my needs Dim x As Integer Sub FilterData() x = Range("a1:Named_Range").Columns.Count End Sub |
EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum