Excel Programming [Archive] - Page 54

Step through a range?
chart name
Getting â€˜focusâ€™ back to Excel using Sendkeys statements
Transpose macro
excel graphics
Re: Hide Folder Macro
how to remove cached results in excel
Creating a Table within a UserForm
Reading current opened Excel book(file) into streams
spreadsheet control
How can I make Excel give me a warning message?
Background refresh not working
Calling Subs in other WB
select a cell with specific value
IRR DLL
stock returns/average/formatting
Can we disable main Office button in Excel 2007
How to disable the insert worksheet(Shift+F11) icon in 2007 using
Get Button Info/Location in when its clicked and pass to macro
Get Button Info/Location in when its clicked and pass to macro
Pivot table field list sorting
Hyperlink is staying with cell when data is moved
Programmatically insert a graphic?
Add color variable to bubble charts
add a timer to my template
Craeting a relatively complex macro - need help - looping
Opening Access Only Question
Column/Row Indicator
Can't delete forms using code
Saving One Sheet as One Workbook
Finding text in a selection
Google Getting Flaky?
define names in excel
User Defined Array Function
VB code for following lookup, thanks
Compile error: Method or data member not found
I've misplaced a macro <g>!
How do I display the ASCII code of a key
Re: Please help...formula problems
To the demigods of SUMPRODUCT, HEAR ME!
Turning on TrackChanges in Excel 2003 from c#?
MaxVal InCol "or" Compare Cells InCol Highlight Max
Excel Programming/Visual Basic Training Course
ComboBoxes in VBA
Is this possible?
Pro grammatically Inserting data to Excel Sheet
Running a macro based on cell value that is updated by formula
Why is this loop not working?
Cycle and Count
Columns(i).Hidden not changing
Splitting a cell in a macro?
select fields names with "dot"
Pivot Table problem with MissingItemList
Simple Macro?
access data from a closed wb protected with password without openi
Test a named cell in a macro
How to enable macros automatic?
PasteSpecial xlPasteFormats
Find char in string and mark
EXCEL 97: Can anyone check slow execution??
Sheet Change Event (Insert Row)
(repostex2) Code to refer to 6 pivot tables on same sheet
Control Excel from Word
Comparing Object References
Re: Opening & Reading file in notepad then pasting into excel using VB
A question about Trusted Publishers...
Can sounds be played when cell value changes?
RegExp - String in VBA
Remove space from text in cell
Re: Change Location of VBE References with VBA
for the change that change event cant detect
Programs hangs when deleting elements with ADO DB and Oracle
VBA Runtime error 14: Out of string space... help!
Userforms, selection based on sheet and password
Excel links
How to assign value back to a dropdown combo
Merged cells & column widths
sumIf
Help with Formula needed
Formatting cell backgrounds based on cell contains
Convert "" to real blank cell
Can you handle another SORT problem?
DataGrid Control OCX and other files?
Sheet Insert Row Event?
Digital Signature
Merging styles
Pop-Up Dialogue Box/check boxes/deleting worksheets
column offset problem
Invoice aging - custom function
Insert Excel Object in MS Word
Novice's Question re Chart Programming
Generating a new workbook from two separate but similar ones
?? Create a Public SUB with an array as parameter. ??
How to disable the "ESC feature" of a ComboBox?
Best Way to Share Custom Buttons?
Practice Math Problems
Copy Workbook
macro to divide by zero
TrackChanges differences between Excel 2003 and Excel 2003 SP2??
Expiration plus permanently activating by key
Calendar Control
Send data to a specific worksheet in a closed Workbook
James Latham or someone else who can help
Don't Replace existing Cell
If Statement help
Quick question
macro populated sheets is very good yet something i may miss here.
UserForm ComboBox
Range.Average Problem
Keep Text Together
Stop TextBox Clearing Cell
How to override a hyperlink
alpha character not populating in DBA table
Email Worksheets---Please HELP
How to call "Hide Comment" from VBA???
Need to create function to find first day of following month
Shortcuts for toolbar buttons/view code of toolbar buttons
Shortcuts for toolbar buttons/view code of toolbar buttons
Format Tel Number
Selecting Various Ranges
Formula Help
mismatch error
DateDiff ("m", StartDate,EndDate)
Autorecover
Finding the difference between 2 times
Best method for form distribution and data collection
excel tp pdf
combining operators
VB code to copy a row with absolute cell ref and also relative cel
Excel Macro to copy, paste and then update web queries
Text in Web query truncated due to < and % symbols
Macro runs slowly only on new laptop
Adding a value in the comment field (little red triangle)?
Error 6: Overflow 32767 Rows
String with Cell Reference
Attach reference/ library to file sent to users
hide rows with zero balance
Getting a the position of a single item in an array
Setting Range by calculation
Percenatge Format in TextBox
How do I activate the first worksheet?
information box
Conditional Formatting Strangeness
Select specific # of rows below selected cell - please help
Record user actions in VBA script
dynamic charts- Naming problem and ....
using macros to chart data
Copy Cell, Paste based on a match.
Calling a Sub in a Worksheet
Apostrophe problem
add "paste values" to right click menu
Button needed in worksheet to invoke word doc with linked values
Very Minor "Cosmetic" Question
OpenText method
Clearing listbox
Sorting Problem
Appropriate Object To Hold Memo-Sized Text?
Using VBScript to list all folders in a directory and files ...
(repost) Code to refer to 6 pivot tables on same sheet
Page Break: Format Row
Find function bypass
Adding References using VBA
.txt to .csv
Storing numbers in text fields
how to add Hyperlink in list box
how to add hyperlink in list box
Map drive to open a file with code
FileCopy Question
Problem updating nested IF statement results
Pivot table/summary for multiple sheets
Sorting Issues!
selecting a specific excel instance
generate Odd row numbers in VBA
Comment that won't go away
Add picture to Excel without using file system
Hidden File Extensions generating errors
VB code to set VBA References
Active x Initialise prompt
code to go down a column and find the last cell with data before an empty cell
Import data "Hangs", A "time out" is needed. Help! :)
variable declaration
Parse a date
How do I refer a macro on a new sheet i just created?
hide/unhide
Can I write a function like matrix function?
ComboBox RowSource
Need excel formula to calc time i.e.08:29:29am-23:21:32pm=9:07:57
retrieve a picture
writing in vba
Copy row/column size, print area...to other tabs
Run-time error 1004
To choose several sheets for synchronizing
WHAT COULD BE THE REASON FOR VB SCRIPT REGULAR EXPRESION TO WORK O
Print specific pages of a Database
internet connection via excel macro at timed intervels & save data to excel file.
Imbedded buton to run macro?
Can a variable be used when declaring an API call ?
Can't get save as to work
Can I evaluate a function parameter(string type) as VBA souce code
VBS/VBA difference
Automatic Solver
Pivot Chart VBA Reformat
Is it possible to put two different validations into one Cell or a workaround
Attach Macro to button?
Vba tips and help
WHILE AND FOR LOOPS
date stamp based on word input.
Date Format Thingymabob
Macro to delete rows with cells less than user-inputed time
Can't find project or library (Mid Function)
Run- time error 1004
linking buttons
find first empty cell in column and start transpose next row in that cell
Validation
different sheets (ledgers)
conditional query
CREATE AN EMPTY ROWS
Opening Access database
Special Control Needed - Please Advise
problem column (B)
¤p¤k¤kª±line line
SQL Insert Statement to return "13620 row(s) affected."
Rename worksheets of workbook - Error code
edit combo boxes
Column Width for Each Column
optimized way for copying formats and values
Blank Cell
QueryTable Null Import Quirk / Problem
rs.filter "Filter cannot be opened"
RefEdits
VariantType.Empty error
Combine two worksheets into PivotTable
Disconnected Range to Variant
first go around inputbox
(Tom?) Pivot tables, code to refer to all pivot tables on template
Keyboard shortcuts for COM Add-ins?
Data validation on multiple worksheets in the same workbook
can somebody pls. look @ this idea & tell me if it's possible?
adding cell comment via VBA (bold font?)
How to know get the color index for the conditional formatting?
how to perform regression in excel
VBA: cannot figure out code
ActiveX Control Return Keypress MsgBox Loop
adding RTF control to Excel 2003 forms?
Populating listbox with only one data
Retrieving Data From JET Back End
Code Works on Windows 2000 but not on XP
I want to Split & save the data in different workbook
Call user form from ThisWorkbook; close file if form closed
Is possible to automate Trust Acces to VBProjec Object option?
F9 breaks Shift-F9 for XLL functions
Possible to have only one value in a listbox
UDF returning a 2 dimentional array
HELP!!
Calculating Only Visiable Data
Help with Formula
Macro to activate cell
end if without block if
VBA Function running order
inputbox syntax location
Move form results to next blank row in diff worksheet
formula with two different variables
Importing Comments From MS Access DB: Cell, TextBox object, or something else?
Last column
How to check the existing of a printer?
Can Excel VBA search for and read URL
pop up box
Excel Automation Add-in #NAME workbook corruption
What is Enterfieldbehavior
Export rows to new sheet based on value from list of cells
countif/sumif question
Spell Check ignore repeats
formula needs modification
Detecting When User Deletes a Sheet
An error causeed by printing interrupted
Carriage Retunr in the Caption property of a CommandButton control
Re: Progress Bar - Help needed
InputBox: Separate CANCEL and 0
How to unprotect target xls-sheet in VBA using advanced filter?
Help with Formula
problem with VBA web query
Duplicate in A copy value in B (loop?)
Help with Formula
Class Module vs Normal Module
CodeModule not saved when created through automation.
multiple ledger
Loop to determine number of rows range
Alarm timer in Excel
how to get the first used cell position in VBA?
.RowSource by row range
Re: "compile error in hidden module"
Multiple web query
statusbar indicator for progress of macro running
opinion on code / formula reiult
Two CSV file data to new excel file
Problems with the IsNa Function in VB
Pivot table dialog boxes
Tracking Time of different city in comparision to Indian Standared Time
Tracking Time of different city in comparision to Indian Standared Time
Guidance on automating the creation of Excel files from Excel
Excel Macros with Forms
ribbon
Arabic Dates - special feature!
Comparing Columns of Text
Need Help with AutoFit and Blank(Null) Cells
script runs but doesn't delete
Changing path for import file
Plain English Please
why "..." would interpret as "?"
Need code or just guidance!!
how to interpret "ALL..." as text
PUBLIC APOLOGIES
Supressing the ctrl-c and other keys during word automation in automation
a column got changed and now the macro doesn't work
Supressing the ctrl-c and other keys during Word automation in aut
Determing if user input is on list in Combo Box
combo box help
add formula next to corresponding cells
Udf resets on 3rd workbook
2 Excel "truisms"
Changing the name of the workbook when sending it in email
Macros and Toolbar
Linking combo box and spread sheet
Automatic names in workbook
OnTime Application Newbie Question
Excel front-end and Access back-end?
pastespecial from excel to existing word doc
Insert Special Characters into Footer
Hiding Objects Along with Rows
Combobox showing spread sheet
Replace legend with Range of Cells
Hiding Blank Rows in a Range
multiple dates on calendar object
Loop worksheets workbook
R1C1 format and variable ranges
VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME
Importing external data
Yield function
not getting it in right place
Distributing Workbooks
Error Trying to add Calculated Items to a pivot table
names starting with !IDX
exporting from sql query results to a excel workbook
Big Array from several worksheets
Get range in list from combobox value
Emailing a worsheet from a button in Excel
error 424 runtime
Transpose to different sheet
Information Box
Import Data / Edit Data / Export Data in Excel
Can this function be made more efficient?
Go to last column
Working with PPT files through Excel VBA
landscape printing
Screentip in Worksheet User Defined Function
Information box
help with a range
Accessing Custom Doc Properties on Closed File
Reuse a script to change the range to rows 1 and 3 only
Help with a macro to gather information
Format page border on print
Interactions between Communicator and Excel causing Macros to stop
Hyperlinks property return a relative path ...
XL07 - How to conditionally determine Workbook file format compatibility in VBA?
VBA colorscale and color #
test
how to define a range
how to define a range
Mouse point
Transpose problem
how to define a range in VBA
how to define a range
Problems with MkDir
AutoFill question
Hope to stock data at every single update&all the sheets stocking synchronized
password problem
List folders but not sub folders
Create list of folders
Hope to stock data at every single update&all the sheets stocking synchronized
AutoFit Looks Terrible
Hope to stock data at every single update&all the sheets stocking synchronized
HOW CAN I UPDATE DATA OF SHEET1 TO SHEET2
Using custom properties
Import data from Outlook 2003 to Excel 2003
Current Time
Ignore formula
Empty/Delete Cells in a Column
apply Macro to all sheets in workbook - loop
How to Track Current Time of different GMT
Add subtotal formula to empty cells
Control search/replace dialog startup values
Tracking Time Zone
Getting VB List Box Selections to show in an excel spreadsheet cel
transpose skip 0's and blanks
How to get the path where a shortcut of an Excel sheet is located
Stupid Dancing Forms Controls
Help Importing using GetOpenFilename
while deleting rows it finds an error - error trapping
minimize workbook
How do I get solver to excute more than one time
only deletes first row with a blank cell in column "M" con't
minimize just opened workbook window
only deletes first row with a blank cell in column "M"
Pulling Data From PivotTable
Replacing Code with words using vlookup
Outlook/Excel return code to know if Sender pressed the SEND butto
script does not delete blank rows
conditional formatting
test
Naming Worksheets and Footers
Array with OR condition and multiple criteria tests
Sheet Tabs.
Pivot Table
I want to Protect VBA Code
How to conditionally determine Workbook save compatibility in VBA?
runtime 1004 error on deleting rows with blank cells
CAN ANYONE GIVE ME VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME??
VLOOKUP Woes
Autofill macro help!!
Listbox AddItem problem
Macro to autofill text help!
Data logging with a DDE link and VBA
Clear cell data using Combo Box
delete rows with null values in "M" column
Save As Part 2
macro print area
Sheet Tabs.
delete a cell with a null value in column n
replace method using ReplaceFormat .....
Determine qty charged per month
Help with Formula
Grab PivotField Data When Not in PivotTable
Formula Help
Changed Linked Cell
How to retrieve the activesheet of an Excel file using OleDbConnec
Getting the User Name
Statistical summary of bucketed data
Help setting PivotItems...
2-character limit on InputBox
VB Editor References
Creating a series from multiple columns and (multiple) files
UDF returning a 2 dimentional array
Corresponding Data From PivotTable Field List
slope function with matrix columns as arguments
UDF returning a 2 dimentional array
runtime error '1004' application or object defined error
Listbox
Error indexing worksheet
Deleting contents from merged cells from VBA
Flush Memory/Cache Clear:
Help with VBA
Help with VBA
Help with VBA
Double click item in Listbox to select item and close Listbox
getURL or open
Help with VBA
a range of cells to UserVal...
Activate a worksheet and paste / Import a code
Visual Basic code
Help with Drop-down control
Tough for me - Import 30 macros from one excel file to another in one step
Tough for me - Import 30 macros from one excel file to another in one step
Display 0 in the cells...
2 questions: Macro Mapping & Active Chart
Read Lotus mail from excel
Display 0 in the cells...
Go to a specific cell when selecting an entry in a validation list
Help creating a proper loop
Listen to "rename sheet" event in excel
TRANSPOSE WITHOUT ZEROES(0's)
Filling in Numbers on Forms
Need help with VB code to find certain values & select changing va
Summation of latest running 3 month total
Inserting Multiple Columns
How to call a soap web service in excel 2007
Problem with Web Query
VBA References
Hope to stock data at every single update&all the sheets stocking synchronized
Error message in Web Query written in VBA
style propertie causing excel not being released
refreshing web query
macro to check file open
Return Excel's current security setting
NEED VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME
Solution to your problems
Hope to stock data at every single update&all the sheets stocking synchronized
Hope to stock data at every single update&all the sheets stocking synchronized
userform textbox to variable
Fill function to next cells
PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
Create Sub Directories From Excel Column via Macro
Copy paste error
Display all items in outlook 2003 folder
pastespecial
force update/"refresh" of cell & workbook_open?
How to Disable Ctrl+Break?
Deleting Worksheets
From Office 2003 to Office 2007
Setting Windows Timers for a specific time
Cancel = True not turning edit feature off
Office Automation through C#.Net (with out save option, ctrl-s and mouse click disabled)
msgbox text vbyesno
Excel Data Import Question
Flush Memory/Cache Clear:
Spreadsheet getting corrupted
Moving Excel Chart to Powerpoint (getting runtime error 91)
copy sheet from Server URL
Click on a cell to get a check mark then...
Calculation based on entry into one of 2 cells
problems adding Rich Text Box control to a VBA form?
Flushing Memory/Cache Clear:
NEED VB TO REMOVE INITIALS FROM A NAME
NEED VB TO REMOVE INITIALS FROM A NAME
change contents of cell to another cell's value via macro or??
Macro to return averages within a column
Counta with VBA -
Changing Sheet Names
remove embedded images from a spreadsheet
Need Help with an Excel App to Submit information to a Webservice.
Web Query Without URL
create a macro to delete columns and then border remaining columns
subscript out of range error in Excel 2007 at Vista
Data validation on different sheets?
Reset Sheet name tracking number
refedit column
Refedits / Autotab
Userforms in Excel 2003
Userforms in Excel 2003
Compare sheets
Divide existing data in cell
Adjusting scale of an adjsuting chart
Before Save
Dynamic Ranges & Invisible Offset
Numeric TExt Into SQL Server
Flushing Memory/Cache Clear:
continous assessment help with vba
Selecting cells for a desired result
VBA help needed please
Concatenate question
Error Handle: File is already open.
Latest running 3 month total
DateAdd question
Errors 3705 and 3709...
How to listen to "rename sheet"
Best place to learn VB online
How to develop a "Shpping Cart"
Selecting ranges in macros
Editing Recorded Macros in Excel - VB
Grouping/Collapsing lines in VBA editor - xl2000
How to stop multiple refreshes on worksheet
Chart Titles - Thanks
Cell should show "0" as character....
Memory/Cache Clear:
Looking for Ideas - Page Breaks
Need help saving to multiple locations
Warning when saving in Excel 03 running on XP
e-mail macro
VBA question: Condense cell contents to first character
Syntax Problem
Linking custom toolbar to personal.xls
How2 automatic refresh advanced filter based on validation list?
A macro to change font size
Re: Disappearing data
Use a List to Generate Worksheets
jump into the loop
Macro fails to select pivotitems
Code snippets for custom menu
Macros stopped working
Macro keyboard shortcut problem
error handling question
Custom Software Development
Pivot Table Columns force visible
How to call out "other" open book
automatically change column references in formulas
Message box for overdue dates
Hide Sheets in the Work book....
Delete shapes, not buttons
Document Level Project in VSTO 2005 For Excel 2003
Open an excel-file from the web
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO
Embed image in excel
COUNT IF + using 2 sets of data
UserForm Pointers & Class Modules
PExcel AddIn hangs when trying to access data programatically
Escaping Quotes problem
Excel Form data to closed workbook
Check current location
Creating A Text File From Single Column Via Macro
xl2007 Application.FileSearch
Do we have time for yet another Sort problem?
create messagebox when a date is overdue
Big Idea lacking enough knowledge
Trend Analysis/coefficient of differentiation formula
Run a query with two tables connecting to two different ODBC
Delete break line between column A & B
Excel/VBA 2007 Problem
VBA to Copy Range
Scroll Bar/Chart links in Excel 2007
How to intercept each pressed key
How to get the current path
Summary Sheet
How to transfer a ListBox to a function
Double Lookup Without Exact Match-Price Breaks
Sort order via excel userform combobox
put a procedure into comments with code
Custom Position UserForm
Transpose cells skipping blanks
Bottom border for each row code not working
Merged Cells ' Range height
name_range auto filter
Excel 2007 referencing other wb
Using Find and FindNext to Format Cell Text
Userform picture
RowSource as a row
a macro...for a virgin sheet
Marco Help
macro Help
Programing a code
Help with summing.
Excel: Using Look up to return multiple corresponding values
Search for value move to next column code not working
Excel bug
Countif with parameters from another range?
multiple workbooks
Convert number to nearest multiple of Five
Delete from the bottom up
Control Q
Pop Calendar Fixed
Array with unknown elements(apologies if reposted)
Unknown element array
Macro to run based on drop down list
Complex Copy/Paste HELP....
Excel, WordPad and DDE
Complex Copy/Paste help
Extract all non-table data from Word
Import MS Access data into MS Excel using VBA...
How do you insert wingdings symbols using VBA macro?
Subtotal Macro Help
Sorting a data list with a variable
How to get the index in VBA of the selected item in a ListBox
VBA Question: IF value in M >0, set O="Delete"
short message box
Complex Copy/Paste help
Help or Information about Microsfot Excel Aplication Objet model
ADODB Create New Database from Excel
Excel does not execute a button's code when another macro simulates mouse movements & clicks
Copying Worksheets Question
ignore first 10 characters with find and replace
Formula Change
DisplayHeadings
Open WB
Is there a limit on the length of a PrintArea?
Lookup latest entry
GetOpenFilename in Windows Excel 97 bug?
Order of Add-Ins Loaded By Excel
Ideas for "linking" rows for printing.
Opening another workbook while current one is open
downloading query generated csv file
Copy and paste between sheets error
Create Pop Ups
Convert .CSV format to .XLS format in C#
microsoft map is no longer associated with microsoft excel
Writing code for Events in Class
String in a range
(auto)filter on row
Copy From One Column to Text File
NEED VB TO FILL A ROW WITH ABSOLUTE CELL REFERENCE
Visual basic code query
replace text string in cell automatically
URGENT: #REF! ERROR WHEN COPY AND PASTED
Better way than Nesting, or other solutions
"Getting Rid Of Save Prompt On Quit Command"
Edit Ribbon
Merging data
VBA in Excel for Pivot Table Selection (want to use a variable)
Set Source two Worksheets
Error When using ActiveWorkBook.SaveAs and EnableEvents in same macro
Find and Format code doesn't work
Cross-sheet hyperlinking, data insert,lookup
#REF! ERROR IN EXCEL97 WHEN TRIED TO COPY AND PASTE A RANGE
Pop Up Excel Calendar VBA CODE
RE: Searching into Non-Contiguous ranges in a columns
Re: Searching into Non-Contiguous ranges in a columns
Select Case syntax
Add text change row colour
copying hyperlinks to another sheet
Re: Data Validation Failure Excel 2007
Color
Color
Changed module names don't register in toolbar links
red "X" disable
workbook open event
Highlight Highest number
Extreme opening time of workbook (15 minutes)
How to disable cell entry ?
disable the red "x" @ top right coner
Select and Save as
Page break Page number
Open workbook with the same sheet every time
Help Required
pasting values only
file edit view insert etc disable
populate listbox as textbox changes question
Need help with recorded macro
Change pivot source w/o refresh? Can't change original/copied pivo
Maximized or minimize
Delete macros
Set bk = Workbooks(...)
select case error
counting with multiple conditions
2007: CheckCompatibility not honored
Copying data with a macro using autofilter
Userform causes Excel to crash
Decrease an array?
seperate field criteria to diffrent worsheets or files
Sub to copy only result lines within formula range, omit null string lines
Add Code to File Opening Q
Print Excel worksheet several times, looping value of 1 cell
"compile error in hidden module"
cell lock
Error When using ActiveWorkBook.SaveAs in Excel
How to store Range for "home-made" Undo Function?
workbook protect
Shell and Process.Start do not work
Activate and Select range/worksheet
regular expression parse string Perl $1 VBScript.RegExp
how to assign external icon for a ready saved macro
Obi Wan Kenobi: You're My Only...HELP!!!!!!
Finding the last value entered for an entity
data validation and named range
Truncating values of each sale in the range
Copy cell to another that is blank
How can I use VBA to set the value of an ActiveX ComboBox
Remove Duplicates Based on more than one column
Linest, Pivot Tables, and VBA
Numeric formatting: decimals and no decimals
How do I count the last six non blank cells?
Why does this happen same code different results
Pivot Grouping
Pivot Table Dates Grouping Issue with Olap Cube
How to call a private sub() in another module
VBA determine download URL
AutoFilter on a protected worksheet
using variables with Find
remove non-numeric characters from cells
Reading Access Form Field and Copy to Excel Field
Email from vba
How can you log users' interactions with MS Office applications?
plus 1
Sub () that does NOT appear in Macro selection
Creating an array
Custom Fields with spaces
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column
Refence a global in a another VBA Project
Problem With Auto_Close and QUIT() Function - XLM4 Macros
on closing excel enter password problem
Chart titles
Chart zooming
writing to text file
Toggle Switch
Can you make it so you choose more than one item from a drop down
Filling a Combobox 10 th column
(reposte X 3) Anyone???? Have I stumped the Excel community?
Need help with a vb function
object variable not set with commandbars
Please could anybody help with a file
Last numeric cell
Stupid question
Using two object variables
Formula in code
Find #Ref! and replace
adding custom images to a button on custom toolbar
Listbox on Excel Userform
form separator
Problem with function WorkBook.ChangeLink
Detect if workbook is readonly
copying cells
Dates in Pivottables
Returning full contents of an array to excel
BIG FILE : 40mb to 95mb
Array retained in memory despite procedure execution ended
Position of selected rows
How to make a cell blinking by conditional formatting?
read the values from a excel row
CountIF = function not defined ???
Combobox listing display
create array
Sum a column using fixed start cell and variable end cell
check.offset
defining Grouping
Conditional Formatting VBA
How do I get Excel to give me a warning, if a given cell contains a given number?
initialization of an array????
Can't link from Access to Excel worksheet
break?
How to copy rows from 1 workbook to another workbook
Spell check button on a protected excel doc
Capturing "Define Name
Capturing Define Names
Magnify contents of cell when mousing over - is this possible?
Dim & Copy & Paste
Ron on email code
Macro that will extract information from database into excel form?
Clear/Create Subtotals Macro
2007 Macro issue
delete duplicate rows, keep latest date and time group
Excel VBA error - Select method of Range class failed
Help with, Select then Save as
total hours worked for salary timesheet
Copying Range Just To Get Formatting?
Moving multiple entries to one row?
Macro to Save to Sharepoint
(repostX2) Pivot table: Grouping first row field by fifth row fiel
copy from dbf and paste to xls
Page Break????????
Excel 2007 Formula help
How to Active Window
Conditional Format in Pivot Tables
Download multiple html files and save as txt
SUM() Problem
SQL Server login in Excel 2007
Check if file exists...
Name Connvention in Excel VBA
How to test if a cell is empty in a custom function?
Chr and Chr$
Check whether text in a cell contains a string
array question, referenceing
ExportAsFixedFormat Options
Paste "text" value on one cell by macro...
Auto run Macro when file is replaced daily?
Auto run Macro when file is replaced daily?
Find Number of Weeks in a Month
Dialogs
AYNI HÃœCREYE BÄ°RDEN FAZLA FORMÃ–L GÄ°RÄ°LEBÄ°LÄ°RMÄ°
how to save an image as a bitmap
filling cells via Macro with a Vlookupfunction
SOAP Error in webservice ( Connector:Bad Certificate)
excel macro excecution from command line via bat file?
Chart .Location failures
Macro error when file not found
Setting Top and Left of Modal UserForm
Cross referencing pulldowns
insert method of Character class failure (error 1004)
Setting Top and Left of Modal UserForm
Test for existance of data validation
filtering with combo boxes
Operning Intranet page
Green screen scrape
Advice needed re:data linkage between separate workbooks
Offset Range Naming
lookup value in column
Replacing a date in date format.
List Box Macro
Help using With statement to move command buttons
List Box Macro
Help! Subtotal using formulas or VBA
doubleclick mrehod
Delete Worksheets in same excel
senkey - double click
help with script for internet download
It works .... but only 1 time
Macro-Security level value
Time Aggregate in [h]:mm:ss format in a loop & julian date
Registrating data on a sheet without activating it
Get data from Lotus Note Database.
Select Case
User Defined function to format
Compare Data between 2 columns, Excel 2000 & 2003
Multi-Language Issue - TEXT function
Using PivotSelect method to find the top of a range
Turn on Track Changes in Excel from C#
vlookup in reverse search direction
SQL - Insert from Excel HELP!
Colums/Rows different Pixels from one monitor to another - Excel 2
How can a VB function determine the cell within which it is runnin
Maco to copy data from wks to wks
ActiveCell.Row noncontiguous
absolute relative reference
Setting Source Data for Chart Ranges in VB
simple command button question
Access to Chart Trendline Equations in VB
How do I set option button value using VBA
Command Button
Application.CutCopyMode
Alarm Timer
More on 2.5 StdDevs
Concatenation prob
Progress bar/meter for duration of code - No loop
Newbie needs translation of Andy Pope's code
Value in Drop down list disappears
How can I get Excel to prevent me from making mistakes, when choosing from a list?
How to extract data from autofiltered worksheet
Add information to a cell with Data
Returning arrays
(Repost) - Pivot table: Grouping first row field by fifth row fiel
Macro to insert sum calculation at every second blank cell for data above in column F
ActiveCell Value match with Cells in range problems
Disable Open/Save Dialog in IE Page using VBA
Run-time error 57121 & 32809, Excel 2003 SP2
email chart
Simulate left click...
Referencing Cells in a Selected Row
Formula question
How To Keep Worksheet_Change From Firing?
With End With question
Number Cells, Excel 2000 & 2003
Stop an excel file from being moved or copied - do I validate filepath?
Combo Box
Importing Excel Workbook into Access
Search marco to update a table
Formula to use in Macro
Simple SSN UDF
Changing work hour days from 16 to 24
Delete Row Help
Normal.dot
Desktop icons
VBE Security
Synchronize PivotTable Items
Macro - Copy row and paste on all tabs
vba in FrontPage
Saving a Macro
replacement for Application.FileSearch in 2007
Range with a variable
Pivot table: Grouping first row field by fifth row field
userform and VBA code
Subtotal Macro Through Numerous Tabs
Histogram and macro?
Pivot table: rouping first row fied
Cut Button Problem
Office Add-ins and threads
Simple Excel Question?
Progress Bar
Need help with Date formula....
Get Oracle client version
Re: Concatenation prob
changing time formula from 16 hour days to 24
Any way to reduce/combine in this code?
Check that all cells in a range have same values
Input Box selects a cell location to use in code
List AlternativeText names for every shape on a worksheet
choose range name according to cell
Internet data retrival
Timer to flash msg on a form
repeat row button
Saving Macros
Copy lines with specific value
find/replace macro
About my looping
My program read the wrong msgbox
Limit to # of cells using validation
Add separate values in a Column
block manual entry
Saving sheets as tab delimited text files
How to let the looping wait
Multiple Check Boxes calling same macro
Change variable value of -1 to 1
loading text file partially
SeriesCollection.(X)Values: locale settings specific?
Delete rows containing "ISA" in column A only, starting from row 6
Cancelling Application.OnTime - error message
delete from matrix
Macro to work list in filter and save (reposted from MPE misc)
run procedure when exit design mode
Cancelling Application.OnTime
Fill variable number of cells with a fixed text
Macro error I cant solve
ActiveFormula R1C1
Naming Ranges
Copy Worksheet to new Workbook and naming
Macro to select "last used column + 1"
Attaching files to emails using a wildcard
Macro to go back to last used sheet
Workbook Size
Use Pivot Table to Sum Most Items and Subtract Only a Few
Excel 2007 VBA How can I install my spreadsheet in a user director
Range("Reset Sheet!F13").Select Makes VBA Code Fail
Visual Studio / VSTO
Collapsing rows
System time to GMT
Populating a check sheet from a frequency table
Hyperlink to target
Hyperlink to target
Hyperlink to target
COUNTIF Query
Request for Help
How to display the active row number
simple excel process not killed
Removing dupes without selecting column
if statement conditions
The differents of the sheets name and caption.
accessing named range
changing paperbin /papertray in excel 2003
Row number of last cell with data
Adding a space within a cells value
Email a file as an attachment in Outlook 2000 using Excel VB macro
how to do other things while excel runs my simulation
Programming for multiple version of EXCEL
Unique values from list of many values (with duplicates)
How to find function set about text