ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD