#### kimberly99

##### New Member

- Joined
- Apr 18, 2006

- Messages
- 20

=COLUMNS($A1:C$1)

Cell A5 displays the number “3” as it should. I want to reference this formula in Sheet2 (you may ask why, the answer is I’ve simplified the actual task, so I only ask the root problem here). When I enter the formula:

=Sheet1!(COLUMNS($A1:C$1)) in any cell in Sheet2, instead of getting “3” I get error message “The formula you typed contains an error.”

What is my error?

Thanks,

Kim