excelstarter1
Board Regular
- Joined
- Jul 20, 2017
- Messages
- 81
Hey guys,
I got a tricky problem - well probably not for you, but for me![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a standard presentation design with standardized table size and graphes.
In order to check whether my Excel tables and graphs have the exact size for the presentation (so I dont need to resize/shrink them) I created a rectangle shape with VBA which has the exact size for the presentation. So I just move it over my table/graph an check whether it fits the standard or not. Currently the rectangle shape always starts in the top left corner of my worksheet (so basically A1). However when I move down several rows, I dont want the shape to be shown in cell A1 but, depending on where I am in the worksheet in cell F400 (top left corner).
Is there a way in VBA to create a shape always in the top left corner of my screen, so the shape can be created dynamically?
Thanks in advance!
I got a tricky problem - well probably not for you, but for me
I have a standard presentation design with standardized table size and graphes.
In order to check whether my Excel tables and graphs have the exact size for the presentation (so I dont need to resize/shrink them) I created a rectangle shape with VBA which has the exact size for the presentation. So I just move it over my table/graph an check whether it fits the standard or not. Currently the rectangle shape always starts in the top left corner of my worksheet (so basically A1). However when I move down several rows, I dont want the shape to be shown in cell A1 but, depending on where I am in the worksheet in cell F400 (top left corner).
Is there a way in VBA to create a shape always in the top left corner of my screen, so the shape can be created dynamically?
Thanks in advance!