Use memory variable in range selection 5 178 (11/19/2009 4:33:01 PM)
My range always starts at B12 but it varies in depth. After I find the bottom right I need to select to the top left x = ActiveCell.Address Range("b12":"x").Select I did this a couple of years ago ...
Utf

set pivottable source data to range name 0 262 (11/19/2009 4:26:16 PM)
I have a pivottable which i need to link to a range name set within a macro, i.e. macro runs, sets range variable, pivottable sourcedata equals this, refresh pivottable. what is the best way of doing thi...
Utf

can msoFileDialogFolderPicker display file names in the folder 3 905 (11/19/2009 3:58:11 PM)
I am using the following section of code to have a user select a location to save a newly created file (the name is already determined - newname) With Application.FileDialog(msoFileDialogFolderPicker) ...
Utf

Internet Time and Excel 1 419 (11/19/2009 7:01:02 AM)
Hello... Is there a way to execute the "Update Now" command that appears in the "Internet Time" tab of the Windows Time and Date Properties from VBA? Or maybe some suggestion to keep users of my program ...
Utf

Can I use a macro to create a macro in a new workbook? 2 143 (11/19/2009 2:27:44 PM)
I have a macro that splits data in a single worksheet into multiple workbooks based on a change of data in a particular row. Is there a way within this macro to make it create a script in the new workbook th...
DANMOO

Still need help on Macro 3 201 (11/19/2009 2:05:02 PM)
If you would look at my post down below, it's titled Need Macro Help please. ...
Utf

message box caption color 1 327 (11/19/2009 11:56:01 AM)
Is it possible to write code that sets the background color of the caption of a message box? ...
Utf

combining rows 5 125 (11/18/2009 3:16:03 PM)
I am loking for a macro that I can put in a command button that will look through a work sheet in column "A" for identical numerical values. once found take all rows with identical values and combine the ro...
Utf

Macro to pull every Nth row of data 5 609 (11/19/2009 1:43:02 PM)
I have a spreadsheet of data and I need to pull every 60th row out onto another sheet. Any simple macros? Thanks. ...
Utf

How to match debit and credit line item 1 472 (11/19/2009 1:24:24 PM)
Dear sir / Mam I need help form you how to matching debit an credit line itmes with help of macro we have thousand line items for example below. Once the line item will matched those line item will come in ...
Ponnambalam