lumns("K:L").AutoFit
> 'Columns("P").ColumnWidth = 20
> 'Columns("O:O").HorizontalAlignment = xlCenter
> 'Range("N2:N" & lr).Style = "Currency"
>
> Application.ScreenUpdating = True
> End Sub
>
Hi, I'm using Excel 2010 and am darn close to finishing a pretty cool
spreadsheet I built with the exception of one problem I can't seem to
solve. I a VBAS sub() that takes n pairs of two variables (n is
usually < 50). The pairs are always made up of one integer and one
string. For example, a pair
Hey everybody,
I'm hoping for some help with the following. I have an Excel file that
has about 20 sheets and nearly every single one contains a pivot table
that pulls data from an external Access database. The pivot tables
then feed reports that are on the same page as each pivot table is.
In my
