4 ms·
With named ranges and named tables it is a hell of a lot easier to debug a sheet. (Not commenting on VBA)
by abricot 10y ago
With named ranges and named tables it is a hell of a lot easier to debug a sheet.
(Not commenting on VBA)
- oli5679 10y agoThe problem is if enough people have been working on a sheet for long enough it becomes very difficult to replicate your work. this is particularly true for projects involving data processing and if they have poor version control practices.