bobkap
Active Member
- Joined
- Nov 22, 2009
- Messages
- 313
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I am trying to include a print area in a macro, BUT I want to use variables vs a fixed range. It cannot be that difficult, but I just cannot figure it out. If I use Range function with Cells it bombs out. I tried recording what I want to do, thinking I could edit it to do what I want, but that didn't work either.
Can someone please show me how to use variables when creating a print area?
Thanks.
Can someone please show me how to use variables when creating a print area?
Thanks.