Bad Syntax

jim may

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,486
Is the following fixable?

=OFFSET(INDIRECT(" ' "&My Main&" '!"&"$A$2"),0,0,COUNTA(Main!$A:$A)-1,1)
 
Last edited:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
I've since modified to: (This is being entered into the RefersTo Box of the RangeName Define window)

=OFFSET(INDIRECT(" ' "&Main&" '!"&"$A$2"),0,0,COUNTA(INDIRECT(" ' "&Main&" '!"&$A:$A))-1,1)

Still -- "No Cigar" !!!
 
Last edited:
Upvote 0
What is Main? The name of a sheet or a defined name containing the name of the sheet?
 
Upvote 0
Thanks -- I see the confusion.. Sorry.. my Second post should have referred to My Main (the name of my Sheet).
 
Last edited:
Upvote 0
Can't see why you're using INDIRECT then, but:

=OFFSET(INDIRECT("'My Main'!$A$2"),0,0,COUNTA(INDIRECT("'My Main'!$A:$A"))-1,1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

Skrej
  • Solved
Modifying formula to include more options
2
Replies
14
Views
404
hagia_sofia
hagia_sofia
K
  • Solved
Code to search job id from multiple sources and update main spreadsheet.
2
Replies
10
Views
501
mumps
mumps
P
  • Question
Runtime error 52 Bad file or number and syntax error
Replies
1
Views
149
rlv01
R
G
  • Question
Making transparent solid 3D model
Replies
0
Views
173
gifariz
G
T
  • Solved
Creating an Excel Rolling Chart
Replies
3
Views
368
GraH
GraH

Forum statistics

Threads
1,221,310
Messages
6,159,173
Members
451,543
Latest member
cesymcox

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top