Assigning cell value to string

[Barbarte]

Hi there,

How do I assign a cell value to a string?

For example:

Dim Applicant as String 
Dim Phone as String 


cells(1, 1) = Applicant 

cells(1, 2) = Phone

I know thats wrong.

I want to assign a value from a particular cell to "applicant" and another to "phone" so I can use them elsewhere in the code just by typing Applicant or Phone.

For example, on a VBA course I recently completed the teacher used this to compine the values of both cells into one cell, as well as adding other text information to the cell at the same time.

Thanks,

Paul.

 

[Jonmo1]

Dim Applicant, Phone as Range

Set Applicant = Cells(1, 1)
Set Phone = cells(1, 2)

 

[Barbarte]

Thanks!

That's great.
got it all working now.