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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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

G
  • Question Question
Improve calculation speed for this worksheet with INDIRECT/FILTER functions
Replies
0
Views
375
GeneBF
G
N
  • Solved
Excel 2016 VBA - Pull data from multiple sheets to One with specificities
Replies
3
Views
301
mumps
mumps
Skrej
  • Solved
Modifying formula to include more options
2
Replies
14
Views
519
hagia_sofia
hagia_sofia
excelbytes
  • Solved
AGGREGATE Function With Errors
Replies
9
Views
127
Peter_SSs
Peter_SSs
K
  • Solved
Code to search job id from multiple sources and update main spreadsheet.
2
Replies
10
Views
642
mumps
mumps

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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