assigning a value for a variable for the entire worksheet

**abdulla saeed** · 01-09-2011, 10:00 AM

for example i want to assign value "1" for letter "A".

**davesexcel** · 01-09-2011, 10:05 AM

May need more details but try this

Please Login or Register  to view this content.

**Richard Buttrey** · 01-09-2011, 10:09 AM

Hi,

Are you referring to a VBA variable or an Excel Application variable?

If the former then just Dim an 'A' variable and set it to '1'.

Otherwise create a range name called 'A' and in the 'refers to' box enter '=1'
Now you can use '=A' anywhere in your sheet or formulae and return the value 1

Rgds

**abdulla saeed** · 01-09-2011, 10:17 AM

what i want is to assign a value for A for example. And use the count function to add the repeated As from that worksheet in another cell

**davesexcel** · 01-09-2011, 10:23 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Keep it simple...
Doing this will ensure you get the result you need!