Thanks very much Nitro and itpeter_y,

Ok here is the explanation again,
I wanted to fill a comboBox with Names of Addresses (sort of abbreviations) and then if I click on one, it writes the complete address into a predefined field. The application is a form where multiple addresses are used. I needed the answer to the first question above to do this. Now however I have spent a pretty good time, kept reading around on this board and finally came to a conlusion that works.

Right now I have two sheets in one file. The first sheet (called 'Form')is the actual form with the comboBox. The comboBox contains a link to the abbreviated addresses on the 2nd sheet (called Addresses). When I click on a name it pulls up the corresponding address from that second sheet and places it in a defined location on the form.

So basically I am putting the information into a string that is being placed into the fields on the other sheet. And the answer to my original question would be: Range("A" & 1).Value=...
A and 1 being interchangeable.

Here is the code:

Sub DropDown3_Change()
Dim attn_address As String
Dim street_address As String
Dim city_address As String
Dim state_address As String
Dim zip_address As String
Dim address_select As Integer
Sheets("Addresses").Select
address_select = Range("C" & 1).Value + 1
attn_address = Range("D" & address_select).Value
street_address = Range("E" & address_select).Value
city_address = Range("F" & address_select).Value
state_address = Range("G" & address_select).Value
zip_address = Range("H" & address_select).Value
Sheets("Form").Select
Range("I" & 4).Value = attn_address
Range("I" & 5).Value = street_address
Range("I" & 6).Value = city_address
Range("I" & 7).Value = state_address
Range("I" & 8).Value = zip_address
End Sub

address_select is the value for the 'cell link' variable in the comboBox.

I hope this helps other VB novices. Thank you all again for your help.

-PJ