I'm trying to add cell padding on the top and bottom of all cells in an Excel 2007 worksheet. I found a solution on Experts Exchange from Akoster, but it doesn't run for me:
Range([...]).RowHeight = Range([...]).RowHeight + 12
Range([...]).VerticalAlignment = xlCenter
The error is...Run-time error '1004'
Method 'Range' of object' _Global' failed.
What should I change?