• Blog
  • YouTube Channel
  • 0800 612 4105
  • info@bluepecan.co.uk
Explore Close
Menu Close

Categories

Excel Training CoursesLive Online TrainingMicrosoft Project Training CoursesOnsite Microsoft Office TrainingTutorialExcel VBA TrainingExcel TutorialKentHampshireLondonBerkshireEssexSurreyExcel VBA TutorialOxfordshireWiltshireWord Training CoursesPowerPoint Training CoursesWest SussexBuckinghamshire

Tags

Microsoft ExcelExcel VBASUMPRODUCTExcel ChartsConditional FormattingVLOOKUPWorksheetsWorkbooksThermometer ChartDynamic array formulasSpilled arrayFile ManagementINDIRECTSWITCHTEXTJOINWordProtectionExcelChristmas

Archives

December 2020 November 2020 October 2020 September 2020 August 2020 July 2020 June 2020 May 2020 April 2020 March 2020 February 2020 December 2019
  • training options
    • remote training
      • Private Remote Training
      • Scheduled Remote Excel Courses
      • Scheduled Remote MS Project Courses
      • Scheduled Remote PowerPoint Courses
      • Scheduled Remote Access Courses
    • in-house training
      • Excel Training
      • Power Query Training
      • Power Pivot Training
      • Excel VBA Training
      • Project Training
      • Word Training
      • PowerPoint Training
      • MS Access Training
  • course feedback
  • pricing
  • Blog
  • YouTube Channel
  • 0800 612 4105
  • info@bluepecan.co.uk

In House Excel Training & MS Office Blog

  • training options
    • remote training
      • Private Remote Training
      • Scheduled Remote Excel Courses
      • Scheduled Remote MS Project Courses
      • Scheduled Remote PowerPoint Courses
      • Scheduled Remote Access Courses
    • in-house training
      • Excel Training
      • Power Query Training
      • Power Pivot Training
      • Excel VBA Training
      • Project Training
      • Word Training
      • PowerPoint Training
      • MS Access Training
  • course feedback
  • pricing
Excel TutorialExcel VBA TutorialTutorial

Excel VBA – Storing Data in Arrays & Dynamic Arrays

Chester Tugwell on

What is an Array? An array, like a variable is a somewhere to store data.  An array can however hold more than one value, for example an entire database of information with tens of thousands of records. Using arrays in your procedures makes your code potentially quicker than alternative methods for say performing calculations on…

Read More
← 1 … 16 17 18

Course Enquiries

LIVE ONLINE COURSES | VIRTUAL CLASSROOM | Private in-house or open, scheduled courses.


0800 612 4105

info@bluepecan.co.uk

SPREADSHEET DESIGN/CONSULTANCY
We also offer help with spreadsheet design.  Make your spreadsheets more efficient and easier to use with a little bit of help from us.


WORD TEMPLATES
Need help with your Word templates? We can help you create or modify your templates, including styles and protection.


ANY OFFICE DOCUMENT
We are happy to help you with any Microsoft Office document: Excel spreadsheets, Word documents, PowerPoint presentations, Access databases, Visio drawings etc


Email us at info@bluepecan.co.uk for a quote.


VISIT OUR YOUTUBE CHANNEL
Over 200 videos!

tel: 0800 612 4105
email: info@bluepecan.co.uk

Blue Pecan Computer Training Limited
Registered Office: Piper House 4 Dukes Court, Bognor Rd, Chichester, West Sussex. PO19 8FX

Registered in England and Wales No. 8004610

Copyright 2020

Privacy Policy

 

Blue Pecan Computer Training Ltd
This website uses cookies to improve your experience. Click on Accept to continue. Click Reject to exit this site. To manage your cookie settings, please click Read More. Accept Reject Read More
Please read our Privacy & Cookies Policy before using this site

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.