drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 527
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!
I have 2 Tabs/Sheets.
I both Tabs the row width and Height is the same 'anyway this should not matter
I am tryng ot get a photo for Sheet(2).Range("B2:AO23")
I do not want/actually I can't use simple formulas in Sheet(1) because the Range Sheet(2).Range("B2:AO23") shows inside other pictures/Images
when I use, the Photo in Sheet(1) containing the range say :
"Picture 1" =Sheet2!B2:AO23
My picture does not show the same cells I have in Sheet(2).Range("B2:AO23")
and when I use:
"Picture 1" =Sheet2!$B$2:$AX$30
my "Picture 1" shows 94% of the range: Sheet(2).Range("B2:AO23")
but if I put:
"Picture 1" =Sheet2!$B$2:$AY$30
my "Picture 1" shows many more rows and columns than the range: Sheet(2).Range("B2:AO23")
So looks like I am missing something to get the picture based on the linked formula.
What am I doing wrong ?
I have been been playing with the Lock, Lock aspect ratio etc... with no luck
I have 2 Tabs/Sheets.
I both Tabs the row width and Height is the same 'anyway this should not matter
I am tryng ot get a photo for Sheet(2).Range("B2:AO23")
and have it in Sheet(1).range("C3:W11")
I do not want/actually I can't use simple formulas in Sheet(1) because the Range Sheet(2).Range("B2:AO23") shows inside other pictures/Images
when I use, the Photo in Sheet(1) containing the range say :
"Picture 1" =Sheet2!B2:AO23
My picture does not show the same cells I have in Sheet(2).Range("B2:AO23")
and when I use:
"Picture 1" =Sheet2!$B$2:$AX$30
my "Picture 1" shows 94% of the range: Sheet(2).Range("B2:AO23")
but if I put:
"Picture 1" =Sheet2!$B$2:$AY$30
my "Picture 1" shows many more rows and columns than the range: Sheet(2).Range("B2:AO23")
Shows 9 more columns
So looks like I am missing something to get the picture based on the linked formula.
What am I doing wrong ?
I have been been playing with the Lock, Lock aspect ratio etc... with no luck