ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦³Ãöcells offset

[µo°Ý] ½Ð°Ý¦³Ãöcells offset

Sub test()
Dim rng As Range
Set rng =Cells(2.2)
MsgBox rng.Offset(-1, -1).Address
End Sub

¦p¤W
§âcells(2,2)´«¦¨Range("B2") ´N¥i¥H°õ¦æ
½Ð°Ý¦pªG­n¥Îcells ­n«ç»ò§ï©O??ÁÂÁÂ

¦^´_ 1# Brandy


    ©êºp¡A§Úµo²{¤Fcells(2.2)¤¤¶¡­n§ï","

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD