Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to express a cell address into numeric for array use
Im trying to to convert a cell address (ie E4) into some numeric form so I can enter it into a 2d array
Im not sure how to do this especially when there is a number and letter. Also related is that im trying to clear a cell if it doesnt meet some criteria. It keeps looping for several iterations Dim rng As Range Set rng = Target.Cells With rng.Select 'I tried selection.clearcontents but loops 'also tried Cells(i + 3, Chr(68 + j)).Select where i and j are used in for loops End With Thanks Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to express a cell address into numeric for array use
Susan,
Dim str str = "E4" Debug.Print Range(str).Row Debug.Print Range(str).Column str = "AI4" Debug.Print Range(str).Row Debug.Print Range(str).Column By this, I am trying to show that if you have a string, I use str, containg a cell address string, you can use the Range object row and column properties to get a number. This also takes care of a string like AI1, as my example shows. The Cells can take a column letter or number, so there is no need for the Chr. Just use Cells(i + 3, j +4).Select although of course you never need to do a Select ;-) -- HTH RP (remove nothere from the email address if mailing direct) "Susan Hayes" wrote in message ... Im trying to to convert a cell address (ie E4) into some numeric form so I can enter it into a 2d array Im not sure how to do this especially when there is a number and letter. Also related is that im trying to clear a cell if it doesnt meet some criteria. It keeps looping for several iterations Dim rng As Range Set rng = Target.Cells With rng.Select 'I tried selection.clearcontents but loops 'also tried Cells(i + 3, Chr(68 + j)).Select where i and j are used in for loops End With Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking on cell with email address opens Outlook Express | Excel Discussion (Misc queries) | |||
Separating Alpha from Numeric in Address Cell in Excel | Excel Discussion (Misc queries) | |||
Find a value in an array and return cell address | Excel Worksheet Functions | |||
How do I access Outlook Express email address book using Excel | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) |