Search results for query: *

When I realized that ActiveSheet.UsedRange.Select was also including those exteraneous cells, I did some searching and ended up using DRJ's code at VBAExpress. Option Explicit Public Function RealUsedRange() As Range Dim FirstRow As Long Dim LastRow As Long...

I REALLY wish that worked...it would have saved me a ton of time trying to find a work around. I'm setting a Print Area because apparently if a student has inadvertently changed the contents or formatting of a cell outside the actual used range (which does happen a lot) then those corresponding...

Sorry, I don't think I've clearly stated that I'm talking about an embedded chart - not one on a separate worksheet. I'm working with a variety of assignments which have embedded charts and a variable amount of data. That's why I'm setting the print area to the range of used cells - but I...

I'm trying to make printing a spreadsheet, with or without charts, take as little time as possible by automating and standardizing student work files, as much as is possible via a simple keypress (macro assigned to a key). So I need to read the location of the chart and make sure that my...

In Excel XP, I've got a macro running to: 1) switch to/from forumla view 2) autofit columns and rows in the used area 3) reset page breaks 4) set the print area and force fit to one landscaped page It works great, except for leaving charts off of the print area. I need to figure out what...