Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Wayne Crawford on Feb 17 In MS Office Category.

assigning text from cell to a variable

Question Answered By: Ludwik Fischer on Feb 17

A1str() is an array definition.

Do you want an array? You'll need to dimension it and use subscripts.

Do you just want a simple variable? Remove the ().

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

Didn't find what you were looking for? Find more on assigning text from cell to a variable Or get search suggestion and latest updates.

Related Topics:

multiplying two integer variables and assigning to a long variable
to see if text in a cell in a column is contained in any cell
Vb code to transfer cells text to text box
Copying current cell's value to another cell
Assign a macro to a cell?
Declaring a Cell reference as a variable
making a spreadsheet cell name a global variable in the VBA project
merged cells formatted by text length for height
"browse" button in text cell
how are cell coordinates referenced on a clicked cell
Cell validation based on the contents of previous cell
A Paragraphs in one cells --> convert into a line in per cells
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
Moving data in the last cell of row to another column cell
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
Function needed to split the content of a cell into many cells

Tagged:assigning text from cell to variable

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