Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Handle to a cell (Row and Column)
Hello Specialists
1. User selects a row, for example say Row#20. 2. I want to perform a calculation (formula say for example:cell value+100) on ColumnG and ColumnH of Row 20. Starting from cell G20 till end of Column (till last value) similarly for Column H also. (starting from row # 10 till end of value in columns G and H) 3. How will I get handle to column G and column H of Row 20 and perform the operation till the end of values in the column? Thanks in advance With regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Handle to a cell (Row and Column)
Already replied in your earlier posting: please check for responses before
re-posting ... startrow=Rg.row lastrow=Cells(rows.count,"G").end(xlup).row For r=startrow to lastrow Cells(r,"G")= ..... next r "Prakash" wrote: Hello Specialists 1. User selects a row, for example say Row#20. 2. I want to perform a calculation (formula say for example:cell value+100) on ColumnG and ColumnH of Row 20. Starting from cell G20 till end of Column (till last value) similarly for Column H also. (starting from row # 10 till end of value in columns G and H) 3. How will I get handle to column G and column H of Row 20 and perform the operation till the end of values in the column? Thanks in advance With regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|