Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Dale Matthews on Jan 26 In MS Office Category.

making a spreadsheet cell name a global variable in the VBA project

Question Answered By: Adalgisa Miller on Jan 26

Yes.

Define the global variable as a range. Then set it to the reference during
initialisation.

E.g.

Public MyCell As Range

Set MyCell = Range("MyRangeName")

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on making a spreadsheet cell name a global variable in the VBA project Or get search suggestion and latest updates.

Related Topics:

Can a spreadsheet function change a cells appearance?
vba routine for eliminating rows with all zeros from spreadsheet
Problem implementing spreadsheet containing VBA code in Excel 2007
Copying current cell's value to another cell
Global Variable
Highlight a Cell, VBA or CF?
VBA code to add values in two cells which have formulas
Excel VBA Check When Cell Has Changed
VBA Array - return value to a cell
Using excel VBA to change a cell color
Fill VBA form with Cell values of an Excel sheet
Editing cell references w/ VBA
VBA TO SELECT ALL EMPTY CELL IN SUDOKU3*3
FormulaHidden property for a merged cell in VBA
cells containing formula that refer to user-defined VBA function
assigning text from cell to a variable
Declaring a Cell reference as a variable
Using a Defined Variable Range in a VBA SumIf
VBA variable range in a formula
how to get data into vba variable

Tagged:making spreadsheet cell name global variable in the vba project

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us