20201007 0830
01 되는 거 처럼 되어 있다.
Cells properties can be used as parameters in the Range property. The following refers to the range A1:E5:
Range(Cells(1,1),Cells(5,5))
Excel 2013 VBA and Macros: Referring to Ranges
"www.informit.com/articles/article.aspx?p=2021718&seqNum=7"
그런데 안된다. → 된다 20210122 2211
Range(Cells(1, 1), Cells(3, 3)).Select |
02 트릭이 필요하다.
address1 = cells(1,1).Address address2 = cells(5,5).Address |
'[PA] 업무자동화 > [XL]Excel & VBA' 카테고리의 다른 글
XL Date Time Formatting (0) | 2020.10.07 |
---|---|
XL Group Pivot Table (0) | 2020.10.07 |
XL Copy and Paste a Range (0) | 2020.10.07 |
XL 엑셀 Code Snippet (0) | 2020.04.14 |
VBA 더블클릭하면 체크되게 (0) | 2020.04.11 |