Making a cell active.

I forgot to add that I am waiting for Vba for dummies to come in to the local library, and I would appreciate any help whatsoever.
Thx.
Pete.

Thx for ur answers. I get an error with the range statement whether it's integrated in a statement or in a single statement.
I have this code in the main menu on a button.
I am just figuring out how to upload the workbook.

Go to advance then attachment.

Thx for that.
I am using a combo box for the range to select, hit command button2 and trying to select whatever is in the combo box. I tried making 2 indexs to get R1C1 format into E1 on Infosht, but can't get that to work either.
Hopefully u will b able to get the general gist of what I am doing.
I have a few rem statements in command button 2 code which shows what I have tried.

@Norie, thx man that works
Now all I have to do is try to use a variable to select the range to be modified.
Thx for ur help guys, gonna add rep. to each, and if u can feel like helping further, would love ur input.
Solved, thx again,
Pete.

Yes it is, but I always kept getting an error in the range statement, so I thought I'd go back to square 1 to try and get any active cell to work. If I get that to work, then the next step is trying to use a variable.
I tried Columns A:A in the right syntax, and got an error on that?
The aim would be to get the value in E1 on Infosht as the active cell.

Pete.

Yes they are relevant to the dropdown boxes in QuoteSht. There are a lot of variables in there, and each range on infosht is specific to a dropdown box in quotesht.
If for example the cost of "Ally" in infosht, goes thru' the roof, the user needs to update the cost per tonne, to reflect in the final quote.
Also as costs go up say in manpower (not on sht, but in hourly rates), these may need to be amended.
Pete.