Wrox Programmer Forums
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 20th, 2004, 09:07 AM
Registered User
Join Date: Jun 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Arrays

I have a template that needs to be filled out from fields coming from other excel spreadsheet available in the server( actually sheet names), I want to make available only this values to make the choice on Worksheet_change on that excel template, I can get all the worksheet names in msgbox one by one but I don't know how to pass them to one of the cells in my template, should do it on arrays?, how?, I want also to move the focus from the first cell the one on the right side and following one to right side, like for example if A7 is the first cell, 2nd one B7, 3rd C7, 4th D7, next A8, B8, C8, D8, etc..


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help With Arrays Crippy Ruby 2 March 6th, 2013 05:59 PM
arrays ozPATT Excel VBA 2 November 4th, 2005 06:11 AM
Multidemmesional Arrays OR arrays gmoney060 Classic ASP Basics 3 November 1st, 2004 03:42 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.