sheet activate

Hi - I have a sheet in my workbook that is only a couple of buttons for macros for the user. Each button is supposed to print a different sheet. Problem is that both buttons only seem to run the same macro. Here are some screen shots of the situation: (thank you! thank you!!) THE BUTTON...

I keep getting this error, but only when I'm on a page other than the page of the range object i'm setting. Option Explicit Public Sub LoadRecord() Dim Sheet3 As Worksheet Dim Sheet10 As Worksheet Dim SettingsCol As Long Dim FinalCol As Long Dim QuoteIDVal As Long Dim...

Hi guys, I have not posted recently or worked with VBA in some time and am now trying to write this VBA program to transfer a copy of the same profile limits from a static file ("Profile" file) to a series of result files (listed as Gen5 Result files or Destination). I wrote this code but it...

Hi, I run this script with a button within a worksheet: Sub updatepersonnellist() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Sheets("Resurstid").Visible = True Sheets("Resurstid").Select...