Excel Programming [Archive] - Page 41

Named Constant
assign Drop Down selections with values
Multiple questions
Error Trapping on Data Entry
Worksheet_Change - initiate macro on another worksheet
select cells with this/that colour with macro
web query for driving directions
if cell text repeats, move the adjacent column to the same row
Macro to put records of same person on same row and delete duplica
Passing reference to a checkbox to a subroutine.
Delete rows based on an array
Conditional formats
Help wCombo Box Setup
RTD issue with Excel 2007
Referencing an Excel Name from a different Workbook in VBA
Finding and copying from 1 worksheet to another.
Error 800a01a8
Shared Workbook - "1/0/1900" displays for some users
.Refresh BackgroundQuery:=False
dim problem when using cell() reference
Column Combinatorics
Help with external drop down lists
Getting around Protected Worksheet (number format)
Variable headers
Re: Please help me edit this code..Thanks in advance :-)
How to return mulitple values based on the contents of another cel
Re: Please help me edit this code..Thanks in advance :-)
Email Formatting
Urgent Help
Export range to XML?
Excel email attachment from outlookexpress
Conditional formatting - based on indentation
Copy data to next empty row in a range
How do I add the sum of a multiplication formula to another cell
Excel queries
Excel application logs
Delete specific menu item from custom menu
Can Excel pull live information from the Web???
copying data in a sheet to a new Word document problem
Your favorite Excel Add-ins
Error handler question in Worksheet_Change event
Excel registry key
parameter
Parse email text
Disable Shortcuts
Modeless Userform
name the sheet the same as the file name
Custome Format Alpha
Quick Access Toolbar
A better way to get Min and Max date
Minimise/Restore
Changing case in a cell
weekly totals
Refer to combox from activecontrol name
formula that once it is true info stays in new cell?
Counting Colored Cells
how to save in the excel some additional invisible information
SORTING MACRO TO CLEANUP MESSY SHEET
macro/vba
Disappearing Personalised settings
Create New Sheets from Filtered List - help on macro
Rich Text Box
Searching a Word Document from Excel
Startup
Free Tutorial website And Ebooks programing tutorials
how secure is projectProperty Protection?
Colouring cells based on day of week?
how to have checkBox in ToolBar (Icon) ?
Variables & strings
Can you write the contents of an Excel Named Range to Word?
range and visibility
How to paste a image into a VB UserFrame in Excel?
Help with code please !!!
multiply text and number
Userform driving me insane
Vertical Line in an XY Chart at Today's Date
MenuBar/CommandBar(s) reappearing after being disabled??
Macro to understand how wide or long the data range is
If source cell is bolded then destination cell becomes bolded too.
need macro to repeat two rows at top of each page
nothing selected in listbox, but listindex <> -1
macro to repeat non contiguous rows at top of ea page
How do I make a copy of a macro?
Hide Zero Rows - But Not Blank Rows
Behavior - Option Buttons
Code for Copying and Pasting data to a separate Workbook
Lop to delete rows
Batch file rename macro
VBA How to
Windows API Functions
Boost up Your Business through Data Entry Outsourcing By saving timeand money
random number generator for scientific simulation purposes
Enable/Disable Macro
Excel Chart
Copy Values based on a Match Q
Conditional Formatting based on multiple criteria
why do hyperlinks on userforms in excel work but not word
Recommend: object intermediate between Application and Project
Excel 2003 - Writing a Macro - How Do I...?
how to insert a row at regular intervals of row
split in vba
Help with Design
Question about the Queue of Commands in Undo
Need VBA/Macro help in Excel (I think)
Creating new worksheets and appending data from multiple worksheets.
Days360 Formula in VBA error
Automated e-mail from Excel
loop through matches
TreeView Control V - 6.0 - Drag-Drop Nodes
Formulas
Macros?
macro to add leading zeroes to number and loop
Weird Happenings
formuls
If row 2
Carts and Acticesheet.Range
All for insert of picture on Protected Sheet
COPY...........(need a little change in a macro)
Freeze Panes- Windows Split
User Defined not defind
VBA code disables Undo command
How to enter a constant sum formula using values from 2 different
Outlook
Plot grand totals on secondary axis in PivotCable
how to find whether linked data exists
Formatting based on a condition
VB Scrpit to input search results in Excel work book
Excel VBA - Graph/Chart on Userform
VBA help. Select dynamic workbooks.
Refedit problems after installing SP3 to Office 2003
Excel Sorting In VB
Create Worksheets based on column data
Excel Sorting in VB
Date Formatting
Screen Updating
Programmatically creating hyperlinks
toolbars
Find the next Cell with interior color using Do Until...Loop
Macro That Tests
Create folders from excel
UserForm to delete unwated items off sheet?
Storing result of function directly in a variable instead of cell.
How to Query the Database
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
Problem with second count routine from userform
Autoclose excel file after x minutes of inactivity
Need window handle for a userform
Saving date as part of filename
Dave - Trouble finding posts
Number of files in a folder including sub-folders
Lookup first/last column of record
SheetChange for formulas
SplitRange
Opening Excel File from value in active cell
How to disconnect the line for Internet?
Menu item
Private Sub Worksheet_Change doesn't work?
Avoiding IF limits with VBA
On Error Resume Next not stopping pop up message
Question with Solver code using "Application.Run"
Need a 'Refresh' button
Dropdown Box Conversion
Hide Autofilter Button but keep the filter on
Open Workbook Read Only and hide select worksheets
Combobox list appears on far left side of screen
VBAProject Password message appears when exiting Excel
Macro or VBA to Bold first 3 characters of a cell in the entirecolumn
Indirect in VBA code
VB Function exported in XLL file
Developing a macro that will help with mass address cleansing
Re: Worksheet name appears in formulas?
Formulas mysteriously break
Organizing list of contacts in .xlsx
Run-time error 1004 with Range
slow scrolling
Printing help
Add-in security
converting date to a monday date
Array formulas cannot return strings longer than 255
Import multiply csv files
How deactivate the keyboard and mouse
Workbook Open Procedure in Custom Template File
pick from list and automatically enter corresponding cell
Inputing Data
Useing IF to Paste a Range
Simple seach and copy help needed
Go to Last Active Window
Protect several objects
Check for worksheet in closed book - Help
Slow Office Automation
non-functioning keystrokes
Custom toolbar color
Calling a Webservice from Excel.
ADDRESS MACRO
Problems with saving an Excel document and Macros in Excel which aredisabled with no reason
Mulit-column number formatting
Multi-Dimensional Array Procedures
Compare Problem
Bookmarks in Excel???
function double output
Prevent saving in Excel 2007
Close workbook without saving file
Excel DB Query Parameter for all values
How do I use MS products to set up a linked product order form?
hide check box
Add-In UDF returning #NAME error
move item from one listbox to another listbox
Function - array with 2 variants
Protect a Worksheet
Accessing ranges within sheets
Change Upper Case to Proper Case
IRR Calculation question
check boxes
Macro for expanding a range
Combo boxes in userform auto drop down problem
executions per second
Colorindex 2 not formatting
split the contents of a cell
entering a validated value into a cell
Name Sheet with Input Box and text
Duplicating changes from master file from all sheets within a file.
macro for appointment
Check If Form Open or Not
simple IF statement
Issue with listbox not showing the last value in the range
Microsoft Office Document Imaging - Automation
Cell Address References won't update when Sorting
VBA freezes after opening file
Add-in is visible
Embed VBA in worksheet
Excel VB
performance
Sheet Selection
Clearing a Cell Value
Access from Excel
WebData Substitute
Template Wizard w/Data Tracking
Extending a range
Multipage Control in a Userform
Multiple Count Condition
SaveWorkbookAsToday()
Using VBA to change Pivot Table data source
Different approach? Re: Fill color based on RGB (PeterT?)
Value of Cell changes in each step, i want to record the previous.
Evalulate previous cell
Are there any events for outlines functionalities?
Bolding using VBA
RE: Exported file not the same on different PCs
Combo Box Row source problem
Are the "page setup" layout settings overwritten by page preview adjustments ?
How to delete all stuff outside marked cells ?
Do Until?
Research Analysis (3rd time)
Extract embedded objects in worksheet to HD
Conditional Formatting vb code
Test for Decimal
Displaying Members in Visual Basic
.NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
.Find cell within rng when font color=3
For Each code
Excel 2002 and 2000 crash with Combobox on worksheet
Excel 2007 - Macro Shortcut Key Doesn't Work
Delete temp file
using BrowseForFolder shell application
msoControlButtonDropdown
Trouble populating ComboBox from a range
Delete hyperlink from textbox
User Provided Path - Compare 2 Books
SQL Select string
How to programmatically digitally sign code
Sheets and Worksheets
Determine whether the user has saved the file?
How to get the correct active Cell position in Worksheet_Change
Conditional Formating
Copying tabs from one spreadsheet to an other
Microsoft Calendar Control 11.0
read and grab data from database
conditional formatting on click
RE: Reading office properties - dsofile.dll
switching window stops running macros
"run-time error '1004' - select method of range failed"
COMException raised on opening excel file in thread
address of activecell in another sheet
Hide Command button - still use it
Pop-Up Calendar
WTC Towers: The Case For Controlled Demolition
formula behind field on user form
How do I create buttons to link worksheets within a workbook?
Fill down formula if other column contains data
populate output form programmatically
If Sheet Exists Q
linkedcell with togglebuttons problem
Extracting text before ~ sign
Compilation error in hidden module
How can I set focus back or remained on Textbox?
set variable while looping question
Macro to build code
Research analysis.
Hockey Statistics
Populate Sheet based on ComboBox selection
Useing If to Delete a Range
Suppress Mouse Hourglass
Troube defining variable
Referencing a Sheet based on the Month
Do Until empty loop
Error on Set Rng statement?
Using Array's
Combobox
Macro for Pivot Table
Paste To Visible Cells Macro
Select Case
Find value in a 2nd workbook
Importing CSV Finding Min/Max
IF, Case, or something else
Populate List or Combo box based on User ID
Populate List or Combo box based on User ID
rename a copied sheet
Grab Open Outlook Username from Excel
Tweak to code that checks colors of fonts and moves to proper shee
VBA in Excel
"Help Checking Out Macro"
Need to find all 9-digit numbers
Automate IE Web Query
Array Formulas
Need help with a randomization problem in Excel using PopTools
Transfer Data from Input Form - Offset to different worksheet
Fill color based on RGB
excel sheet to outlook
My buttons shrink!
Custom Sort Order
PLEASE HELP: Enable Automatic Refresh
Select rows in a date range
Copy links from one spreadsheet to the other
What does the WebPubli****em ID Value Represent in a Sheet's XML F
Submenus on Shortcut Menus
Macro to check for file update
Email downloads into a single Excel cell - data separation reqd.
Compile error in hidden module: "Module Name"
Conditional Selection VBA code
Macro Hidden - Cannot "Edit" to see code
Populating a userform with a Word document (read only)
combobox
Copy Named Range from one sheet to another with formatting
coding for macro
Sort cell values of different columns
2003 -> 2000 incompatability
extracting data from sharepoint
adding date from user form with calendar to next row
Advice for generating excel spreadsheet through asp.net preferablywith excel 2007
RE: Input Custom Header on Print
Input box with a loop
Renaming sheets
Evaluate a Name in Non-active WB
list of used shortcut keys
Listbox problem
Buttons appear to stay "pressed"
interaction with excel and ms SQL (retrieval of records from sql intoa sheet)
handle error in cell values
Code exected at "Workbook Open" slowing/stopping file from opening
Returning Cell Reference/link
sumproduct
Unexplained read-only from a batch file
Change Row Color using VBA
Numbers stored as text
Loop macro error
Can a custom Search function return a cell reference?
Looping through list of workbooks to open & sheets to move
Outlook and excel
Comparing cells, coloring differences
runtime error 13 - type mismatch error in Excel 97 on Citrix
How to grab a reference into VB
Worksheet Labels as Combo Box Selections
chart from pivot data, and sheet data?
Time Difference in VBA Macro
Search column for string and write to cell
.NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
Why my procedure will re execute at a certain point in the procedu
VLookup & SUMIf
Use AutoFilter
Return Max Value of given Variables
Setting up capitalization after hyphens
Predefined Print area based on variable
Word doc in listbox
Dropdown list
saving a worksheet as a .txt file with filename of specified cell
Need to lock data based on '=today()' value
Return Filename
Timestamping
VBA or Validation?
Error: Exception from HRESULT: 0x800A03EC
I want Excel to determine the correct directory.
Indirect Lists and Dynamic Ranges
Automating "paste Link" fuction using VBA
Analysis Toolpak VBA module documentation?
Read directory code which needs to include file size
Creating a custom function to interpret another custom engine func
keep cell reference
Copying the first row of wbooks with ADO
Re: How to read workbook (not worksheet) properties with OLEDB
Accessing New Menu code
Download Automation
Making a Macro that will run a script at the end
Conflicting VBA's
A good use for an Object Stack?
Writing cells using Range() slows down with successive writes
Quotes around text in Msgbox
Macros
How to sort a column based on two other columns which are differentplaces?
If statement / Command Button / Message Box
SUMIF in VBA
Last Save Time, Function not updating in cell
copy data input to archive
Does custom document property exist
Sheets.Select
Inserting Control Toolbox text field in Print function
.Delete speed
Looping through columns
.NET in Excel 2003
Using Conditional Formatting with Drop Down Menus
I need some calculations done in a message text string ...
Pivot table Field Setting Number Format
Formatting cells from a value in a Listbox
Macro hangs when run from a command button
changing math operations for math operations with = sign
Why doesnt this work
Slow Program
RE: help needed - named ranges and pivot tables
RE: Hide Sheet
Re : Excel Worksheet_Calculate() & Worksheet_Change()
Running Sybase Queries directly from Excel (using Visual Basic)`
Data Connection from Excel to Access
60 günlük deneme anahtarı
How to load a list of web links into specific worksheets?
Web query
Pulling file names & path from folder and putting them in cells
Strange problem with spreadsheet
Can anyone help me with Scrollbars please?
Cell color = Button face color. Possible?
Macro to F2, F9, then cut and paste
2007 Macro's Painfully slow
VBA crashes by itself
Update sheets & cycle
column loop
Hyperlink - Data Validation
Hyperlinks imported into Excel
Keep Awake Nudge
Look up file by date/time stamp.
Files SAVE AS
Macro for returning to the previously selected cell
count function question
Create URL from excel for use in IE, favorites folder
oracle tables
simple nested loop question
CPearsons import text code
提取另一工作表整行内容
IMAGE CONTOL AND PICTURE SIZE PROBLEM.
Should be easy but!!!!!
Userform Title Bar
Freeze Pane Line
Title Bar Hide
Call UserForm procedures from another workbook
Mouse Scroll in Textbox
Link to file in subdirectory
creating a command button
How to program to insert / delete any worksheet?
XL2007, Selection.Delete deletes more than the selection
Printing Embedded Text Box
Excel VBA vs Time fields
Merge data from one sheet to another
Excel 2003 code to use instead of ChartObjects
Data Validation List Problem
Delete multiple pictures on top of a range?
Excel 2003 Macro to add text to front of data in cell
Displaying word/RTF files on a Userform
Array Formula - Offset Result Problem
Cut - Insert without .Select
Clipboard manipulation
DAO on protected workbooks... come on guys
Spliting Numbers from a Text string
Pivot Table Shortcut
Combo Box linking
Determining number of Ranges
Re: autosaving - message box
Conditional formatting a range
RE: Password required to select value
Re: decimals and oracle
worksheet_calculate
Optimization challenge
Re: save as .xls (97-03 format) with code
Hide yesterday sheet.
Data Validation and Formula
Re: Scrolling Charts with scrollbar
Re: Scrolling Charts with scrollbar
PRINT THE HYPERLINKED FILE
RE: Start Excel file on remote server
Re: Highlighting part of a cell contents in Excel 2003
Need your help on excel 2007
How to copy a graph from excel to userform picture?
RE: Placing data in specific rows.
Recreating the DateSerial()/Date() function
Application.Calculation = xlCalculationAutomatic
ExecuteExel4 Macro parameters..
InSTR Compare erorr
Text to Columns Code
activecell.offset question
Re: Set XL range into Wrod bookmark as a table?
RE: save as .xls (97-03 format) with code
RE: Multiple Monitors Resolution & Userform
RE: Tool:Options
Closing a modeless dialog via "esc" key
RE: Highlighting part of a cell contents in Excel 2003
Re: runtime 9 error
RE: pivot table showing text
using DAO on a password protected workbook
Counting Instances
Background Batch Processing
How to read workbook (not worksheet) properties with OLEDB
Re: VBA to reference one cell in a range of one or more cells
Problem with AppActivate ("Microsoft Excel")
Number formatting with VBA - Problem when used in different Country.
Delete rows if particular cell empty
Looping A Variable Used Within An Object Name
Cut data in 2nd row and paste in the end of 1st row
Sorting a string array
Convert code name
Fill down for all the cells
Menu Item
return sheets code name
menu bar and error 91
Hide rows outside a known range of rows
Weighted Average with multiple conditions
Insert row macro
selection for output
How to loop through cells in a column?
macro
multi cells selected
Calculate Angle and Length in Triangle
Reading an external text file
Where do the header columns come from in a form?
Expand and Collapse groups
Conditional formatting crashes macro
Main page Recalculations
Excel 2007 Add-in with VSTO
VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it
Using Office Web Services Toolkit to access a WCF service
Summing values on a Page change event?
Clear Contents of multiple continuous ranges
variance-covariance matrix (w/o data analysis kit)
How to insert a picture's address as hyperlink to a cell?
creating invoices
Using Excel for Billing
Userform confirmation page
VBA Cell Selection via input box
Sub Workbook_Open and BeforeClose not working
macro to delete hidden or unused rows
start an external application on workbook open
Rick Rothstein
Summary based on channel & date ranges
Outlook reminder
How to change the text of descriptions for excel open documents on atask bar
Problems with Selection
Text to columns
Database import
declare multiple variables
Refresh Cells Based on Macros
time selection
Checking to see of a folder exists
Show count down during operation
Conditional Formatting Help!
Macro program to delete rows if its 2nd colomn start with 'F'
Replace existing custom toolbar with an updated version
Perfect Macro Combinations
selecting cells
What is the advantage of creating this Class.
Help needed with code
drop downs in excel
Searching/Retrieving Data from another Workbook
png images files as a button image?
Not so Random Numbers
default mailbox and moving attachments
100ths of a second
don’t see the Controls on the Forms generated at runtime
Determine if item is in a range of items
User Form Show
Add a comment on cell content change with VBA
How to call user defined function (UDF) from custom menu in Excel2003?
Worksheet Protection
RE: Mouse Scroll event in listbox kills Excel
Setting DTPicker to a null value
listview in multitab
disable shape resizing or moving
easiest way to convert a number to hours
code of "send this sheet"
提取另一工作表行内容
Import Picture from camera
return formula in cell as string
access the call stack?
Inserting picture from Camera
Need to prevent call Sub Worksheet_Activate() during macro.
Error transporting excel 2007 macro to excel 2003.
The directory property cannot be found in the cache 8000500d
How to modify a range in a function?
reading excel
VBA IDE Extensions
How do I copy and paste a powerpoint slide from excel using vba co
insert rows based on a cell's value (macro)
Copy worksheet to a file in another directory
Cell J1 to reflect activecell Row a2:a500
Finding your post.
compare all matches
How to find row with more than 255 characters in a cell
Error 1004 help needed
setting the gradientstops of a point in a macro
Nulls vs. blanks?
Auto Correcting and Auto Filling Cells
want J1 to reflect the value of a:2:a500 as the cursor enters the
Label Position - Above & Below
highest sheet name
want cell J1 to reflect the location of acitivecell.value
Excel writing on explorer's window
Prevent print setup changes
Making a custom toolbar available to others
Assigning a constant to a range name
copy rows from one worksheet to another using macros
Matching Colums & Rows in Different Spreadsheets
Update Links
for...next including if function and or function
String separated with commas
Extracting Nested PivotItems
Find formatting in text in cell, insert tags around formatting.
Macro Question
Run macro until range ends
reoganizing data that has been scanned into excel
Conditional Formatting
add sheet values
Chinese Characters and VBA
VBA to SUM a row of numbers
Validation subroutine for textboxes
sheet name
enabling & disabling attached toolbar stops sheet selection
Simplify long process
Turning a large spreadsheet into a room by room list
userform query
Change Background Color on PivotTable subtotal row
Range error
finding error in range
userform macro to recognise non-blank cell
determining dynamic print area
VB script modification (continued from yesterday)
How do I clear Print Preview?
vlookup question
RegExp
comparing values
2007 - Add-Ins tab
newbie to ClModules is this correct use of Property Set?.....
Runtime error 1004 on an application.count statement
Simple VBA range loop?
Copying columns
create zip files
Pivot Chart Dropdown Question
Specific range formating
location of userform to activecell topleft....
Create Userform Objects
clear button
Digital cameras, mobile, LCD TV, Laptops, Notebooks, Digital Video,Mp3, Mp4, GPS for you!
Same Items in 3 different Combo Boxes
Listbox 01 --> 50 in UserForm
Highlght rows
product of two cells
product of two cells
Userform Calendar - Current Date
almost have it... need help with last bit of it.
view one worksheet from within another workbook
Worksheet_Change Event Strange Behaviour
Convert xls to pdf and bookmarks
Range Printing
Variable Subtotal range
Remove from listbox
Closing a program which was opened with shellexecute
Excel Web Service - Multiple Pivot Charts - How to Have One commonFilter
UDF for extracting hour from Date string
Run time error '438'. Object doesn't support this property or meth
Numbering Function
picture is too large and will be truncated BUT
Excel 2007 vba - Refresh after web query?
Determining Cell within Range
Disable screensavers from Excel
Huge database of profiles with photos for all 30+ local singles.
Pass Variable to another Sub
code won't loop
Passing arrays from Excel (VBA) to C# uisng COM interop
How do I add to Auto_Open Macro keystroke Ctrl & F1 ?
cell validation on protected sheets
Help needed with Excel VBA sort
SpecialCells in UDF
Distribute Addin
Searching from Excel
How to scale image to fit inside a merged cell?
Find rows with a common item and find or highlight difference
Is there a way to Calculate with a VBA?
Show Excel comment on mouseover but not the comment indicator
Inserting a named range while recording a macro
Dropdown in cell base on a selection of a different drop down
Cell Change Event
Need help modifying VB script
vba 2007
Visual Basic 6.5 in Excel
Sort
VBA for Smartphones / Windows Mobile 6?
Locking Excel rows using C#
ending zero
save button
Request for Help in Developing a Macro for a Billing Application
Array help
Save workbook and delete old workbook
How to print line/row numbers as well ?
Loop Macro
Sign In Button
Pivot Table: group dates by filing period
Add a VBA Module from a String instead of from a file
Variables being randomly destroyed
Excel 2007 .AddPicture: Can it use a URL as a source?
User Defined Function
Compare columns in two WBks and when match is found...
QUERY EXCEL TABLE DATA
really weird behavior, chart with textbox font size problem
Activating Outlook files and importing data from within Excel
UDF to evaluate if row is hidden?
How to disable and enable multipage elements during runtime?
How to access all the textboxes inside a frame?
How to refer to the .text property without text box name?
Faastest way to find last previous entry?
Load XLB file with worksheet?
Automatic macro on sheet
Invoking another Application from excelvba
Data validation list in accending order
Conditional Formatting in 2007
updating userform
"Mopy"
Select and delete entire row Excel VBA macro
Prevent Comment deletion
Floating Information
Bookmarks from VB to Acrobat 7.0
checkbox backstyle
Charting Problem
XL2002 - Application Resize Event...
Protecting a Worksheet Question
replace only 8 cells of a row from next raw if one cell has value of45g
A formula or macro that will place the date in an adjacent column Bany time something is typed in column A
VB Code to hide and unhide rows
copy csv worksheet to xls book using vba/vbs
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
How to export chart to a network drive?
Problem with query against CSV file using ADO
Insert a quote mark, then repeat
Start a Macro when a file exists
Excel
Excel to text file
Using Query in Excel
Equipment loading using Excel graph
Copy formula down up to last row
Searching fro A file and returming the pathe to that file
getting current procedure name
Edit Cells while Macro is Paused at Message Box
Multiple Sheets to one sheet
Selecting a worksheet without making it active
userforms starts crashing and getting "unstable"
Protect workbook
how do you save a form created with the data form wizard
Calling Function in Add-in
copy a formula down up to blank cells from other sheet
Auto Macro and Locked PC
path error when pointing/going to userform1
office 2007 custom toolbars
new custom menu
UserForm ListBox problem
Parameters in Forms Buttons - not working in Excel 2002
vlookup or match function across worksheets (x-post - sorry)
Worksheet_Change and Copy
Copy data from large worksheet into multiple workbooks
Moving data from Excel into an Infopath Template
Efficiency re: Module Sequence in a Project feb08
Extract Outlook Contacts to Combo Box in Worksheet
Web Scraping With Loops
SaveAs to different filesystem causes unreadable content
pasting a link
Help & Advise with code Please...
Help & Advise with code Please...
change date from 020315 to 03/15/02
counting checkboxes
Automatic Moving
vb project data exported to excel
ActiveCell.Value just disappears .... ?
Run Time Error 438
Check for font
Setting width in pixel in Excel
MACRO CODE
Please Help - Trying to Launch IE from Excel
create named worksheet based on existing numeration
Deleting a range after selecting a sheet
CODE FOR SHEET MODULE
Copying workbook to main workbook
How to make combobox non-editable?
VB code to run multiple macro
Object problem
Check To see if file is open
comboBoxes on a userform
SumIf Function Question
Macro to delete rows if they don't begin with "0"
Preserve Option Buttun Selection
MACRO TO ADJUST COLOUMN WIDTH BY VALUE
Runtime error 57121
Creating a view of another workbook
I need to help with Excel (beginner) -- year row and month column
Problem with ComboBoxes
Excel users! Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations!
Cancel on Worksheet_Change
Error on opening Excel 2007(.xlsx) on office 2003 machine.
Disabling Compatability Checker in Automation
How to Insert Subttoals after the Excel File has Created
OnAction callback is not invoked using hotkeys
Combobox width not showing full data
worksheet change problem
Re: Is this macro scenario possible using VBA?
How to disable activex controls & code on saving a new workbook.XL2003
Transferring a Date array to a range
How can I transfer an MSFLEXGRID picture to a worksheet?
Calendar Control
Scroll bar not appearing in text box
A basic Macro: going to a particular Worksheet and then selecting thefirst blank cell in column A
Save As macro
How to Set an Option Button
Time if/then caclculate average formula?
deleting negative numbers
workbook used to open but now crash with File/path error
disabling message
Hiding the Row and Column designation bars?
Set Zoom Level in Auto-Open Macro?
worksheet change
Excel 2007 Macro Record
Place an autoshape
Newb VBA question
Create CSV file based on table in Excel file
VBA and Excel 2007
Closing Workbook then Activating Other Wb with Userform showing?
Alphabetizing Worksheets
Editing text in cell
This code does not work
Finding a worksheet
How do I add text box styles to a worksheet?
Re: retreive Access via ADO
Sort Worksheets
replace cell with formula
Help on VBA and Excel
how to call a dll that requires parameters...
ADO to get Worksheet Name
Excel Progress Bar problem
Maximise My Excel Window on startup?
Lookup between list of Mins & Maxs
NMEA input
Networkdays code error
Turn on secondary axis
Macro and Copy and pasting special
Selecting a small range of cells to delete
Horiztonal page breaks and Margins feb08
Inconsistent Printing of Spreadsheets
organigram/diagram in Xls
application worksheetfunctions fail
store variables
Problem renaming worksheet
List all Computers in Workgroup
On Change code
Disable Calculation of selected worksheets toggle
Deleting code comments from modules
Need code for fill a number trend down
Re: Error 76 in file download code
"Open Browser Window And Select A File"
How you do rename a module?
Copying Data in excel
Select a PivotField range without using the range object
Textbox - Shape
Run another macro from within this macro
Copying data between workbooks
User Form creating shadow images when moved?
Range names starting with underscores?
Adding and Graying MAXIMIZE button on vba E2007 form system menu
Paste Link
"Damage to the file was so extensive that repairs were not possible"
Excel Template
Adding/Removing Rows to Referenced Ranged in Worksheet
New toolbar in Excel 2007?
add comment in the loop
Update worksheets
Selecting a range of a Find object
Selecting a range of a Find object
Create copy of multiple worksheets and automatically fill in datafrom a main sheet
need breakpoint to stop code
Email with Outlook Express Problem
VBA code mysteriously stops running
Count unique values in Pivot table using VBA
TAB BUTTON - VBA TO SKIP CELLS
VBA Macro Required for Insert Row . . .
Broken: Set Cells in Range to 0 if blank
Re: Search all Macros for Specific Construction
Macro for filtering
Re: External query - No columns
Display something on first open only.
Delete rows if data changes in particular column
Importing ASCII text into worksheet
PLEASE help ...
how to understand the three names relative to one worksheet
Excel 2007 AddPicture help needed
Editing text
How do I link to and import specific data from other workbook.
Update Textbox1 after combox easy help for beginner! Opzioni
protect sheet using vba
count 1st cell and last cell that contain specific word
Shortcut Keys
macro copy data from one file to another?
Copy and paste
Cancel Click on label control
Macro to create sequence of numbers
Re: External query - No columns
Simple macro
Pasting HTML table into excel - Problem
Doubleclick
Problem renaming command buttons with code
HOW TO HOST / SHARE WORKBOOK ONLINE ?
Using a string as a formula (for an array)
Embedded word object
Remove Autofilter
Combo box
Differences using worksheet functions in worksheet and via VBA
Determining if a cell has an external reference ...
Refresh Query on open failing
how to I import word form fields in excel
Add-In: Functions and Category
Debra Dalgleish's clearing old items from Pivot Table dropdowns
Code to add a workbook the rename it
How do I create a new slide in PowerPoint from Excel using VBA?
radio buttons independent for each row
No Duplicates Allowed
VSTO - Programatically building an org chart
Find a Named Range programatically using VBA in Excel
hiding worksheets programmatically
Re: pulling properties
Change the color of a cell when I type a certain word.
Deleting duplicates
MSXML5 and Excel 2003
Sorting by cell color in Excel 2003
another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
In Excel visual basic - Need an "auto adjusting" fill down macro
UserForm Initialization
refedit controls and Excel 2003 sp3
UserForm Initialization
UserForm questions about text box propertys, thanks
Help with code needed
RE: Validating two lists.
Re: SUMPRODUCT HELP
Re: Application.FileDialog(msoFileDialogSaveAs)
Re: pulling properties
RE: VBA for Skipping Cells
Validating two lists.
macro to refresh data
VBA for Skipping Cells
RE: ParamArray values not being passed, Feb08
empty range
Sort Errors
Changing Contents of a cell.
Macro to change date cell by specified interval
Calendar Control in UserForm
Using cell values in SQL (MS Query)
Incremental search to find worksheets
Validation lists that change based on a selection from another lis
Custom Function Problems when multiple workbooks are open
ChartObjects problem - can you check if a ChartObject is"full/contains data"?
Setting Range in VBA - partial repost
Radio Control Confirm problem
Problems with Custom Functions and Muiltiple open workbooks
Autofilter Question
Using Autofilter within a macro
Data Validation starts change event
SumIf Function Questions
Copy from one sheet paste to another
Two way lookup
Re: vba addin to copy a workbook
List of all open Shared file names
=DATE() function in VBA?
Why calculated cell's value not updated when I change cell valueusing ado.net?
import multiple files
listbox multiple selections
Printing all the charts
Sorting data in Excel
stop VBA
UserForm Tab Name Change
Using xl MID function through VB.
copy paste
Summary of list with multi length numbers
Pivot table with start and end date selection option.