{"author_name":"PageTAKA","author_url":"https://blog.hatena.ne.jp/PageTAKA/","blog_url":"https://pagetaka.hatenablog.jp/","published":"2019-01-09 19:37:29","provider_name":"Hatena Blog","url":"https://pagetaka.hatenablog.jp/entry/2019/01/09/193729","title":"VBA:Excel\u300c\u7bc4\u56f2\u306e\u6b21\u306e\u30bb\u30eb\u300d\u3067\u6761\u4ef6\u306b\u3088\u3063\u3066\u306f\u30a8\u30e9\u30fc\u767a\u751f","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/P/PageTAKA/20190109/20190109185657.jpg","version":"1.0","description":"\u3068\u3042\u308b\u672c\u306b\u306f\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u66f8\u3044\u3066\u3042\u308b\u306e\u3067\u3084\u3063\u3066\u307f\u305f\u3089\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002[\u753b\u50cf\uff1aExcleVBA\u3001\u5b9f\u884c\u6642\u30a8\u30e9\u30fc1004]VBA\u3092\u5b9f\u884c\u3057\u305f\u3068\u3053\u308d\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3001\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u306f\u300c1004\u300d\u3068\u3044\u3046\u3053\u3068\u3060\u305d\u3046\u3067\u3059\u3002\u300c\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5b9a\u7fa9\u307e\u305f\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5b9a\u7fa9\u306e\u30a8\u30e9\u30fc\u3067\u3059\u3002\u300d\u3068\u6848\u5185\u304c\u3064\u3044\u3066\u3044\u307e\u3059\u3002\u672c\u306e\u89e3\u8aac\u304c\u9055\u3046\u3093\u3060\u308d\u3046\u304b\u3068\u3001\u3044\u308d\u3044\u308d\u3084\u3063\u3066\u3044\u308b\u3046\u3061\u3001\u300cOffset() \u300d\u304c\u4f55\u3092\u6307\u3057\u3066\u3044\u308b\u304b\u72b6\u6cc1\u306b\u3088\u3063\u3066\u9055\u3046\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u60f3\u50cf\u3057\u3001\u30c1\u30a7\u30c3\u30af\u3057\u3066\u307f\u307e\u3057\u305f\u3002 \uff1c\u30a8\u30e9\u30fc\u306f\u6700\u521d\u306e\u30c7\u30fc\u30bf\u306e\u30b3\u30d4\u30da\u3067\u767a\u751f\u3059\u308b\uff1e Sub down_Offset() On Error GoTo Err1 Range(\"A2\").Copy R\u2026","type":"rich","height":"190","provider_url":"https://hatena.blog","blog_title":"pagetakaBlog","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpagetaka.hatenablog.jp%2Fentry%2F2019%2F01%2F09%2F193729\" title=\"VBA:Excel\u300c\u7bc4\u56f2\u306e\u6b21\u306e\u30bb\u30eb\u300d\u3067\u6761\u4ef6\u306b\u3088\u3063\u3066\u306f\u30a8\u30e9\u30fc\u767a\u751f - pagetakaBlog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["PC\u3001\u30cd\u30c3\u30c8\u3001\u60c5\u5831\u7aef\u672b"]}