I would like to trigger a calculation of the active worksheet when a specific
AutoFilter Field is selected and any criteria / item is filtered or reset to
AutoFilter All. Can anyone provide the relevant VBA code and advise where it
should be placed?

Is it possible to access any of the workbook properties using VBA?

I created a wscipt like this
...
Set objXL = WScript.CreateObject ("Excel.Application")
...

I wanted to produce a list/report from 4 other list on separate sheets
which contact a criteria, but not show list them if them do not meet
the criteria. E.g.:

Private Sub Worksheet_Change(ByVal Target As Range)
  On Error GoTo ws_exit:
  Application.EnableEvents = False
  If Not Intersect(Target, Me.Range("C1:C50")) Is Nothing Then

In Workbook_Open() I'm capturing a couple of global variable values:
the workbook's name, and it's full path.
Naturally, when code is interrupted, the globals go "Poof!".
This is expected.... but I'm unable to make  Workbook_Open a public

Is it possible to retrace the execution path in VBA environment?
Clara

hi,
i have the following:
Dim lastrecordAGING As Long
  Range("AE5000").End(xlUp).Offset(0, 0).Select

Could you tell what is the purpose of VBAProject protection? How can we use
this feature in our programming?
Clara

So I think I am stuck and need some help.
I have a list of numbers and want to duplicate a number every so many cells
keeping the duplicate in the list. I have figured out how to insert 2 blank
lines every 20 cells but now need to copy the cell after the blank cells and

Hello, I'm having a little difficulty understanding why the following isn't
working
I have two page breaks on a Sheet that i've added to test this out.
All I want to do at the moment is just make sure that it's finding the page

I need to replace a string in a range of cells. I use a syntax below. The
purpose is to replace a string in a formula by the new one and add a new item.
Formula in Excel Workbook:
=================

I am struggling with the problem that MS changed the txt import
procedure in Excel. We open txt files in Excel automatically from our
ERP system. The ERP system creates a txt file (in this file all dates
are fine), than Excel starts and through VBA the txt file is opened

Dear Friends
Please tel me how to save copy of excel file through vba code (Modules if
any the files must be removed while saving the file)
Please guide

I have written a very short piece of code which only works when the correct
sheet is selected:
FinalRow = Worksheets("WeeklySummary").Range("B65536").End(xlUp).Row
Worksheets("WeeklySummary").Range("B" & FinalRow & ":z" & FinalRow -