Sheets("Results").Cells.Select ( Attention All MrExcel MVP's

[Elemental]

Sheets("Results").Cells.Select

is this code even valid ?

it says select method of Range CLass Failed,

even by typing

Sheets("Results").Select
Cells.Select

it fails on the cells.select

is there some problem with changing locations like that in VBA ?

thats what it outputs on a macro, but cant run in the VBA, and microsoft havnt done anything about it through all the versions of Excel, so what am i doing wrong by using the code it gives me from the macro recorder.

surely sombody has found a way around this, i could really use the help.

and it'd be great to know for other Excel users who may come across this error

thanks ppl.

 

[Elemental]

ooooh,

the activesheet is "Form", but

if i type

Sheets("Results").Select
Sheets("Results").Cells.Clear

then it doesnt complain

if im working with linked cells on "data", what do i change to paste just the values to the "Results" sheet ?



this looks great