active sheet code

Hi All, This is my current code to activate sheet based on the value in B6 than perform filtering and sorting. Private Sub Workbook_Open() Dim mainwb As Workbook Set mainwb = ActiveWorkbook mainwb.Sheets("AMSI-R-102 Job Request Register").Activate mainwb.Sheets(Range("B6").Value).Activate...

I am very new to VBA and am having a hard time understanding how the loop feature is working in relation to only charts on the current sheet. I can change an "active chart" with a VBA but need to loop it through all charts on the current sheet. I have been trying to understand it for 2 days of...

Hello. I have a problem with code which runs periodically (every 30 seconds). Basically, the code compares data from two Sheets (at the same Workbook) and then paste data (under certain conditions) from Sheet4 to Sheet1. However, when I open some other Workbook (window on that "other"...

I hope someone can help me. I need a code that will allow me to move data from a worksheet to a worksheet from which I came from. e.g. worksheet "Sheet 6" opens "Sheet 10", then after filling data in "Sheet 10" I need to move this data back to "Sheet 6" in the cells in range "F12 to F56". Please...

I am working on a workload tracking workbook for summarizing employee hours on key projects. The workbook contains multiple worksheets for reporting as well as individual employee worksheets for tracking. Each employee worksheet has an identical structure but the number of worksheets will vary...

How could I have this code referred to the active sheet not the ("Analyzer - Calculator)? Sub Convert_Data_2003() ' ' Convert_Data_2003 Macro ' Dim my_range As Range With Worksheets("Analyzer - Calculator") Set my_range = .Range("G5:G10000")...