ExcelBanter - View Single Post

On 17 Jul 2005 21:36:28 -0700, wrote:
I'm running some code that declares rCell as a Range and steps through
a sheet using
For Each rCell in ActiveSheet.UsedRange

I encountered runtime error 1004, Unable to set HorizontalAlignment
property of the Range class.

Any thoughts as to why this is happening? Thanks!

I'm going to take a blind stab, solely because I'm too tired to go
write the code to check it..

Is it possible you need to select a cell or a range prior to using
that?

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner