How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If …

VBA will allow you to adhoc use variables, but its difficult to maintain if you do that. Add to the beginning of your code, right after version dim URL as string dim objHTTP as object

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as …

Since most of the contents are repetitive in that file, only the hex values are changing, I want to make it a tool generated file. I want to write the c codes which are going to be printed in that …

How do I declare a global variable in VBA? Asked 15 years, 7 months ago Modified 4 years, 3 months ago Viewed 1.2m times

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs …

See my solution based on UsedRange and VBA arrays to find the last cell with data in the given column -- it handles hidden rows, filters, blanks, does not modify the Find defaults and is quite …

Sub test() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Sheet1") Dim k As Long k = sh.Range("A1", sh.Range("A1").End(xlDown)).Rows.Count End Sub What happens is this: We …

Looks like you might have an issue supplying a name to the table that is a fixed value. You are calling it PivotTable6 but that name is only available the first time you create the pivot. After …

54 I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I …