setting

I'm using the following code to provide the user with a Print Preview/Print Settings page: Private Sub PrintPage1Button() 'Set up Print Preview With ActiveSheet.PageSetup .PrintArea = "B1:T56" .Orientation = xlLandscape .LeftMargin = Application.CentimetersToPoints(0.5)...

Can anyone give e the syntax of how I'd create a variant array without setting the dimensions beforehand or using a range on a sheet At the moment I basically Dim unclosed_liabilities_array As Variant then set the array by finding the last row and selecting an empty space on the sheet...

Hello, I have been trying to locate a quick fix but can't remember where I had seen it. Something about my excel workbook not having the correct format in the setting or something like that. I am using the cloud version of Excel. Thanks in advance for your assistance and time.

I have the following to set "shadow" to false but don't know how to do the same for the "relative to size" setting to true. Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Shadow.Visible = msoFalse Next cmt End...

If in a single session of Excel, I have two workbooks and in workbook 1 I set ScreenUpdating and EnableEvents to be False, then close it, are the states for workbook2 still set to False? I'd like to test it but I have found that despite setting ScreenUpdating to False, when I check it in the...

Hi, I have a programmable keyboard and currently have a copy and paste button assigned. I am trying to make my paste button default to paste special. Is there a setting or something like that to set in Excel?

Hi I am making a spreadsheet form for some of our guys to use. This spreadsheet will be used on numerous computers with different regional formats. I am trying to make the data entry into some cells be "dd/mm/yy hh:mm" and it will display "dd/mmm/yy hh:mm". This works fine if the computer's...

EDIT: Resolved - Disabled Trusted Documents So... I've coded myself into a corner. Upon opening my file, I have a userform that pops up requiring the user to make a selection before they can proceed to the excel file. I accidentally disabled the button that would close the userform and allow...

I'm getting a "Subscript out of range" error when trying to set MonthlySells - why is that? The tabs exist in the workbooks so that can't be the reason. Dim SCSAttribution As Workbook Set SCSAttribution = Workbooks("SCS Attribution") Dim AXATransactions As Workbook Set AXATransactions =...