vba question

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

I've attached an example of the file I'm working on. I would like to keep the data in a separate file. But, offset formulas don't work if the data source is not open on your computer. I'm using the offset formula because I need to use both Row and Column references to find the data I need in...

Hi, I wish to make a project activity and timesheet tracker. Where the analyst will provide information on hours spent on projects on daily basis. Form that information, I want to create a project activity tracker and also the information will give details on daily timehseet or productivity of...

Hello everyone, I have a workbook with a macro that runs automatically when the file is opened. It works great, except that the process takes quite some time due to the size of the file and the scripts it triggers. I have Windows Scheduler setup to open (thus run) the worksheet at a certain...

I am new to Visual Basic. I am, however, an old programmer. I have used RPG, Fortran, Pascal, Cobol... I have completed one project in VBA and am now tweaking that code for my next project which is very similar. I just need to know how names of persons are reflected in the code. I need to...

Hi, Have two Workbooks (1 Sheet in each) and was wondering whether the following is possible? Each 'workbook' has; Column 'A' - Unique employee pay number; (there may be more than one entry for the employee but column's 'x' and 'Y' are different in these cases Column 'X' has date; Column 'Y' has...

Hey, I’m having a little bit of difficultly with the following vba line. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> If ActiveCell.Offset(0, -8) = 3 And ActiveCell.Offset(1, -8).Value = 2 Then<o:p></o:p> <o:p> </o:p> Basically, when I...