Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving between "row" and "range" formats in VBA
In general, I need to know; if I come upon a certain row, using the Range-Cells technique, perhaps in a loop, having arrived there, is there a way to activate the whole row? (I'm trying to learn how to move back and forth between these two types of ways of identifying and altering either a range or an entire row or colummn) Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving between "row" and "range" formats in VBA
cells(i,5).entireRow
rows(3).Cells(1,1).Offset(0,4) From the immediate window: i = 6 ? cells(i,5).entireRow.Address $6:$6 ? rows(i).Cells(1,1).Offset(0,4).Address $E$6 -- Regards, Tom Ogilvy "kls" wrote in message ... In general, I need to know; if I come upon a certain row, using the Range-Cells technique, perhaps in a loop, having arrived there, is there a way to activate the whole row? (I'm trying to learn how to move back and forth between these two types of ways of identifying and altering either a range or an entire row or colummn) Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |