getting the value from an adjacent cell.

[GS7CLW]

Hope everyone is doing well -- only 3 more days til FRIDAY!!!

Just a quick question:

If:
RSIDzip = ActiveCell.Offset(1, 0).Value
is Col A Row 2
how do I progmatically get the value (RSID) in Col B Row 2 (RSID)

Col A .... Col B
Zip ....... RSID
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=64>25003</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 width=64>5D3E</TD></TR></TBODY></TABLE>

 

[jim may]

RSIDzip = ActiveCell.Offset(1, 0).Value ' indicates your activecell is A1
is Col A Row 2
how do I progmatically get the value in Col B Row 2 (RSID) -- If activecell is still A!

then use: RSIDzip = ActiveCell.Offset(1, 1).Value

 

[GS7CLW]

Re: getting the value from an adjacent cell. - SOLVED

Thank YOU!!!!!!!!!!!!!!!!!!!!!!!!!