Highlighted Cells Help

**Macdave_19** · 05-08-2009, 07:09 AM

Hi All,

when i highlight any number of cells what i want to be able to do is enter a character and for each cell within the selection that value is entered.

i know this is possible by pressing CTRL + ENTER but is there a way i can code it onto the sheets module?

any help is greatly appreciated

**Andy Pope** · 05-08-2009, 07:18 AM

this the sort of thing you mean

Please Login or Register  to view this content.

**Macdave_19** · 05-08-2009, 07:20 AM

Popester!!!

yep that's the stuff

nice one guv!

**Macdave_19** · 05-08-2009, 07:37 AM

Hi all,

if anyone intends to use this snipet then i'd advise adding an error trap like so

Please Login or Register  to view this content.

this just stops it debugging when you delete a selection

cheers

**Andy Pope** · 05-08-2009, 07:50 AM

I could not raise an error when deleting either the contents of a cell or the rows/columns.

Can you describe what you mean by delete?

**Macdave_19** · 05-08-2009, 11:16 AM

Hi Andy,

basically say i'd highlghted an area hit the B button then decided that it was another letter i'd wanted, in highlighting it again then deleting it would debug?

hope that's clear