Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to using Address in selected Range
Hi All
In below part of VBA, I am using offset to build k1 value. How to using range("B" & row_value) replace offset (0,1) ? Dim rngToSearch As Range, rngToCheck As Range Dim SchShtRange As String Dim SchShtName As String Dim k1 As String SchShtRange = "A1:A5" SchShtName = "RangeA" Set rngToSearch = Sheets(SchShtName).Range(SchShtRange) 'change to suit For Each c In rngToSearch If c.Value < "" Then k1 = c.Value + "|" & c.Offset(0,1).Value ... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Address of selected range | Excel Programming | |||
Lower right cell address in a selected range - Excel 2007 | Excel Programming | |||
Get selected cell name/address | Excel Programming | |||
How do I convert a selected Cell address in a Range to Values? | Excel Programming | |||
How do you get a Selected Range address into a variable? | Excel Programming |