Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2016, 03:43 AM
Debaser's Avatar
Debaser Debaser is offline Copy data btw worksheets using public arrays Windows 7 64bit Copy data btw worksheets using public arrays Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default


Public variables have to be declared outside all routines, but set within one. You can either use public Functions that simply return the array you need, or use public Constants that are delimite strings, and then Split them whenever you need an array.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data btw worksheets using public arrays Summing data from multiple worksheets in a workbook and placing into another worksheet safrac Excel 17 10-04-2022 12:21 PM
Can you copy & paste cells across worksheets and preserve reference to worksheet? New Daddy Excel 2 11-27-2013 07:19 AM
Copy data btw worksheets using public arrays Advanced Filter - Copy matching records in two worksheets morgantobin Excel 1 03-29-2013 03:58 AM
Finding sub-sets of data in worksheets Rudi Excel 3 01-28-2013 06:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft