Excel Programming [Archive] - Page 82

Variable from Userform to Macro
Refresh Data - Database Queries
VBA cell values
Beginner help! error no return() or halt() function found on macro sheet
Problem with inserting picture.
File Save As through VBA
Sheet Tabs: API manipulation to a multiline TabControl
conditional formatting, multiple criteria
Need custom color palette for form object on worksheet
Userform data to the next available row
Conditional Formatting, Multiple Criteria
Conditional Formatting, Multiple Values
macro to run on a list of hyperlinks
Offset from a variable column to a fixed column
Access to another excel instance?
Printing VBA
Pulling data from another WS
Associative arrays in VBA?
how to save .xls to .html please go through discription
Is setting the transparent color of a picture possible?
ActivePrinter in Excel changes!
Populating a ComboBox in a UserForm
An array of Cells?
Calling Specific sheet in workbook with Code
Run macro from Web
Runtime error 1004 - how to solve
Wrong number of arguments or invalid property assignment
Outlook Express - how to send value of a cell...
How do I map several item into an item
Email value of a cell in Outlook Express
Email value of a cell in Outlook Express
Re: Email value of a cell in Outlook Express
Email value of a cell in Outlook Express
Percentile --> how to?
Excel VBA Tutorial
create sheets and copy rows
Calendar - conditional formatting?
Macro for Stop to delete workbook
Retrieve from Acces
invoke an event procedure with a shortcut key
how do i identify first and last row once filter applied
Need to display ANY file type...
Can anybody help..?
Please Help! Column Header Lookup
Copy and Find macro help please.
RTD API
Name Box Width and Height
Importing all the .txt files of a folder in a same WB but in different WSheets
Pictures in Excel
cut textbox
VB for plotting time line on xy graph...
is there a way to search for a specific value in a formula?
VB for plotting time line on xy graph...
Can I open a graphics file from within Excel
Open Command
Charts using hidden cells
errrors while trying to delete a commandbutton
Immediate window
Pivot macros error 1004
Excel sort vs VBA
Auto_Open Select Worksheet
Select a range...
How do I find "?" character in a column using VBA?
Error using WorksheetFunction.Countif
Check for Print success
Deny User Save Option
Macro for deleting every second Row of Data
convert string to columns
print copies of the same sheet with changing values in a box
Conditional Deletion
duplicates
Toolbar seperator line
Macros and China
Creating a call log help.
RefEdit problem: z-order of forms change
Question on how to reference multiple cells in VBA
Protecting cells
I need to convert a number to text
msg Box Title Not Working
Inserting Multiple Rows
msg Box Value to be Saved File Name ??
If Pivot Table Exists
Site
Replacing characters in cells string
create event in class module
find each of the items in an array and save result in another array
Negotiating Cells in Specific Order
Move WorkSheets Within Same WorkBook!!
Macro code to show a graph (in sheet2)
Open a file and read contents
Private Sub Workbook_BeforeClose() really isn't working
Dir( ) function not working first time through
Fractions displayed in cells, Why not in user forms?
Copy Formatting from one row to another using VBA
Dealing with different version of Excel using Visual Basic 6
Text to columns question
get name of every open 'Program"
Excel Format Documentation
Changing a named ranged based on array size on a form
Conditional Formatting with multiple criteria
how do I separate 1 excel column to read city, state, zip columns
How to edit pivot table data source??
Searching and Updating spreadsheet
Shrinking controls
Adding Checkboxes to a Form
e-mail code
Could anybody tell me what does "Ne01" mean?
Code is not working
Do Until Question
find range of non-blank cells in colum
Function dependent on prior cell value
change event not recognized
Search/Sorting data
if date=then populate cells
Re: Interpolating an x, y point from known x's and y's
Calling a private sub in Outlook via toolbar button
sumproduct in Excel Macro
Loop with Cell Change Event
Obtain information from Excel?
Loop with Cell Change Event
Please Help.
Find a Worksheet
Replace object causes an error if search text not found
OLE DB Provider and Excel
Help needed on macro
Excel
IDE, Search - changing default
For Next Loop...Copying from a cell one column to another...
Array data in SQL Query?
loop through rectangles on worksheet
Standardise all cells at once
Concatenation with Pocket Excel
Manipulating Controls on a worksheet
Any easy way to conduct GARCH modeling?
Static Time/Date Stamp
Symbol and Tahoma fonts in same text box?
Changing Cell Text During Change Event
Macro for updating a sheet in multiple files
SUMPRODUCT issues
Excel Pivot Table Group Formatting
Trim function as a procedure - a simple example
How do I print multiple worksheets at the same time?
Bug: Call Sub in other book
Compress into one page
Website recommendations
RESETTING ORIGINAL FORMATTING ON SHARED WORKBOOKS
UserForm as a tool bar/ floating options for excel sheet
Last Row with Content - As a row
How do I average a list of times (i.e. "1:30" plus "0:20")?
Conditional Formatting Formula to Color Rows Based on Column Value
Large formula to VBA if can be done?
List Box Problem
joining two columns together
.Refresh BackgroundQuery:=False
Macro excel
Renaming File
.Refresh BackgroundQuery:=False
How can I use a loop here?
Locking Up
Conditional Formating
Combobox to determine text for a range of cells
Dynamic cell address resolution in visual basic application?
How can I get around "Find" if there's nothing to find
Formulas don't calculate
Problems with Validation object Add and Modify methods
Adding And Deleting Sheets
How can i sum a range of cells ( Variable ) in a specific cell
Web Query
Calling Excel user defined function from C#
Formula using color of a cell
deleteing specific rows using a userform
RefEdit in Class Module Problem
Manipulating MS Word from Excel??
moving a file to another folder
Finding duplicates in a column
Telling excel to update or not to update
Quirky Code
Comparing two ranges
How change link source in long formula when source moved
is it time to abandon Excel?
Limit Scrolling
Auto_Close
Could not load an object because it is not available on this machine
specific data
Can you help me?
Drop down lists
Automatic naming Worksheet tabs
Automatic naming Worksheet tabs
Help me insert a table of data into a body of an email
Help Plss
Opening a file with changing dates
about random no
Insert and delete rows
how to count rows
Socket Connection via Excel
Border Macros
Linked Workbook Update.
Macros using Add-Ins
Close without saving
Compare string with integer
question on a past post
Class Module Problem
Multiple Modules in the same workbook?
Expiry Reminders - Reminder email to relevant party for further ac
datestamp a comment into a cell
Procedure not running automatically...
Nesting multiple subs with If...Then statements
Workbook_BeforeClose?
Excel and Visual Basic
MAX Value of a CELL in ALL sheets in a workbook
Can this be done?
cell address
Rounding in Excel
Filter External Data
SOLVER solversolve showref
Objects in Excel
UserForms
Refresh textbox to reflect scroll bars if appropriate
Is it possible to join columns where there is a match?
Parsing Characters - Bug ???
Excel VBA Listbox
Anyone know where I can find free VBA code for a user-friendly financial spreadsheet
Name assigned in workbook refers to range problem!!!
How to omit certain worksheets in a series from printing
Require some help!
RE: Interpolating an x, y point from known x's and y's
DoWhile Loop & Type mismatch error
Percentage in a cell
+(-)ve values ends in Dr(Cr)
Match in VBA
how to Activate the previous Open, workbook..?
Disable Cut and paste
Hiding New Workbook created using Macro Recorder
Error Autoloading Addin with UDFs
how do I change a hyperlink to text
macro to search and list data
No cell-selection in worksheet
Can this QuickSort work?
Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100
HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
Clearing Row Contents (using Intersect?)
copy and insert entire row based on integer in column A
checkbox
Return a value associated with a range of values, e.g. tax rates
VBA Auto_Activate
Large formula problem
Multi-Level Data
Letters of Alphabet
Getting screen coordinates from Range
Excel named cells or labeled cells question
sum() using indirect()
did you edit code?
Help with blinking text
Installing Crystal Ball 4.0 on Excel 2003?
Refer to combobox in userform with variable
Closing Workbook without Questions
Custom number formatting
Macros wont run??
Retrieving an Excel VBA Editor password
template macro executing problem the 2nd time
Excell named cells or labeled cells question
Renaming Files
Place a variable inside a directory path
Shellexecute fails with Excel
UserForm1.show fails if another workbook is open
Rename Module via VBA
checkbox(do not show...)
Formula Not Working-Help Please!!!
variable not recognised in embedded macro
Need help with pictures!
Highlighting a Past Date
VBA Cell Summation
Wanted: VB expert to write in built macro in Excel
need change the number format
Macro to delete rows
Timebomb protection of Code
Set Value from Vlookup
Renaming files
How do i call a macro from a cell
User name and greeting
how to drag and drop from a listbox to activecell with vba ?
Find and copy in Excel
how do i record changes i make to a cell?
Sending ONLY Range or Page x, BUT not entire Activesheet, How ?
automatically assign a hyperlink to a cell
SOMEONE CAN HELP ?
leading zeros
leading zeros
Need formula for date ranges Please & Thanks
Conditional Formating ?
Calendar Control
Calendar Control
Using the VBE: Selecting vertical instead of horizontal
Workbook access
Location for DLL used by add-in (XLL)
PivotTable with Member Property - how to subtotal on Member Proper
Probs w/Displaying Graph from Excel Interop Add-In Function
Unable to set DisplayAlerts property
Fit to page macro
opening order macro for files in a folder
excel 97 running in excel 2003 has command buttons disappearing
QueryTable problem when running first time only
Find Value and go to that Value in Another Sheet
Challenging Formula
Excel Row limitations
Determining Row number where two conditions match
Email help...need IF statement for more than one recipient
Generating Error for UDF
Distribute Excel workbook with ActiveX controls.
The size of progress bar changed.
Workbook.Open question
character count
copy and paste from and to protected sheets
Go to. . . after data entry
Need help with form logic
Recalculate function
Worksheet Codename - Crazy Method Error!
Need Find and color row macro
WHY OH WHY! ... creating a dynamic array of outlookmail items, then display them.
Adding .NET Custom control to a Excel Sheet from an Add-in
File, SendTo, MailRecipient code
List Box Row Source
Move of Sheet screws up Stored Sheets
Any way to copy contents of print area with macro?
Post results to a new workbook
Excel does not recognize xsd:import namespace???
Excel Web Query not displaying Umlaut correctly
Excel Web Query not displaying umlaut character correctly
Macro to link two files- please help!
Filtering
How to select an added worksheet
Averaging ranges
macro for converting number stored as "text" (or preceeded with ') to "number" formatting
Hiding AddIn Methods from Worksheet Functions But Exposing to VBA
Percentile - Data in arrays
Range to increase/decrease with data
Migrating modules from 98 to XP
Matching a Year and then Summing the totals
VBA Interview Questions
Validation list problems
Copy cell values if cells match on two diff sheets
Web query
Macro for deleting rows
Copy rows with a specific value in column A
shift formulas to the next column
Stupid Syntax Question
Strange Sort
Finding Unique Entries Among Two Columns
How can I rename a module in VBA?
Copy worksheets from one WB to another with external Macro
dynamic range names in Edit -> Go to
A challenging task in VBA
Error message - state all strings
Trouble Using InputBox Method to Select Range from Other Sheets
Table to Database layout
Procedures/Macros in the list of Macros
Row colour change on input
Auto sorting
Inputbox macro for multiple cells
delete rows
combination lists
Worksheet Function
AutoFilter Data
Automatic accept all pop up dialog box
Print 1st page as Landscape and 2nd page as Portrait, HOW ??
log of when files opened...
Re: log of when files opened...
Macro Stepping
Problem when uninstalling an Add-in
Shortening a Macro
Recording a Macro with an Add-In
link dynamic data to cell?
Record the time a user selects a macro
VSTO: insert one row into a 1-row range
Simple code to append numbers to the existing data in the cells
How do I set up a business customer information system in Excel?
Extracting Top 5 & Bottom 5 Variances using a Macro Button
Color formating
copy and paste and clipboard contents message
Creating a Macro Button to Extract Data
How to get a macro to execute for every xls thats opened on a mach
Workbooks.add (?RefName?)
Stop marco allert and update link allert when opening spreadsheet
Simplest way to show/hide boxes when a Macro is run
NetDDE DDEShare and Excel
Linking a Drop Down Cell with the Macro
Multiple UserForms not closing
module moving
RE: Count numbers of times workbook opened
RE: Insert symbol
How Do I Use an XLL Add-In Function from Code?
Hiding Methods in Automation Add-In
Calendar...
Query Table "Connection" Prevents Excel from Quitting
quantinfying dates?
Re: Need to scan xls files and identify if they use macros...wanna use VB
convert table of hyperlinks
Help Please - how to link books and auto populate with new data
Question about sizing Userforms programmatically
Cut & Paste into column only if column cell is blank.
find the next empty cell: expanded
Hide Print option from File Menu
Skip sheets while indexing
How to test for Not Nothing
How can I get Euros in the taskbar of Excel 2000
RE: Need to scan xls files and identify if they use macros...wanna use
Make VBA open a browser window
Retrieving from text file
Hide Worksheets based on value from Access DB
Dynamic numbers in a static enviroment
RE: Need to scan xls files and identify if they use macros...wanna use
VBA Sorting question
Issues with Pivot Chart
Keeping number static in a dynamic enviorment
Selection Change Event
Aligning rows of data
Is is possible to set a border NOT on the edge of a cell?
write array to range
FormulaR1C1 error on a SUMIF
Delete sheets on exit
How do I convert 5.35 to 5:35 in excel?
If - Then synthax
No characters ???
Excel 2000 data export is missing lines, adds horizontal cells
Quick question..:P (Row range)
Select a Row where the cursor is active
Recording macros....record cursor movement not cell address?
Defining Constants from info in workbook
Range - Offset (Major help needed)
Positioning Oval
Cell address in a given selection range.
Separating
How to access a Radio Button in Frame in Excel?
Queries, Protection, and calculations.
Last needed info (validation)
[hlp]: How to copy a sheet to new wkbook and close the var at the end
How do you refer to empty cells in coding?
vlookup in a text box
Lock Certain Cells that Meet Certain Certeria
Missing something in my code...
Timer to close workbook when no activity detected
Extracting data from read only EXCEL files
programmatic access to visual basic project is not trusted
Pasting Between Workbooks
How to get Word Header Text into Excel VBA
copy a command button to new worksheet
Replacing UDFs with their value
Annual calendar formated
Conditional formatting: NEED ANSWERS FAST!!!
apply default "summarize by" for each pivot table field
How do you edit macros outside of Excel?
Rows Insertion
Delete all sheets except the active one...?
excel tip incomplete
MULTI VLOOKUP error #N/A
Employee Schedule
get range from excel sheet of separate columns using c#
Proper Case in Function
How to kill excel from visual basic
NETWORKDAYS function?
excel 2000 xml conversion
replace formula references with previous sheet names
Web Query
Re: Using command button to return numerical value from worksheet
Unprotect does not work
Customizing "sort" macro
Calculating number of occurences based on dates
compile error?
Copying Data Between Two Spreadsheets
CheckDate and return to usrfrm
Shared Workbook - how to disconnect the pop-up...
Last Modified Date help...
Code to insert functions not working anymore
Comparison Operators
"Asin" doesn't work in VB for Excel macros
Array - Object required???
Array - Object required???
Formula needed - automatically calculate session time totals for each user
Create a drop-down list from a range of cells
about usename
Insert rows macro
MessageBox and then return to usrForm
pivot tables
Adjust Audio Volume
Having problems writing macro in Excel
on open, always display sheet1
Show all workbooks open
Cannot create instance of C# COM server compile with VS 2005
Help VLOOKUP function
Re: Application.visible........
screen updating
Sum the greatest run of negative numbers
Re: pivot tables & offline data access
type mixturte in ByReference argument
Problem with Excel VBA script, decimal bug
Macro to Save As with filename based on cell contents.
color on text in a cell
Macro and VB development
Correct Procedure to Open Help File?
Excel window closed but process still running
Conflict with Workbooks
error message
Help button
I must be tired, because basic Math isn't working.....
Macro to clear all images?
speech feature in excel
how to select cell range with form?
Need a simple printing macro code
EN EXCEL NO PUEDO COPIAR HACIA ABAJO UNA CELDA CON BUSCARV
Completely Erase ListBox
Open another workbook and then some.... from another Workbook !!
Schedule a macro with user defined settings
Test for open workbook
Application.Volatile Question, HelP!!!
Charting
Create new workbook when 00 sheets are reached
Can time be measured to milliseconds?
How to create un combo box on a cell
reference to sheets
Count NonBlank Cells
Pass variables from Worksheet_Calculate sub to Module
Refer to Unknown File Name
Replace Existing File
Search by columns or by rows
Refresh Query based on variable
Check part of cell for data
Re: Resize array based on number of 'used' elements
Excel Pivot Table Virtual Memory
Macro question
count based on two conditions
Drop down population...
Drop down population...
repetitive text imports
Command Buttons
Combo Box ListRows property; changing programmatically
Tab Order skips over two fields in UserForm
Select one cell below active cell
how to find the last line?
Detecting worksheet change from modeless userform
copy macros to another tab
On Action?
Act if spell check box occurs
Thanks to the Group!!!
Re: Insert picture when cell changes
Worksheet_Change slow
Pivot Table Automatic Grouping
Saving the Active Workbook
Can VBA tell a user a macro is running until it ends?
for DS et al. : linking workbooks and cells
Re: Collections problem
How do I create a custom image for a toolbar?
Re: Finding Unique Entries Among Two Columns
Dropdown to populate next blank cell
RE: Collections problem
Re: No macros but still Excel displaying messages everytime I open
RE: Finding Unique Entries Among Two Columns
Set other workbooks while writing to ThisWorkbook
Floating Drawing Object
Consolidating entries question for excel/access
Overwriting text files
How to check if a cell is part of a series of cells (not a neat ra
RE: hiding rows
referring to workbook
RE: referring to workbook
RE: Creating Color Row "Control Panel"
RE: No macros but still Excel displaying messages everytime I open Exc
RE: referring to workbook
RE: worksheet_Change with Formulas
RE: How to check if a cell is part of a series of cells (not a neat ra
Textbox Validation not retaining focus
Conditional Formatting -- Apply to Row if Cell Value does not Matc
Re: Macro to move files from one directory to another
Re: 'Do Until...' Restart
if cell contains string then make cell next to it equals "X"
Save as web page formatting question
Textboxes in Excel 2007 Beta 2 Macros
Custom error-message for MatchRequired ComboBox
SpinButton_Change when Date
array within array
Widening the names drop-down, revisited
Displaying a User Form
Changing Range & Cell refs.
Looop through many sheets
multi dim array?
Head against a brick wall !!
FileDateTime function - how to make it authomatic?
please help, ned urgent
IF function message too big for cell - automate reply?
copy nonblank rows from many worksheets and paste them onto one worksheet
2 vba join together
Conditional Formatting in For:Next loop - won't work!!!
MSFlexGrid RemoveItem
Need desperate help: microsofts macro for converting large text files more than 65000 rows
Defining the length of an array variably
VBA sum - doesn't work with only one value.
Entering date depending on another cell being populated
access [contextual||context||right-click] [menu||commandbar] of ch
UserForm
Out of Subscript error while opening a Userform
Counting textboxes
Shared Workbook - Saving problem
looping and naming
Progress Bar/worksheet
Improve macro help
Send out email if
Can you shorten these macros?
search value as part of a cell value
Status Bar
How to disable save message when I click the cross to close the file
Checking empty cells
Figuring out hyperlink in a cell with a macro in VBA
Remove a cell from a multiple selection
Goto first or last sheet
Passing Constant Arguments to custom Subroutine & Functions
How to open many excel files efficiently
Can I access the "Windows in Taskbar" checkbox within a macro?
Sorting problem in a macro
How can I look for a sub-string within a string in VBA and...
Remove Entire subtotal row will be deleted
DragDrop onto a selected range
Macro_Pivot table_Cum%
Option Button on sheet changes size in 1024 by 768 resolution
Copy from one sheet in a workbook to another sheet in another work
Should be simple
Which columns AutoFilter is on.
Which columns AutoFilter is on.
Which columns AutoFilter is on.
Which columns AutoFilter is on.
Range Select with ActiveCell and Offset property
Dynamically set the value for Field in auto filter
Filtering
Can excel automatically send e-mail when particular cell is change
Macros question
Comparing current time to a particular cell
Deleting Empty Rows
Merge cells
Userform Checkbox
copy entire row, not just cell in row
Set variable sort range based on found text
Copying data to from one file to another file
Color Row Macro Problem, adapted from Patrick Malloy macro
copying folder contents
Communicating with Excel from another program
Excel 2003 SP2 Task Pane Disabling Does Not Work
Message
Protecting Cells
Copy a sheet in one workbook to another workbook in VBA
Removing blank rows
changing a cell reference
changing a cell reference
Hiding rows
Addins - Calling an addin function from within VBA code
Expert Required
display file open box
aout open no workeee
Changing combobox properties
ADO connection with workgroup Access database
Advance "paste to" cell by row to create a list
defined name
Can this be done???
Use shape location to clear cells
Breaking a workbook into multiple books
invoking a add-in with an if statement
repost: clickable graphs (hyperlinked) used to update source data? maybe an activeX?
Fill formuls plus one
do loop problem
Excel 2007 macro recorder
Rename files with variable names
File list
VB Code works in 2000, but not 2003
List box query
Making an Excel form (with a macro) Blackberry friendly
list of mail in BBC from excel
Excel Sheet Compacting?
Importing new data
Limits on opening Excel Workbooks
Excel to SQL
I am missing something (hide / unhide rows with buttons)
combination
inserting Rows
Requesting user input for a number?
Finding Sets - Difficult one !
format listbox
Reference problems
Do not Update On Open
Validation in userform
Need to know what is wrong with this 3 line code (row hiding with conditional formati
Need to open the Function Arguments window from VBA for a user defined function.
Referring to multiple ranges
Macro based on command button location?
Macro based on command button location?
Placing Cursor in a Cell
Better lookup code?
help with list boxes needed!
Making charts
number sequence generator
Locking the excel running the macro
Name each Worksheet with a name?
cells from another workbook
How to program a macro to hide rows with conditionnal formating
Userform: looking for and deleting character
ADD IN help
programically refresh pivot chart formatting
conversion
Excel 2007
Change properties of a combobox with VBA
Filter function - exact match...
Tricky Date Calculation
Extracting Text to Separate Textboxes
How to search fields and then add to value of cell using vlookup or ?
Range
help needed with excel programming!!!
Charts in VB
Check for Sheet Password Protected, Unprotect with multiple passwo
multiply 2 listboxes and put the answer in a textbox
paste special
Building automatic E-mail alerts or reports based on conditional a
Need macro to remove blank rows
Standardizing Page Set Up for Muliple Sheets
Closing Workbooks
SOMEONE MUST KNOW!!... keepItCool?? Tom?? Dave??
VBA image control
Delete a module with VBA
VB Editor
Looper Blooper
Counting character in textbox in userform
Simple Copy/Paste from one workbook to another workbook
A One-liner
complicated calculations
Importing on certain rows from a text file into excel
Wrap in merged cells
MACRO every 2nd Coulm want delete in selection
comparing data
Problem in User Forms
AJAX combo box in excel
protecting cells against editing by copy/paste actions
Excel VBA procedures running at erratic speeds
Object required, fault 'No 424'
Nested For..Next Qn.
Prevent code in "Sheet Activate" from running when sheet made visible from other macr
How to get All the Cell names using C++ and MFC
Automatically solving for X or Y intercept on a log or exponential graph.
New try, Help needed
Calendar Control
Perform Cell Value Find across ALL Sheets
Only opening a workbook by User Name or Machine Name???
Lotto number search
Copying new activesheet after other activesheet is hidden?
Printing Query
Using a macro and/or button to open the VBE
setup new user in outlook
SaveAs File Path Method
Runs in macro but not in procedure...why?
Subtotal command behaves differently 97 -> 2003
Help with code please
How can I change range name definitions as the No. of rows change.
how to specify only if 3 characters or less
conversion of text to numeric
Code to Create a new WorkSheet
Arrange sheet in specific order with VBA
Arrange sheet in specific order
macro to export a range to a text file?
Concantenated SUM() problem
computer_name
Can a conditional formula display it's results on a new row?
OLAP Offline Cube - How Many Multiple Concurrent Users
Freeze titles (Figer les volets)
Does excel VBA programme has a size limit? Or some other problems caused this problem?
custom function - return range
ScreenUpdating and making Sheets Visible - flicker?
Calling Functions in .Net wrapped DLL
Subtotalling
Format Cells Dialog
Sorting specific data from one sheet to another
Number formate of Integer
A visual basic value copy BUG?? - accounting format has copy problem!!
Rename a workbook to an automated name (i.e. date) with a macro
Finding when there are no directdependents
displaying formula results in different cell.
Problem: error on numeric
commandbars in add-in
How to create many txt files from a Excel file ?
stop copy highlight without clearing clipboard
Change Name on Worksheet Tab
"Always trust macros.." checkbox grayed out in Excel
Many Nested loops
Populate a form with data from a range
Advanced Searching
find and paste Blocks
More Find/REplace from table questions...
Filtering and user input
Splitting up address
Macro to copy data from one workbook to another
Find/REplace from table questions...
multiple hyperlinks: Help
multiple hyperlinks: Help
Find/REplace from table questions...
CreateObject setup
IF statement to activate worksheet & select Range
copy paste codes
Macro Distribution
Worksheet_Activate event question
Please help me refer to a fixed value.
Can I run two macros in the same time?
Can I run two macros in the same time?
Copy cell value to new worksheet, based on find results
Can I run two macros in the same time?
Run two macros in the same time.
Textbox Format
Font sizes changes erratically
Wildcards in VBA
Translation of VBA from PC to MAC
Determine if Named Range exists in Worksheet
Removing Gridlines in excel, from another application
SQL Query Destination as an array varable
How to increase the Width of the Task Pane (2003 & 2007)?
Copying Array from Word VBA to Excel
Bug - Add OLE Object to Worksheet crashes out Excel 2002 SP3
Equivalent to Template Wizard for Excel 2003
Active X component can't create object error
can I use checkbox thus I could calculate the value in a sheet
Find lowest missing integer in a column
mandatory cells only if another cell is filled
Retrieve data from unopened workbook
Getting embeded Excel worksheets with macros in Word to work
activeworkbook counting
math
X-axis variable reference
Using worksheet_change to change value of target cell??
Date not formatting properly
spill
"Start a new group" coding possible for a commandbar (floating toolbar)?
VBA Code For OR-Function Using Cell Property
please help me with my looping of copy worksheets
Cell formatting based on date when value was last modified...?
Compile error
making new worksheets
selection to color cell if the word promise is in cell
list of commands
How to copy an array without changing relative cell references?
How to copy an array without changing relative cell references?
How to copy an array without changing relative cell refferences?
rearranging data
Is there a quick way to find sub references in code?
Stopping the Macro Warning Message
length of an array
VBA Error "Type Mismatch"
Finding all instances of ALT-ENTER on worksheet
Allow E-mail from Poster -- Groups Question
Add macro with macro
CapsLock NumLock
Complex Numbers in Excel?
Re: YOU WANT KNOWLEDGE AS WELL AS END ONLY 4,- EUR >> OVER 400,000 EURS BECOMING?
Hide specific sheets on closing file
Msflexgrid Coldata
Protect row
Macro Help – Extracting multiple entries from cell
trimming cell contents?
Vb Code
New to Group Need If Then help
How can I get the name of the Pivot Table using Macros
refering to address
Setting the BackColor of a Static Window !!
sorting out data based on 3 alpha characters followed by a comma
Absolute reference in VBA
Check if folder exists, if yes just copy sheet in to folder?
Count number of textboxes
Bug, multiple selection of shapes
RangeFromPoint ... on a chartsheet ?
Desktop shortcut
saving multiple sheets into one csv file
"Show all" filtered rows
Print PivotTable - Page fields
any good reference material out there?
array
checkbox
TextBox
about save or save as
Change the default respond in method DIsplayAlert
How to assign keyboard shortcut to existing Commandbar controls
Upper case in textbox
Adding sheet
Macro to format a sheet
Can I put Multipage control on workseet
Copying sheets to a mastersheet Help needed
Calculating parts costs rounded to the nearest $15 in Excell
Autofill Forumal Down Column
Check to see if date is = to Sunday
Check to see if date is = to Sunday
Check to see if date is = to Sunday
InsertRowsAndFillFormulas
autosorting protected data with macros
importing files from a directory
how do i find my threads
Outlook Voting button
adding content to a table by filling a sheet
Open files from Combo box
Data type to hold decimals
Record Data at Time Intervals
Adodb with MSXML, no results
Tricky one ( variant type text to be unaffected by a minus)
ontime error
Replace text in specific column
deleting the apostrophe
times of opened
limited usage
copy to netprinter
Menubar to Sort
Using Autofilter with User Input
Connect a COM AddIn from VBA Code
Excel 2003 Calculate Event
MACRO for Deleting every 2nd ROW
Prevent anti-aliasing in Image Control
coding tech
Excel Database Question
Auto hide sheets
Launch a wookbook when excel opens.
Find and return data based on a range
listbox
Run-time error using late binding
macro to delete rows?
How do I control Auto Filter in VBA
out of memory problem! what to do for large matrix operations?
DateAdd
Cell designation
Frame from Control Toolbox?!
Running an add-in recursively on embedded files
countbycolor counts all cells in a merged cell
public const availability?
Excel Looping code....
Comparing 2 Spreadsheets
Need Companion Code
Excel macro
Setting Names from a workbook to a value in a Macro
Textformat with mouse-over in userform
Move contents of selected cell down one, and to the left one cell?
how do i make macro program on excell for create new txt file?
Worksheet events problem
popup box title name
Please add this in excel 2007 if not I am stuck with 2003
My CommentBox is Visible Afterwards
Chinese in VBA
countif
reduce public variables
How do I
how to stop running vba code without loosing printed data on the sheet?
TextBox value
Run Macro in other computer
Delete rows that cell value is "No"
Running a macro based on combo box value
Use of "application"
Create Chart from highlighted rows
excel webbrowser
Password to access code
Binary file reads in User type incorrectly
Dynamic XY Chart no working
Code to Exit Excel
Worksheet just disappeared
Problem passing a large safearray to Excel
Copy Excel 2003 "status bar" sum to cell?
Macro/VBA to delete rows in Spreadsheet
Programmatically pasting a Function locks macro
How to make userform disappear while called subroutine is running
Problem with function creation
SOLVER in VBA
Re: Chart does not work
Sheet reference in VBA
Save as JPG or PNG
find text similar to yyyy-mm-dd in string
Save over files.
Activating 2 textboxes for scrollbars
Can't test Range for Nothing
Advanced Filter VB Script for Variable Criteria Range
Saving w/s in new w/b as w/s name???
Change Row Color Based on Cell Value in Col A and B
Code in userform/worksheet vs. in Module
Copy text to the Text Box
solver constaints not satisfied
Same code - errors on different machine?
Data Input
Print Marco with a Combo Box
Creating Macro to edit cell
How to stop Excel remembering/loading macro from previously opened Workbook
Copying from sheet to txt-file
Excel 2007 Beta 2 - Macro Run-time error '424' Object required
hyper links in pull down menus
Inefficient macro won't complete
Combo Box, deleting rows
output data from excel into text file using vba
Error: The text string you entered is too long.
export to csv file (comma problem)
Application . filesearch doesn't work
NEED HELP: For this Code
Excel VBA Macro Running DOS Application !!
Advanced Filter vs. Macro for deleting dup rows in sheet
removing "do you want to save..."
Colour of Progress Bar in Excel 2002
Determining Yield
Background of Header
Is it possible to set up default Footer settings??