xldown and xlright
Instead of using ("D23, Range D23
(xldown).Address).end Why not try Range("d23").CurrentRegion.Cop -- Message posted from http://www.ExcelForum.com |
xldown and xlright
The currentRegion will change from transmittal to
transmittal depending on the amount of rows one uses to list their drawings being sent out. the people using this will click on a macro button labeled "LOGIT" and have VBA do all the rest after they fill out their transmittal. Most using this do not know VBA and little know Excel. -----Original Message----- Instead of using ("D23, Range D23 (xldown).Address).end Why not try Range("d23").CurrentRegion.Copy --- Message posted from http://www.ExcelForum.com/ . |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com