Excel Programming [Archive] - Page 27

Workbook_SheetActivate only works on some sheets
XL2007 Opening xlam from read only share
Check if mdb file is open
code for dynamic range
Charting data generagted by a Sub. Urgent please.
How to chart data generated in a macro in any desired sheet. Pleas
How to chart values generated in a macro in any desired sheet. Ple
Need Filtered Pick List
Using CDO to send emails with voting button's
Do not allow user to copy
xlFillFormats; Fill 9 Columns to the Right
xlFillFormat to Right
Variable available to all open xl files
How can I automatically import into next empty row
Word doc from Excel using a macro?
Help with names
Passing a named range to a function
linkedcell property
Horizontal Alignment
Selecting todays date
Checking cells for input
Runtime Error 6 - Overflow
Data collection from multiple excel spread sheets
AutoFill using a macro
looping thru named ranges
Dynamically Create excel file
Disable paste option in worksheet.
Code or Even ?
Autofil macro
Application.OnTime question
Combobox default text
Print a Single Hidden Worksheet?
print scaling
Excel 2003 - VBA File already opened
AutoShapes Disappear
Extracting numbers from a single sell
Formating lost when cut and insert
Excel on a Network
How do i find the text box number?
Hide unhide non-contiguous columns
Shared Workbook
Execute XL invisible
Invalid product key-code
Want to do sum by Acct Subacct
direct your sum in the right box?
Excel crash
Export GridView to Excel (xlsx, Excel 2007 Format)
Check 1 cells value and use the result to change another cells for
Delay when writing cell information to Excel from VBA Macro
Excel VBA Algorithm
Copy to a flash drive
Sort and match two columns without touching a third column...I'm anovice...
LATE FEE RECONCILIATION - HELP!!
help with a piece of code
Send Data to specific sheets based on value of one column
If Statments
Pause a loop after 100 cycles
Unique Dropdown menus
Subtotal row formula
build a list with timestamps
Copy cells from one sheet to another based on criteria
converting active x buttons to Excel 2007
Show Window Message with percent of work
Avoiding Compile Error for Unsupported Methods
Cost History by Customer & by Month. Extending existing code.
Select Activecell and 65 Rows to the Right
UserForm mechanics
Monthly maintenance reminder
Large discrepancies between Yield() and its equation in online help
Conditional Format Excel 2007
Object Formatting
Issue with arrays
Return Focus
I can not insert a Image in the Form
characters within a linked cell
"end sub" error
Ctrl+F Find by value
UDF-event mishap
copy and paste a row
Automated Transposition
VSTO - Excel Stored Procedures With Parameters
right click menu
Consolidating multiple workbooks into one?
Object refereence not set to an instance of an object
right hand mouse click options
Copy paste formulas when running multiple instances of excel
Old format or invalid type library
Using Excel in conjuction with MS Outlook
Cell off grid error after generating Excel spreadsheet as XML
Adding Time to a variable in Excel VBA
data with more than 65536 lines
Report of filter/autofilter criteria(s) applied
Macro to refresh pivot chart - URGENT PLEASE !!!! T_T
Marco to copy and paste column as well as edit link
Writing to the Registry
US - British Dates
Calling a VBA sub routine
cells content
Dropdown list instead of Inputbox
change filename
Hiding a column vs. Deleting a Column
"Soft Code" Find File Directory Or Alternative
Error if File Open
Userform and XL up function
Use Calendar to insert dates in a form
If True then DO, otherwise DON"T
IF then DO, otherwise DON"T
Traversing the collumn of the active cell
using vb to help with a complex web query
Formula to show =>500 but +<1000 in one column
Creating new directory and copying folder using Command Toolbox
pass text attributes
activecell.formulaR1C1 = "='i'!R10C6" 'i is a variable
Conditional formula if content is text
moving cells value and font only (no other formats i.e. boarders)
Adding tabs to my wesite publicationIn Office Ultimate 2007
Selection of range for the 'slope' function
Step to next row in a filtered sheet using form
Copy column(s) and insert Code
Import WILDCARD search to EXCEL from WORD
Copy the whole folder content to new location
all series on secondary axis
Protect a single worksheet?
InputBox using "Data Validation"
Hide "Opening" Window
Help, I posted a question on the 18th and am still needing a solut
Refreshing DecimalSeparator in Excel 2000
Peg a cell to an online value
magic cell
VBA help missing in Vista
Conditional Formatting
Using "case" code in Excel
Checkspelling with Autofilter
formating cells from IF statement
greater than and equal to formulas
Form Position Chip Pearson
Deleting rows following the max point
Find Variable
VB code
Data Manipulation
Generate list based on multiple criteria
Insert new colums after each one existing column
Trouble keeping the time format
For Each Subtotal/Bold, Add xlDouble
Print multiple sheets from checkboxes into one pdf
Launch external program - Compile error: Expected: list separator
Numbers and Letters
Excel 2003 Got Corrupted and would like to send a copy to MS.URGEN
Pivot Tables and Team Sites
Active Cell
Shape.ID is it unique - when is it set - when does it change
Move Column
Extract Date, and summarize data request
SpinButton Excel 2002 bug?
Error on CreateObject â€œExcel.Applicationâ€
Named Formula across multiple worksheets
Save as File Problem
How does Excel references a cell?
Simple Object-Type Q
Shared Workbook
NEED HELP!!!!
copy data when Autofilter On and active
Worksheets
Picture in UserForm
Minimize userform
How to write todays date in an autoexec function
Table Data Entry from Form
Multiply selected cell by a input form
Additional Controls
External data
VBA script question
Quick Debug Help
Format problem
Pivot Table VBA in Excel 2007
Name groups of .offset ranges
Copying numeric text with leading zeros
Web Query authentication
Invalid Procedure Call
How do I move to a specified row and insert a value?
VBA Variables as Strings
How to: User selected range?
run sub from hyperlink
Row Height -- Slows VBA
Urgent! Named range scope
Excel query error
Limit .find to one pass
Reference to dll object in VBA
Copy worksheet and change rangename
Hide rows depending on the date
Excel 2007 - Perplexing Undo VBA runtime error
Get file reference using File System Object
Worksheet that automatically hides removes certain column pasted i
Test if Column B is autofiltered
MACRO THAT CUT ROWS BETWEEN SHEETS AND ADD EMPTY ROWS
How to create a Range with Address()
Out of Scope Errors when exiting Excel
Macro help
Macro for multiple tasks
Refresh Pivot
problem while saving the file as .xslm format in excel 2007
Error on executing code "ExtractReps"
Workbooks, subscript out of range
Run-time error 1004 Method SaveAS of object _Workbook failed
Accessing an Excel database using Word
Removing The Quit/X Button On An Userform
Efficient Way of Copy/PasteSpecial of Non-Continuous Range in VBA
setting the source data for a chart in VBA
Selection.Sort Key1: Problem
ÈFÈUÈbÈqÈZ ÈUÈeÈeÈZÈhÈ^ÈhÈcÈqÈZ ÈYÈqÈfÈdÈmÈ`È^
match debits with credits
Hide worksheet tab
Open workbook with password
calculating balances
Cyclic Data Macro Q | Free Copy Macro
check if drive exists - if not prompt to SAVE AS box
pROGRAMMING A SPREADHSHEET
Sorry to rehash an old problem
Workbooks.OpenText Error 1004
VLOOKUP on external file
Office '03 macro not funtioning in '07
create button on the fly in worksheet
Wildcard in Excel for Mac to open ALL files
How to pick the first value in a filtered range - vb code pls
vba project still visible in vba-editor after closing workbook
Removing modules and forms
Using Worksheet Code Names
spreadsheet tab disappear
Renaming files consecutively with VBA
Export/Import in CSV
Macro for editing a series of cells
Automate GoalSeek
Intellisense not working
Color cell depending on it's previous value
Excel failed on second trip - Error: 1004
Assign Excel Menu to Shortcut Key
MAX of ABS of 2 values syntax
Macro Help
I have a fix already, but would like to use what I've created here
Blinking cell if value is...
Iterate combo box
Limit (not memory) consumed by Range Names, UDF calls, VB code, st
how to delete a row based on a condition
Cell value to replace hard code in Query
Hyperlink Back
Terminal Services - USB Memory Stick !!!!
error message
Very simple Advanced Filter not working in macro
Getting string from database table with VARCHAR(MAX) field
Using ADO to get the first 5 fields horizontaly
Czech Bitch
IF Statement
Validating an entry on a user form
Copy worksheet to another workbook
Query from Excel to Access - Passing Parameters?
Userform - Time input
Creating sheet and copying filtered rows in it
Populate Combo Box Drop Down with Collection Data
C#: XYScatter chart with smooth lines and no markers
Disabled macros
Assigning Variables To An array Throughout a loop
Mergining two pivot tables into one
Run an Excel code every 15 minutes of the clock
xlCellTypeBlanks, but no blank cells to delete
HOW CAN I DELETE A COLUMN BASED ON A CONDITION
Missing code in macro
SetFocus OLEobject by macro
Rounding, List, Compare, Match
user to select path
Hiding columns based on cell contents
Remove duplicat entry w/out deleting cell
Change background based on value in another column
Help with if and looping
Skip hidden lines?
Don - Please help on another subject - headers
Why doesn't the Control tab appear in the Format Control window?
sum last rows
Formatting Several Sheets
Couple of Macro Questions
formula for text
Open Crystal Reports from Excel?
How can I calculate peak minutes in Excel? (< 9:00 PM, weekdays)
Procedure works from VBA but not the Ribbon
Range to be copied changes
Contents of Formula Bar overflow cells
Getting the count from autofilter
Export only current sheet to email?
Creating macro to capture details from Lotus
Changing Cell Contents
ARRG! Names not showing up, can't use in validation or ListBox??!
Adding Items at runtime in the Ribbon ComboBox
Find cell - Copy & Paste
Comparing Text Contents of Cells
This request for the very experts. Please reply at the earliest
Problem with conditional hide/unhide row macro
Urgent
Open the SaveAs Dialogbox
Create sheet with records for each rep in filtered list
Need help with Names, please - must finish today!
Insert function dialog closes when I click a picture in Excel 2007
Data segregation..
Codes for Undoing
search a row for data then move to next row
determine when the user moves to a difference cell
POP up Box
Can Excel show OLE object created in DLL of VB6 ?
Cann't Copy codes from module
New Menu tab in Excel 2007
Vlookup - picking from a formula.
Summarizing from a pivot table
Pivot table resize
Autofill to last cell in other column
transposing multiple rows into one column
Formatting
formula works, functionworks, but not together
Collect Modules into one workbook
Excel 2003 VBProject Missing reference
Text to bold
PLEASEEEE HELP. DATE AND TIME PICKER CONTROL
Trouble with excel spreadsheet extending past the limit of a works
Collect Info from Wkbks in a Folder with Criteria to 1 sheet. CHAL
Copy/Select a Row
Run-time error â€˜1004â€™
Macro in Excel not updating spreadsheet
Choosing a cell with the greater number
Bolding a certain word throughout worksheet?
Disable Personal.XLSB
Can I filter for "number of characters in a cell"?
Newb needs help....PLEASE!!!
Use Offset in formula
Close workbook timer with notification
problem with date formula
Disable Command Bar Control
macro required..
Updatelinks
All I want is the text to fit in the cell
Call "Edit Links" and Wait
obtaining the collumn letter and row number separately
Macro Programming with Sorting
Add-In Calls Sub in Active Workbook
AND
Auto-adjust According to Resolution
Lock Button Position
Disabling Ribbon in '07
Error Changing Button Text
Select range of cells
XL2002 - Sheet event BEFORE deactivating.
Excel 2007 application
how can I change rows of data around by code ??
resorting columns
index vs vlookup
calling other events from an initial event
Why Compile error on Myarr()?
Array problem
Macro Programing for This Document Only
Advanced filter macro error
Further Help/Advice Required
Sumproduct puzzler
can I lookup two reference points ??
comparison of 2 approaches for identifying file existence
Command line utility for inserting data into Excel spreadsheet
Help ghosted?!?
Form Position
Macro to Automate Row Results.
String result in Font.Bold style (I need your help please..)
Excel DB Queries: passwords and connections
ActiveWindow Name
Window Selection based on name pattern
Run-time error 1004
summing in vba
DTPicker control CHALLENGE and (Sultion for WebBrowser without ScrollBar)
Macro help required !
Obtaining information about DLLs from VBA
Date formatting still causing me headaches
Code that Exits on certain Dates
How can I check to see if a sheet exists?
target value
Match 'unmatching' search term with cell values
BETAINV In VBA
Set a range on a variable sheet?
conditional formatting
Error 13 in 'WorkBooks.open'
Problems with scrrenupdating
Something similar to FIFO method
Multicopy worksheet
multiple validation
need help!!
Incorrect Function
COPY AND PROTECT
Excel on a web server
How to get evaluated value of worksheet names that do not refer to worksheet ranges?
Spreadsheet to PDF
How do I find out what cell reference was selected - not the value
Any way to call a worksheet method that may or may not exist?
Correct front end of dynamic range
Value of Cell that is selected to Copy or Cut
Paste Special prob
Get word from a string
Macro to only Cut and Paste
Import external data > New database quearry
I need help making the next step, please
Remove Copy Selection
AutoNumber
Re: Creating Range in VBA Code and using Pastespecial
Transfer Data from UserForm to Worksheet
this should work..
the rigt syntaz
Easy Macro help
Last record
Method "Method 'Open' of object 'Workbooks' failed
Update value only when ...
Lost focus for Cells?
Re: Setting axis labels
FileDialog mso folder Picker
DateTimePicker control problem
RE: Conditional Formatting Challenge
Sorting
RE: Hide Warnings on Save
code hangs up on standard formatting
Re: Reset the macro assigned to Ctrl+F on workbook deactivate
Advanced filter overrides cell formats in extract range
Date Range with User Form?
Re: Setting any negative number to zero
.PlotArea size changes when a series is added
Does a sheet exist
chart x axis labels show up as range
Please help for macro in Excel "2003"
Can't Save File
Change File Access Question
pictures in single cells - conflict with wrapping text
Resetting PivotFields
VBA to compare workbooks
getting vb module formulae to work in excel 2003
How To Check If The User Has Macros Enabled When The Workbook Opens
Userform - validation data. Please help needed
Can you query status of data connections?
Disable Command Bar Edit Control
Vaiable Help in VBA
Code Fails to open UserForm
RC4, Microsoft Strong Cryptographic Provider 128
Open my XL File with spacific computer !
A ROWS by any other name...
How to update all links before re-calculation for macro?
Simplify Code for Borders
Need better macro
Nothing Keyword Destories Objects rather than just resetting the variable to an empty variable
Match Columns and return value
Turn off menu function
Vartype() and vbObject
In VBA: how to open a workbook with a specific version of excel?
Rename Tabs By user Definition
Using Sumif In A Macro
Can I get a chart object (excel.ChartObject) from OLE_chart.object
setting advanced filter
Select last column
Code to launch VB editor
Master Spreadhseet retrieves data from children automatically
Error in my App??
referencing current range of cells selected
group option control
Macro for deleting non-printable characters from EXCEL
SQL ODBC Connection
Vertical Multiple Goal Seek
How can I make this Loop faster, screen updating is off
Error message on Opening
Paste object from sheet to catalogue (using VBA).
Hide range
Positioning drop down box over listbox entry
Paste to catalogue (using VBA)
Trying to freeze heading rows on a sheet
Code for OptionBox
Find method
Excel VB module initialization
Open Worddocument to mail merge from excel from command button click
Excel 07: unwanted info inserting itself into all Excel worksheets
ExecuteExcel4Macro to run on other page
Cell Date and Listbox Date formats
Where is User Defined FUnction
A dialog box to change Columns
Referencing range in another worksheet
Excel Profit & Loss
Find and Count Duplicate values
vbe - copy a cell's value by other workbook
Save filename plus last month's date
Userform freezes
Syntax problem fassing named range into function
Adding multiple tabs of same sheet, updateing summary
Application.Evaluate question
create multiple folders and name them by cells in a column excel vba
Re: Find the last Cell in a column in VB
Lock view
how to restrict users on what options they can choose?
=EMBED("Forms.CheckBox.1","")
How to test for valid 'Paste:=xlValues' before attempt.
Date and Time Picker
Conditional Format formula using VBA
Disable Data Connection
Application.Onkey for ^F not working
Help with Macro
Create Multipe folders and naming them by Cells in Columns using vba
Forms-Compile error: user-def type not defined
Compare and Highlight
Formula Problem in macro
using string functions within a range?
Change from a Command Button to a Form Button
Discontinuous Data Source for Chart?
Re: Unprotecting Several Sheets At Once
Conditional formating not working
Help writing macro
Select Union query in Excel
Coping whole row to new sheet
Lost partial contents in one cell when copy a sheet to other workb
DateSerial function
Vlookup help required
Pulling the last 6 characters out of the filename
Format Cells Dialog Box
Excel Lookup Question
Date Selector
Open Dialog Box Paste Special
Print Macro
Excel crashes
Auto_open inputbox before showing the sheets
need to delete files
Subtotals - add formula to blank cells
macros - any other way around xlstart folder?
Save Workbook As .xlsx to Remove Macros?
DTPicker Calander Popup
Parent property of custom class
Insert row with formulae without contents
MACRO TO HIDE BLANK ROWS
Mouse Move
Date Picker
WebBrowser Scroll
length of a string using inches to points help!
Text boxes in forms
Strange phenomenon
slow reading a file
Excel 2003 drawing Trend lines on a chart for a given set of point
slow reading a text file into excel
loading, but not activating userform
Retrieving email addresses from nt logins
MACRO of duplicate file
Automatic Password Protect Sheet
Help setting formula and values of a cell
Using values in Excel as parameters in Microsoft Query connection
Error In VBA
Function returns #Name?
Oracle BI ...
Right Click auto run macro
Volatile function & Filter Show All
Is this possible?
Add-ins
UserForms VBE and Class Modules...
Autofilter Row Count
Textbox added to Form at runtime is too small, can't control size andchange event won't trigger
Userform enter a field checking other two fields - Thank you
Userform enter a field checking other two in database
How do I hide rows based on spedific conditions? (VBA novice)
ActiveWindow.SelectedSheets.PrintOut - Print to single workbook
Minimize 2007 ribbon via VBA?
Check for Duplicates then Sum cells of duplicates
Macro question
I need a formula
Coping a whole row to another sheet
Make an Array 2-dimensional in VBA
Delete rows using VB
Insert Multiple Rows Trouble
Superscript a character in a string
How best to integrate/implement this?
Exporting Data to Word 2007 Using Reference to Word 11.0 Library
Validating values in textboxes
Looping with pdf-printing
excel regions
2007: Close to giving up !!!
fname = Dir() returns and 'invalid procedure call or argument'
Need help with a "If" "Else" VB code
Compatibility mode with XL 2007
pause
Add and Delete sheets
How to sort horizontally selected columns in Excel by values in 8
Failed to add footer one of work sheet, Thanks
Prompt for Save As Window through macro
What VBA learnign bokos would you recommend? (Available in the UK)
Advanced filter macro
Worksheet Sharing VBA
Sumif with multiple conditions
Duplicate records
Removing Weekends From a Formula...
Using ADODB Efficiently
Calling VB functions that are stored in an addin
Prevent Formulas from updating
Sending mail
detecting a proteced workbook
Invoice
Unexplainable Worksheet Function Calculation Process
Excel 2003 keeps crashing
Formatting problem
Formula Copying in workbook
HELP!! Macro Deletes Last Interval
error message for phantom chart with log scale
16.000 workbooks
Deleting rows
Feed List of Names into Ron de Bruin Code-Filter
Change pattern for individual data points on chart
Change syntax
Transpose in Reverse
Passing a control to a Sub
downloading a small database
Find duplicates, sum column then delete duplicates
shortcut keys
Author's Name
adding text boxes at runtime and setting autosize to True
Move to a named worksheet from any worksheet in the same workbook
Binding a DataSet to a ListObject
Help with Loopas
Userform - indication of activity
access controls on the spreasheet
Find Range Location of a Shape Object
Search and Replace a Spacific Character with Conditional Formating
Error with Borders of a Range
'SaveAs Filename' versus 'GetSaveAsFilename'
Setting formulas with R1C1 in VBA and eliminate $
Swapping data between columns
Condensing code
delete rows for values
Re: Combo Box or List Box
Re: Printing the contents on a named range in the Header of an Excel s
Printing the contents on a named range in the Header of an Excel s
Combo Box or List Box
Big Problem with Excel 2000 / 2003
retrieve data from MS Access
Selecting a worksheet based on the sheet Number
Opening a recommended read only file as non read only
using activeworkbook.worksheets
Intel Hex
Looping and passing variables to a macro etc.
Re: C# .net and Excel Named Ranges
How to display date list in a calendar view
XL Query Issue
C# .net and Excel Named Ranges
Macro to close embedded charts/resize in PowerPoint
proper
Passing IO.FileStream in Excel 2007
Sub or Function not defined
Convery to Number in VBA? How do you do that?
removing the file extention
Use a checkbox to change calculations
using command prompt & FTP
Graph to only include rows with data in
Workbook file name
exclusive macros
Insert Comment
Launching Outlook Calendar
Export Excel to XML and Date Format
Defined Names response
Excel as an database
Applying custom chart type
obtaining the format of text in acell
hyperlinks saving error in code
Add Current date and time when pressing a command button
OLE with Excel question.
Cell Position
Filter/Copy Unique records
toggling checkboxes
Transferring specific data
VBA Sum Product
Sum a column where the cells are based on calculation. HELP
Excel help - Find and copy files
trouble adding a name...
prevent users from adding sheets / charts
Passing a Variable to a Macro
Transfer data between 2 workbooks opened with IE
Deleting entire row
Adding a DLL to Excel (2003) Object Browser
Do NOT find in hidden rows?
fill in cell before printing / saving
Crystal Ball
Copy paste one excel workbook into another workbook
CopyFromRecordset fill back color
Program text in wordart
Count unique numbers multiple criteria
combine
Finding a specific cell value on different sheet
Defined a range
2003 VB Excel back to 2000 VB Excel
Prining with features (staples)
charts converted to pdf
Print Routine Needed
iif statements
RE: Selectively running macros on open
Data Validation
Drop Down List a la HTML
load data from MS Access
chart select causes error 1004
Autofill Dynamic Range
If Then VBA
excel query
AppActivate - Question for Chip Pearson
Compile Error: Expected Array
Invoicing Capability
A form combobox with list style as options.
chinese (UFT-8) in csv files created by a server
Read text file?
copy range code
If Empty run Macro
Worksheet calculate -question
Gridlines in listbox
delete columns based on value in one cell
Consolidate/ Clean-Up Some Code
Macro for wrapping text
Guidance, please (xl2007)
Moving rng of wrkshts to new workbook
Query Error
Compiler Error
Custom toolbars in templates
HOW TO ADD OR DELETE ROW AUTOMATICALLY
Looping
fill userform textbox from userform listbox clik event
Fix Comments
Very difficult mathematical-iteration problem for engineers!!!!!!
Macro call from another Macro
Current position on worksheet
Array of Collections
Save only edited sheet within a workbook (Excel 2003)?
How to get autoscroll in a multiline textbox?
removing any letter from string
Can you launch Macros from a customized Toolbar?
Move to next cell automatically after typing one digit
Register user on worbook open
Return to starting point
Macro for bolding and italicizing word strings
Count unique values in one column if values in corresponding columnare null?
disappearing formats in UserForms
Converting Consumer Reports rating symbols to numbers
three or more interconnected worksheets
Using DLL from C#
Converting Consumer Reports rating symbols to numbers
Help with Calculating Using Macro Pleaseeeeeeee
Compile Error: With From:= << Highlighted
Hide rows to create summary
Delete certain files in all subfolders of specified folder
Array formulas in named ranges
Copying Sheet1 to Sheet2 in a certain pattern
Extract Outlook mail using VBA from non default Inbox
xlConstants to numbers?
UK Excel User Group Conference
User Form
create worksheet with specific name
Refresh ColumnTotal
Filter The msoFileDialogOpen
worksheet-change event in combination with a select case statement
Override cell comment functionality
Trim Function
copy query table data
How do you find ClassTypes Info..?
List of Subroutines/functions in a workbook
Match several values in â€˜Summary Sheetâ€™ to several values in â€˜Mast
sort button
Data Error 9 Subprocedure Out of Range
C# Referencing of Office Libraries without Office installation
How attach an image and send mail.
Group Highlighting
Merging data from different workbooks
Caching a high and low value
Macro/coyy & Paste from a new data a fix infp
Date->Text Format
Macro/coyy & Paste from a new data a fix infp
rs.addnew - named range vs. individual cell
I want VB to select data automatically to the end of the row
during a loop
ControlTip Text
Sum Time when not posted as time
copy data of different range to other sheets
Pasting in an Excel Macro
Code not doing what I hoped for
Search and Match Values
Stop the loop after it runs for 10 times.
UserForm problem
Hide Pivottable GrandTotal using VB
Macro to launch the Activate dialog box?
Delete "count" of workbooks?
If -Then in VBA Code
Array formula[S] in named range[S]
Close all other open Workbooks
Mulitpages on Forms
Macro Skip the Constraint (Solver)
How to record macro using validated cells?
Macro cannot access hidden sheet
Help with code
How to verify if a range (or a cell) is contained in another range
Activate PowerPoint from Excel
Get VB object worksheetname
Repost: Excel 2007 and Declaring Variables
Excel 2007 and Declaring Variables
Solving Linear Programming
Event Driven Procedure
For...Next loop limits
Office Automation Problem
Excel application
transforming data into a single format/file
SUM Prices with variables.
Multi Line listbox
macro for different users... kind of
VBA to identify the name of a point
From Formula to Value
column adjustments
comments
Complex Question. Index/Match then Copy/Paste to Summary Sheet
Deleting sheet2 and sheet3 in a workbook
Vlookup in VBA
Variable Chart Elevation & Rotation
Adding a line in a row
Finding a Shape
Newbie question : Help required on recalculation
Transpose a variable length list
Pivot Page field filter based on cell value
Running A Shell Command In VBA
Display a sequence of cell values based on the week
Print CSV File With Correct Column Width
Acrobat ribbon name Excel 2007
Exit sub only and only if there is an error in the procedure.
Reliably activate PowerPoint, do something, Activate Excel
Saving a Workbook using info from a Cell???
Button to increase cell value and print document
Macro for sending e-mail with info from an excel sheet
Create Graph with Data from 2 Cells
Refresh Query if office 2007
Calling on Methods and Properties within Worksheet Modules
Shape Names on User Form
How to stop 'Egg Timer'
VBA to identify the name of a point
using record macro, can I stop it to get user input?
Format sheet header via vba
Macro Copy and Paste Help - Macro and VBA Newbie
VBA Macro - Loop through folder and move files to other folders
excel limitation
Splitting data from one sheet into 2 other sheets. Data is skewed
Excel macro to execute Access query
Find data on different Sheet
'Can't find project or library' error
RE: Hide the running macro
Tabbing through Protected Sheet
Using IF function .....
Matrix ANALYSIS
Macro won't run
Months as Column Headings
Sheet names from closed workbooks
How can I program an Trailing stop loss?
Print clipboard Contens
VBA code for if no visible cells after filter goto next stage
FormulaR1C1
I want a range not to recalculate
schedule
Formatting problem
Formatting problem
Formatting problem
Find Replace
Count unique text in cell range
How to load and import zip file using Macro?
How to format cells of a column as text programmetically
SUMIF CODE
rearranging the data
Formatting problem
MkDir question
formate sheet row a:a
Matrix analysis
On-Screen help
How can i use Office Assistant and Balloons in 2007?
Format Cells
Very slow when I delete Row...how to speed up?
Array Range
Deleting sheets within a workbook
Move files into particular folders
Inserting three rows at the top
Deleting a column using VBA
Macro to reset Validation box
Search with "Workbook" and "columns" built-in somehow?
ADO access to excel workbook on website
Making the worksheet.hyperlinks.add method work!
RE: Help for Excel time format "MACRO"
More than 65,536 lines
VBA for Lookup to other Columns
Excel 2003 VBA - Select a range based on a date
Excel 2003 VBA Assistance needed
wait for data to be stable
Left() Need the equivalent of this
Problem using tab in TextBoxes not in Userform
Conditional Saving
hyperlink to word
Formula R1C1
Macros to control Java application
Re: Margin Lines in Print-Preview Mode
cell format printing
Loop Check for Workbooks already open
copy hyperlink to clipboard
Option Button Value Zero?
Re: need to turn a word into numbers (or ascii codes)
RE: Sum of each row.
some exotic error
RE: Sum of each row.
Exporting to DB2 Database
Rentacoder project: seeking spreadsheet/script/macro developer.
Macro Modification help needed
RE: Assigning Range Names using VBA and R1C1
Ensure range of cells each contain an value
VB to send email via outlook to a distrobution list
Running a Macro when cell value is a specified value
Plain .TXT file to Word .DOC file via Excel VBA - Possible?
Re: =TEXT()
sendmail won't run on some computers
Web query causes excel crash!
IF value = "DEC" or "MAR" cut and paste 3 cells
Dates in Excel
SaveAs call changes text to #####
Update on out of control Active Cell Indicator
Referencing a workbook in a lookup
SQL update statement in excel vba
Requiring a value in a cell before allowing user to print
how to give variable range
Re: Second Smallest Number in a Set
Exception from HRESULT: 0x800A03EC at Excel.Workbooks.Open
Re: Pivot table - How To Obtain a External data Source??
VBA, 'implements', and occasional failure to upcast. [probably messyVBA internal bug?]
Re: Extract first word for a highlighted selection (non contiguoes)
Converting RTF file into TXT file
Re: AUTO FILL ADJACENT CELL WITH SPECIFIED VALUE
If result of formula is zero disgard it?
Re: Extract first word for a highlighted selection (non contiguoes)
Excel 2003 and AppActivate (patch issues?)
Update Userform updating to wrong cell.
Help with automating macro
Excel:VB properties window will not open; project explorer is ok
Interior Cell Color Numbers
Setting Print Range
adding shortcut to Quick Launch
MultiPage TransitionEffect won't work.
subtotal efficiency problem
Change cell colour on formula result change, no conditional format
extract and compare
extract and compare
What is calling this?
Visual basic for a rightkey command
Connecting macro from validating dropdown list
Create UDF in Class Moduels? (frm Leo)
GetSaveAsFilename/GetOpenFilename
Add Values in a comma separated cell to combobox
Select the sheet to the right Q
I need help with a macro to compare data between worksheets
TabSritp & Multipage
How to get info of new filename and new path
Excel ActiveX Combo - AutoComplete and LIst Issues
Moving VBA6 string functions into VBA5
Printer Names on a Network
Cycle through all workshhets
Excel Image or Picture from SQL Image Data Type
Move one ws to new wb. Save new Wb with same but modified name as original WB
Checking all sheets except 1
Personal.xls TOO slow
Copy row Macro Help for VBA Newbie
Multi Pages Setup
Need Help Converting Hypertext GIFs
Calculate string width in inches nzDec01
Check before overwriting file?
Importing a collection of WB's where one or more WB's is alreadyopened by a 3rd party
Disable WorkBook AutoOpen
using SQL to query Excel (or Access?) selecting specific row numbe
Invoking a macro from a cell change
multiple conditions for if then else
Change web address in macro
Assign shortleys to macro
Finding last appearance of given value
Sorting of sorts
Sending An Email In Excel Programmatically W/O Sending An Object
Userform Instability
Microsoft Query - reference to subquery alias
User define function that reply array
Unexplained size increase
User Form
Print an image of a web page
Inser picture problem
Run Part of a Module Q
running Excel2007dllsdk
Opening New Work with Wedpage Content when address is in original workbook
can i format a group of cells based on the number entered in a cel
Fi nd & Replace
Hiding entire row(s) on entering data in cell(s)
Unwanted characters saving to fie
Error due Changed Drive
Object references
Editing user defined functions
Help with Error in Function Definition
Close all Shared Workbooks
Formula in Range
How do I do this.
Excel 2007 Crashes in Vista
Networking by VBA
DoEvents(?) issue
The Immediate Window
CountIf on not number values. How can I solve?
How to write a macro 30 Nov?
Does VBA support multi-thread?