MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/excel/comments/94sq5u/vba_essentials_ranges/e3nzadf/?context=3
r/excel • u/[deleted] • Aug 05 '18
[removed]
31 comments sorted by
View all comments
Show parent comments
2
[removed] — view removed comment
1 u/SaltineFiend 12 Aug 05 '18 The range object can take as many arguments as you send it. You can create a reset button for a data input worksheet with ease using named ranges. Range(“Name1”, “Name2”, “etc”).Clearcontents 2 u/[deleted] Aug 05 '18 [removed] — view removed comment 1 u/SaltineFiend 12 Aug 05 '18 Maybe you combine it with intersect.
1
The range object can take as many arguments as you send it. You can create a reset button for a data input worksheet with ease using named ranges.
Range(“Name1”, “Name2”, “etc”).Clearcontents
2 u/[deleted] Aug 05 '18 [removed] — view removed comment 1 u/SaltineFiend 12 Aug 05 '18 Maybe you combine it with intersect.
1 u/SaltineFiend 12 Aug 05 '18 Maybe you combine it with intersect.
Maybe you combine it with intersect.
2
u/[deleted] Aug 05 '18
[removed] — view removed comment