Use memory variable in range selection5178 (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
I did this a couple of years ago ... Utf
set pivottable source data to range name0262 (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,
what is the best way of doing thi... Utf
Internet Time and Excel1419 (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?2143 (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 Macro3201 (11/19/2009 2:05:02 PM) If you would look at my post down below, it's titled Need Macro Help please.
message box caption color1327 (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?
combining rows5125 (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 data5609 (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?
How to match debit and credit line item1472 (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