Excel Programming [Archive] - Page 36

Acronym Macro 2
Using code to edit macros
Assign Macro to a Menu Item using code
Assigning to an array
Problem with if statement
Spreadsheet Component not setting focus
Macro on a Pivot Table run on changing data
Lock Date Format
Using Solver with Linear Constraint(s)
SHow Hide COlumns based on cell value
Automatically insert code into worksheet via macro
autofiltering question and possible logic question
Macro to Create a new row if a column contains text
Copy data question
msgBox problem
Upgrading to excel 2007
Need to modify code
Excel Macro Prompting
Good references for programming with Excel/VBA
If Sheet Name, No Action
Help Writing A Macro in Excel
Help with text function
Tools - References
Macro Script
PLEASE CAN ANY BODY HELP
Removing named cells
Can Excel 2007 Templates Project run in Excel 2003
Workbook.activate acts dif when activewindow.caption changed
Check box driven order form
How do I update a template wizard form to Excel 2007?
Stock prices into excel
Populate multi-column list in worksheet not in a UserForm
Worbook.Activate Activates sht 1 even though this was'nt active sh
Excel list box or combo box - filled with data from SQL query
Lookup Macro
Sr Software Engineer/OLAP Product Architect
How do I concantenate two columns for the length of a table?
Looping Macro
Advice & Error Trapping
Export a menu
Controlling Excel From Access
RE: Please help...
VB - With protected sheet
How to Remove Macro from SaveAs file
what's there in blank cell when data is exported to excel frm db
Please help...
Help with simple 1-D motion simulation
Using Foxpro from within Excel
annoying subscript out of range error
Run a subroutine from a worksheet without button, menu, or shortcut key…
outlook from excel
Excel crashes when I open the file, except.....
Sort an access database, remove duplicates
if more than 2 decimal places
Re: Work sheet hangs - help appreciated
Work sheet hangs - help appreciated
Remove a row if data is bold
Remove last character from all data
Pop up in excel
conditional formatting a row
code to replace advanced auto filter
Branching in IE via XL Macro: pt I
RE: fill a web form from excel vba
Excel Crash in procedure.
macro for closing all Excel processes visible in TaskManager
Can excel service be used to show and save data in Database like SQLserver?
Distinguishing what is causing close
How to read data from a spreadshet without opening it?
Auto import of data into excel
Simple looping question
Selecting header rows with macro.
Adam.. Where are you? You need to get back to the institution.
Loop Macro
Customizing the Ribbon UI with Office Open XML Formats Files
if iserror then value = zero problem
Range.Formula breaks Worksheetfunction.CountA
Copying a Row in a sheet based on criteria in another
What is the Correct Data Type?
Please help - Spin Button
Count Visible Cells when using Filters
Select File to Open
Code very slow
RE: How to reference a constant?
Assign shortcut key to existing Excel Macro
macro - small change
how do you skip empty cells or zeros when calculating the average
list box
how to hide "title-bar" in Excel?
Can this code be speeded up?
Sort Selected Cell References
Signing a Code that uses a Custom XLA file (Location problem)
Copy Non-Colored Cells to a New Sheet
Macros
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY
define a range that equals the first row of another range
.cells question
HOW TO CHECK FILE IS SAVED
String to Rounded Integer
Copy/Paste Using 2000
How to clean a worksheet
Excel 2007 Crashes a LOT
VBProj.VBComponents
need advice on whether or not to use macro
What is compiling and should I do it?
Problems with Macros created in PC run in Mac
Getting around 255 Column limit
Opening file in VBA with Questions
Excel 2007 - Can Macros be added to the Quick Access Toolbar
application.volatile
Macro to find last row with Data, avg last 30, show result on row
If file exists then
Can you store a value in different levels of a multi array?
Re: Size of filtered list
Re: Dynamic variable in formula ?
Warning Message
Create a help file into VBA
Selecting Till last row
borders in VBScript
Re: how to group time field in pivot table
Macro to control two workbook
unmerge with macro
Formatting autoshapes using built in excel formats
Lost Enable Automatic Refresh in Excel 2007
Last Row…./ last cell
workbook open - microsoft solution - current user vs other users
Saving to a USB drive
Source Formatting
Extracting chart title from Embedded Excel Chart in PowerPoint
Extracting Excel.Chart title from Embedded Excel Chart in PowerPoi
Store code outside the workbook, is it possible?
How to size rows and columns in pixels rather than units
unprotect 1st sheet in every workbook in a folder and change month inS1 & year in T1 & rename all workbooks
HOW TO EMAIL FILE LINK BY MACRO
Module / Sub as string
workbook error - please help
filter criteria
Prevent saving on specified location
automatic close of pages
Web Query
Variables to be use by different Sub
Little help please please!!!
automatically creating new xls pages
Re: i've seen this before here yet the macro is hard to search
Re: Colour functions on Chip's page
setting cell values in another worksheet?
Modeless form keeps taking 'focus'
Select a column from a matrix
query
Help with Resize
Picture Insert Security
subtotal worksheet based on criteria
macro to select match results
Macro Problem
Vlookup code problem
Special Char in footer ?
SUMPRODUCT question
Call Excel in VBA
Sendmail works one computer, not another
Error 28 out of stack space
Chart - Variable Series Collection
print preview do not update (?)
Check if cell value is between two numbers
excel not finding spaces in email addresses when searching
Removing border around Check box
simple yet complex scenario - goal seek problem
Prevent Errors When Using Links
Check if workbook is open...
Commandbutton captions
returning an array from a function
Moving within a form
RE: Calculating number of days off
RE: Calculating number of days off
Working with protected files...
Message when opening a sheet
Error - Need assistance Please - Object doesn't support thisproperty...
Excel 2003 Finding External Workbook links using VBA
RE: Vlookup help, please
Trying to search an Array of Strings
Cell and Worksheet Location
Re: active cell - get me back there
Open Word Document using VBA in Excel
RE: Excel VB - copying formatted dates programatically
Re: UDF Naming
Programmatically adding checkbox and attaching event handlers
Re: Is it possible to link the cell in excel to the size of the shape
Re: How to track object index in object collection
RE: Inserting rows incrementally using a macros button
I need help sorting a table
Range Find
Array of Range Objects
Conditional Formating
Range, select, and printing arrays
Excel - Access Integration
Linking Files - copy a worksheet to a new workbook
linking files-update a cell in several workbooks
Clear borders macro not working in Excel 2007 but works fine in 20
Missing my macro book
Check whether a sheet is present in a workbook
Speeding up updating records using ADO
I'm getting crazy
close a file ater opening with GetOpenFileName
Use of Proper Case
Save records from one file into seperate other files.
VBA Converter for Excel 2007
Sending mail CDO from Excel 2007 on Vista
SUMPRODUCT with filter
Auto_Open, Expiry Date of VBA application.
zoom in on range
Turn off "Printing.." message
Frame
onCHange event
Change date formula to Value
sumif vs dsum
Can I save detail reports in different sort sequences?
SaveAs Copying Macro to New File
Sheet protected - user cannot interact
counting spercific charaters in selected cells
COUNTIFS function ?
Search Columns for Most Recent Date
Using Speach
Making two pie charts look alike
Do Event to stop concatenate Next statement running
how not to go on Loop
vba project properties via code
Network share problem
Divide Use column headings - Indirect?
Wscript and stored procedure
COUNTIFS function not supported in Excel 2003
Excel2000: Is it possible to run a pass-through query from Excel
Problems with Hlookup
Stripping characters from strings and writing contents to another
Question about Comments
Login
Cancel = True
conditional validation
number format change
VBA in Excel
Data entry help
Can't change the size of the plot area
Summary Page code help
Save worksheets to files automatically
getting error with empty listbox
popup userform for b/days
create a global digital signature for free?
digital signature
print preview in loop
Data not populating
Trying to get My Computer / Search results into a worksheet
Pivot Table, Subtotal, CalculatedItem
How do I do an Analysis of Means computation using Excel?
Position of Comment
Conditional Formatting
Create a animated logo
date entry in userform textbox
copy and paste
Format Conditions Formula1
Help with formula
Trouble cutting a range of cells
Parameter Pasing ?
Programming a chart object
GetSaveAsFilename Troubles
Stop Search ----> Ron de Bruin RDB_Filter_Data
Saving worksheets
failure in sheet with macro
After Save
Ultimate Control
Populate combo box, then hide rows that don't match chosen value
Data Validation and VBA
opening text file as a .xls file and not a .xlsx
How to perform SQL INSERT from vbs script
How to use ADOX on Excel? How to automate Excel invocation on existing xls file from vbs?
Formatting values in a form control. Is it possible?
Copy non blank cells from 1 sheet to multuiple sheets
Trapping blanks
How do I display all the filename in a folder in excel ?
File is corrupted after applying conditional formatting
hyperlink image for email
digital signature
userform popup with birthdays
empty listbox giving error
Pivot Table, Calculated Field
Get value of Option Button in Excel 2008 for Mac
Sum by month running balance
Add cc option to Send Mail + attachment
Data Validation - Propercase
Detecting an endless loop in the VB Editor
textbox validation with 3 conditions
move cursor to empty row ?
External Link to workbook
how to reference a changing 'last row' cell in a formula
How do I write a macro to increase the value of any cell by 1?
VBA SQL Statement not working
Find The Last Used Row
Ending a dll program
Find and FindNext
Create objet for InternetExplorer application
hi5
Format colum for number and next colum age
Hyperlink to show a userform
format colum for identity number and next colum age
mail merge
Cell Status Activates Macro
Pass Arguments to CDO_Mail_Auto
Goal Seek
Hiding macro-enabled password
BeforeClose event won't run when closing using macro
Extracting Web Data
code copy
Controlling Microsoft Project from Excel
Moving data from an array to a range when range consists of areas?
Expandable Rows
Print from PrintPreview macro method
Make Sheets VeryHidden With Code?
Combining two line of code
UDF: Roots of 1D Polynomials of Degree N and Real or Complex Coeff
display a calender that automatically shows today date
Macro to go to last row with values and average previous 30 values
How do I force a pivot column if there is no data?
Dropdown Lists and Funtions/Formulas
I can't get this to work
Run a Macro after 200 milliseconds for n times
run macro in multiple worksheets
Edit Cell's content into a larger box (Rich text box)
find out if a sheet is open by another user
Issues with time clock
HOW CAN I WRITE A CODE TO COMMANDBUTTON ADDED AT RUNTIME?
sql statement being run from vba excel
sum the column
Unhiding rows based on another cell value
Importing Data to Excel 2007 from Access 2007
unhide, Remove filter, Unfreeze help
Datatypes
VSTO using a document that relies on an XLA
Fill rows downwards with column names
Summing using column Heading
SEND FILE FOR UPDATE
Inserting rows
login username
Adding data to a closed sheet
Function won't update a cell
MISSING: ReportBuilderAddIn 1.0 Type Library
Import CSV file
Show full text?
Hide rows with zero's on several sheets within a workbook
Exiting a select case group
Dynamic drop-down menus with PivotCharts
login username
How to get Tree View Structure for Huge Data
Simple Checkbox
Changing linked formula
Apply security
For Excel 2007 copy visible cell only is only thru for few number
using cell value to open file
linking data to specified fields
Acronym Macro
Linked data
put cell valve in a text box
Modifying Ron's codes
Web Query Stopped Working
Copy selected range along with filters
Re: ReadOnly TextBox from ControlSource
ReadOnly TextBox from ControlSource
Read a cell value without opening the file.
Change file to read only
Building SQL-string with vba
column width and row height formatting, & IF
Add Button at Run-time in Code
Autofilling a formula down
Copy a range of cells 15 rows down and repeat to empty cell
Removing Macros when saving a copy of excel file
Cell value in a test box
If statement result
Deleting ' in front of text in a cell
Copy select information from a workbook to a template
word to excel
convert A1 to R1C1 in VBA
match values in column against another column and move
Recover modules and forms from a damaged spreadsheet.
Accessing the PERSONAL.XLS without a macro ever recorded by user.
Formula problems
Create a hyperlink that emails the current worksheet
unhide rows based on data validation
export excel to EBCDIC fixed-width text file
Generating spaces in code
VBA Query
results of a macro function to appear in another ecxcell sheet?
Can you dimension an array in a way other than Variant?
Shell to use already open instance
Copy Worksheet with Named Ranges
Pivot table access - Connection
Enquiry for Ron de Bruin
deleting worksheets msg box
what is "Notify before state loss"
Compile directive for 2000 to ignore 2003 commands
Using a Macro to Open IE, then get the Source of an ID
determining the cutcopy range progamatically
Error Handle to Exit Loop on Blank Page
Rounding Off decimals to the lowest number
Excel VBA 2007 - Combo Box
Open compressed file
Excel crashes after printing via VBA
Need help evaluating cells in another workbook in macro
Create a table from raw data
map network drive
Error in Vlookup formula
Runtime Error 91 Object variable or With block variable not set.
Combobox Row Source
Error without activating worksheet
Math function...
Calculation on a range problem
SQL + INNER JOIN + ADO
sp3/cube error "database driver does not include the necessary cap
Printing
Summary worksheet
Any ideas on how to do this?
Shift Information
Autofilter causes drawing objects to disappear
LookUp Returning more than one rows
Irregular Shape
Email generated from Excel database
Macro not always when opened from shared drive
Copy visible cells only
Sort protected sheet
Make 1st word in cell bold after combining words from two cells
find duplicates and concatenate
dialog box validation
Find the other workbooks name
Create a hyperlink with concatenate and copy to a different workbo
Did FillDown break in 2007??
Excel won't calculate
Keep Original Sheets Font Format when Populating data into other sheet
Email using a macro
Installing Add-In problem
Load selection into an Array - VBA
can a workbook become corrupted by too many charts
Worksheets
Macro to compare, find match and copy between workbooks
NEED HELP ASAP using find function with a combo box
Macro attached to New Menu item on toolbar
Scrolling
Read only
Name conflicts.
View the table relationships in a database
Importing Data to Excel 2007 from Access 2007
Multiple instances of Excel
range, format, file size
Highlight cell
subtotal
how to know a caller at run-time
Multiple worksheets feeding into one worksheet, formulas won't wor
Checking if ranges are the same after Range.EntireColumn
Need help using nameranges to write to columns
Track Maximum occurences in Array
Code not working to move cursor down on Enter.
Conditional formatting - currency?
Bulk Unhide
Conditional Formatting
Reference sheet by number or name
Formula Analyser / Analyzer - Anyone written one?
Custom Format Time Code
TextBox Characters Method - Need Help
Count from A5 down to last used row - Not up
Using a formula to copy data from one worksheet to another
Force new Excel instance
Fixed and Relative Macro References
automatic names IDX,IDX1,IDX2... (Repost)
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry
FORMULA TO SUM ON CRITERIA
Help with vb Bot
XLA: User-Specific, Not Document-Specifie
Auto-Saving .XLA Code Changes?
Excel WorkbookBeforeClose ___ Documentation proof needed
Code too slow (looping find to match data)
Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered?
Excel Workbook Close Event__ Documentation Proof needed.
Excel Form/Label Won't Show
Email Generation
Closing Workbook in Office 2007
substring method for VBScript
union range
Take various screenshot using macro and save in disk
How do I create a User Defined Function using VBA in Excel 2007?
Calendar control
Save picture using VBA
how to use Application.VLookup on close sheet
FUNCTION in easyer format
Vlookup from close sheet via VBA
How to hide rows in a Workbook with multiple sheets with zero valu
Table formatting in C#
taking out all \/?*[] so input can be name of worksheet
Test an array to see if it is populated without an error
Little help on Autofill please
What is wrong with this code?!?
Macro to copy a cell contains formula to a range
simple code, for each
Displaying data from multiple spreadsheets into one spreadsheet.
Add ins vs. Templates
Macro to concat row
Add-in used by more than one user
Suppressing screen flicker when sheet is activated
Inserting an image into Excel from FTP - occasional 1004 runtimeerror
Conditions in a macro
Track Max of Matches across 2 columns in 2D Array
Time Clock - Making sure they clock out
Special average calculation
Problem setting BorderArround LineStyle:=xlLineStyleNone
error in macro (next related i think)
Password to Unhide VeryHidden Sheets
Copy text from embedded Word object?
Marker Transparency
hyperlink in a PDF
Adding Menu Items to excel 2007
Pivot table or array formula
Freezing a cell value
RETURN NAME OF WORKBOOK
Supressing warning about too many data points in a chart series.
Norman Jones
Keeping Variables Alive
modify macro-- .columns()
Creating Index
Displaying Comments in separate worksheet
Looking for specific text Value in cell
Urgent help with input box & loop
blank space
Does Anyone Have a Excel Writeback Cube Sample?
Regex Pattern to extract Sheet Name from .Address(external:=True)
Showing sheet name of dependent
Row Heading to follow on all pages
Macro not running properly when shortcut is used
Shorting code
filter list combo box move
Command Button Dependent on Cell/Range Value
Copy / Past problem.
NAME# Error in 2003 excel.....PLZ ADVICE..............
HOW TO CHANGE DRIVE ADDRESS IN MACRO
code for conditional validation to textboxes
date code
XML esporting
Value and result in one cell - impossible?
how to open excel zip file useing vba
file size makes no sense!
Need Loop Optimization Assistance
2 Most recent files
calling for help again for xls 2003
Renaming a copied sheet programatically
Display the Browse for Folder Dialog
VisibleRange addresses to Array
Sumproduct from previously blank row
Copy chart from EXCEL into Word
worksheet number OutOfRange
Qery open and clos sheet
Best way to pass data between forms?
IF Function
AP Conditional Formatting
Step into in Excel 2003
Key Presses within a MsgBox
how to open xls._CRYPT file
Using JET Reports
Transpose range for drop down list
Remove hyperlinks
BeforePrint event - Jim Thomlinson / pwrichcreek
Inserting an image
Stopping screens from flashing using Screenupdating
Adding Forms to the taskbar?
vba dim statement with equals
Excel query then insert row
Excel Form: Can't format date in a Multi-column Listbox
Saving a macro to be available to all workbooks
Excel 5.0 print problem
conditional formating
MACRO IN EXCEL 2007 DOESN'T RUN
Adding a Worksheet and Renaming
Add-In Excel Locked Up
Help with Input Box.
User created Dialog Box
Spreading numbers from one cell to others
insert rows into Excel database
What does Address(external:=True) mean?
Excel Services on SharePoint / Windows Compute Cluster Server
Loop through cells to find dependents
Runtime Error in code
Changing Series for a chart
referenceing 'last row' in a cell formula
A Real Mystery
Select method of range class failed problem
Problem printing hidden rows
VBA code for Msgbox
Solver add-in
Digital Signitures, Creating / Obtaining?
formual help
Right click mouse menu in Page Break Preview mode
Inputting from message box
How to I Delete a Row if a Cell does not have a particular value?
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect?
Save selected cells to a Text file
CORRECTION NEEDED
Error trapping?
Macro To Sort and Seperate Data on Serpate sheets from a Master Li
fixed width import
Publish Spreadsheet to Web
Macro to show/hide rows based on a range of dates
Macro to add code to ThisWorkbook module
A way to Determine visible cells on the page
Code Module in Sheets Collection
send value in dialog box....
Understanding Resize Method
2003 to 2007 updates
SUM() of empty dynamic named range returns #N/A
Arrays/Redim/Help!
PLEASE CAN ANYBODY CORRECT THIS MACRO
Offset in for loop not working
How to correct formula error?
VBA to C# conversion.
Copy UserForm to new Workbook
Application.Calculate - Runtime Error
Late Binding
Visual Basic Chart Moving
Interpolating a list (range) of data?
Statistical Analysis
Shell function. Open Excel swtiches
Over write a file someone has left opened.
activate workbook
checking path
VBA Project
Insert 4 Columns If only 9 Columns
picture resize
QueryTables
control of pc speaker from VBA
VBA code to update row format
Automatic conversion
Generic Event Handler Hanging. Need help
Anything like STRUCT in VBA?
Allow VBA Program to use in Specific Computer
View Numbers in Textbox in Proper Format in UserForm
trigger worksheet activate event in another worksheet
Using a macro to make a list from results
Advanced Filter doesnt work in VB2007
Why does excel sometimes not ask to enable macros (medium security
insert into oracle commit
Find, cut, and paste entire row
Disable Optionbutton Control
Macro to Write and delete value in registry
Problem with Filesearch in Excel 2007
How do you find WHERE Excel splits your wrapped string?
Need text from embedded Word object
Works in Personal.xls but not in normal workbook?
broken links in excel 2003
change font color for row...
Two Macros to One
Not seeing cells as blank
Assigned macro in Dialog giving error
How to copy cells content only
updating links
No help for "Worksheet_BeforeDoubleClick"
UDF Macro Looping Issue Erroring out
VBA code for MsgBox
Different Payroll Formula Question
Printing an array of worksheets
ComboBox List - Invalid Argument????
How to find out when you are near the top of a worksheet
extend selected CurrentRegion results in application or objectdefined error 1004
Assign Macro to Command button by right click
Question for Jim Thomlinson or Ron de Bruin
Send email based on cell value
Need Help in VLOOKUP (second attempt)
How do I build automated currency exchange rate into Excelspreadsheet?
Use of checkboxes
preventing data entry if one cell's value smaller then zero
sheet formulas and strings
Hyperlink or Command Button?
How are Digital Certificates Stored and How Do I Manage Them?
spawn a vba program from with VBA
Sort list by selecting header cell?
Positioning Pictures in a Worksheet
Possible Data Type Issue
Multiple range selection and editing
How to insert VLOOKUP function in VBA?
defined error
validation for 10 text boxes
Tools > References...
Macro deleting row if duplicates found
Cell will not format with a color
VBA Function for Match and Offset
Help with a Time function or ... Something
How to create Macro that can build a Scenario PivotTable Report?
Chart Location - Only allowed New Sheet?
How to Reduce the size of VBA Program
Data imported into Excel from Access
function to return a "sub-range"
Loop in Auto filter
Macro Buttons
Copy Specific Data
mutipage and optionbuttons
Not able to send Mail - Ron de
NumberFormat syntax tutorial
Addin macro
MultiColumn ComboBox Display
Visible property for worksheets objects
Difficult Looping Macroâ€¦with AutoFilter
conditional copy macro
Another Problem with Regex Pattern
Check Box checking
How to obtain properties of graphical "line"
Help w/Duplicates & Macros
Where do I begin?
using find with a combo box
For Loop with headers
Export data to new workbook, maintaining formating and page setup
.xla information tab
What is wrong with this code ??
calender
Invalid procedure call trying to use FormatConditions
Form Problem
WinFax Pro and Printer Confusion
Excel VBA - Find value in external workbook, same folder
.XLA: Making it an AddIn vs adding a Reference?
Summing based on currency format of Cell
Preventing change of a cell value
Find x-y coordinates of cell?
Calculation of cell value with worksheet change event
Color Index
Data imported into Access from Access
custom function doesn't update value when source value changes
copy paste methods.....
Detailed formatting problem
Excel filter options
"Time Clock" Functions
Dates in a SQL Statement
How to format trendline as same color as series line in XL2007
Launch MS Visual Basic = Error in loading DLL
function that returns cell and or font color of another cell
Copy sheets to New Workbook - Excel 2007
how to find the data in between the sheets?
Macro using relative cell reference to set name for range
Nightmare with Arrays
using lists and bringing in info from another sheet.
validation textbox for numeric values
import =[test.xls]Sheet1!A1 - help
SEND MAIL TO DIFFERENT ADDRESS WITH DIFFERENT MESSAGE
How to make a dream living?
Another last row in column question - with a twist.
Conditional Formatting with VBA
Going through a string, a char at a time.
VBA Code for FIND values
xml import error
Long extract routine stops running
select a range between 2 words
Simple iteration problem. Help
new menu opens in all worksheets
error 9 - simple code
Importing a single cell from one .xls to another
Registry syntax to ensure that an addin is opened readonly ?
Consolidate (sum) last sheet (32) of all workbooks in a folder
Avoiding verbose code
Reading formatting from Word table in C#
How to retrieve the last selected cell before SelectionChange even
Vlookup
copy files by name patterns with wildcard
If cell value is the same
Create function to find a value in an array in seperate worksheet
Macro to move data
Name a New Workbook
Hide columns based on related cell
.XLA's Code Not Available?
Re: Copy Row
StopWatch Macros
Copy Row
Trying to create a spreadsheet with drop menus
Trying to change an Excel file to be database friendly
Huge Number of Formulas
Trying to change an Excel file to be database friendly
Create CubeFields with C#
Is it possible to loop through text?
WinDBPro. Ver 2.0
Save range as new worksheet
How to removed the Dased Line using VBA
Formula on Creating Unique Value (Similar to Select Distinct)
Cycling Through Page Fields
bob phillips, question bout conditional format white paper
saving using ip address
Update References To Absolute
Adding to arrays
is it possible for a drop down menu to select other drop down men
Correcting time input by users
cell range
VBA code for 5-rule Conditional Format
Macro
Command Button Click Help
For next doesn't loop
Colours not changing
Copy/Paste Macro; Loop is Misbehaving
Summing values... conditionally
Delete only the fourth character
Userform
Calling a Sub from Another Sheet
CHOOSE and External References
Macro to Add More Than One HTM File to an Email
Chart Picture Size in UserForm/Picture Control.
Condensing Format Code
VBA to VB6 DLL, interface split to support Excel 2000-2003, 2007
Execute code in a loop - Question
Barcode fonts with Add-In for Excel simplifies creation of multiplebarcodes
macro speeds
Open files with a variable name in a folder get name in B1 and sav
Displaying the Sub or Function Name
saving in CSV with a nonstandard list separator - possible bug or 'bydesign' quirkness ?
Connect to SQL Server
unload vs hide userforms
WEB Link
Counting text numbers
Sort Columns using lastrow
Why wont inserting a shape record in a macro?
Macro to disable Refresh Data option?
Excel 2007 VBA versus excel 2003
DELETE CELL OF ZERO VALUE
Macro code to proect and unprotect worksheets
Copy Selection to a Batch File
Save file with last month date on end
Last Row of Data
Naming variable range selected by cursor movement
microsoft.public.excel.programming (PAGE PROBLEM)
Executing dos command
Sample code
FileSystemObject Issues
ComboBox Will Not Advance To next Item in list
Getting list data into spreadseet
Dates - Days and months switching around
Prevent "[File] now available for editing" popup
Re: Get Workbook Object properties without opening Workbook?
Vanilla Ice in high-definition!!!
PrintPreview of multiple sheets under Excel 2007
Redim Preserve question
Chart Generation. Changing interior color.
Link Data to Excel Spreadsheet
Excel macros run out of memory in Windows Vista
SUM in VBA, Msgbox
Macro to be to split an amount based on it value and spread over aperiod (months)
For Each workbook in Folder A Copy Values & Format of each Sheet2...
Protected sheet: Automation error for validation
Send email in Lotus Notes
Hiding Rows-Macro or Autofilter
Plotting and selecting data
Lookup from Excel to Access
page set up
Macro to Paste Value and Link to Another Cell
Unable to set the FormulaArray property in Excel 97
Dynamically increment date for data import from another spreadshee
Macros and formatting disappear on save
move an object in active directory excel 2007 vba
intercepting the file | new command or the file | new menu choice
Need a Marco to find and delete an entire column based on text sea
extracting strings from cell
Reviewing Large IF statements - Any tools?
writing macros
Excel-Query-Access Question
Find problem
Use Row Number to find Cell value
FIND Macro
Hyperlink to a userform?
Count cells
VBA code for 5-rule Conditional Formating
Blank or Zero or None?
Automation error with validation object
Breaking Link to a Circular Reference with Macro
Visual Basic and Excel 2003 and 2007?
using the slope function with non contiguous cells
Using Error handling with the Find Method
help with Sorting
VBE is disabled
Text Boxes and Shared Documents
Attempting to copy multiple ranges from one worksheet to another
Adding 4 cells next to eachother and then adding the following fourcells
Needle in a haystack...searching for VBA code in all Excel sheets orfinding xls users of xla sheets....
worksheet selection
Re: How I write "if cell value =>1, copy entire row & paste at dest.
trying my first user form.....
Sum col with reference to criteria in other col
right click
Using a variable to select a cell on a worksheet..."Subscript out orrange"
How do I name an autoshape so that I can refer to it in a macro?
Is my VBA wrong???
Auto-Installing .XLA first time a spreadsheet is opened?
Running MS Access From Excel VBA: Communication Between Processes?
Grid Lines in Color-Filled cells
Create a floating tool bar.
database connection dsn vs. odc
Make an autocorrect entry italic
write date into file in YYYY.MM.DD format
Running a macro across a folder
Global Address Book Question
Pivot Table Code Fails
How to avoid being asked for a VBA password on workbook close?
SIMPLE msgbox Problem
Format Cells Dialog from a Macro
Wierd Problem Excel 97
Very EASY & SIMPLE VBA~!!! HELP msgbox
Excel UserForm to Collect Data for Access
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error
Network file attributes
RE: VBA CODE SOLVER TO RETURN VALUE
Copy and Paste from Internet Explorer
Workbook_Open Macro
ODBC in Excel 2007 to work in Excel 2003
All Possible Combinations
Conditional Formatting in Excel
Limiting Input Range using VBA
Need help with creating a caluclated pop up
Master xls to CSV
Consolidating Data from Multiple lines
Multiple users writing to one file.
performing calculations on time data
calendar control
VBA Email Macro Skipping code
Excel 2003 Add-In Automation
store active workbook
Changes to entries made through validation
Non-Intersect Function
show cell reference as text
Creating a link from one workbook to another
Pivot table vs formula
Display Custom Document Property
blank cells
sound
Selectable Column SUM
Events
Problems with Reg Pattern "[^"]\$[A-Z]*[0-9]"
How to distribute your macro?
insert data picker into range of cells
Display Worksheets from AddIn
How to keep format while pasting
Excel Query
columns
dynamic cell addressing in formulas
Macro on filtering pivot table (pivot fields) => debug
Re: Dilettante Question: VBA to VB.Net?
2 named cells
how to enter if formulas
Macro that will add multiple emails based on a range of cell values
Custom cell format
Convert xx:xx:xx to decimal value so can be summed.
Embedding Help
Managed Add In With Excel 2002
Loop
Office Automation
WinDBPro. Ver 2.0
Box Border in Header - Excel 2007
Problems with Processing Emails
copy cell B19:J19 Range dataâ€™s from sheet1, and to past in sheet2
Textbox validation
CheckBox
Trendline color format bug/issue?
RE: Determine which button was clicked on a sheet
Adding a new row in VB
What is the proper syntex for .cells or .range ?
Find / FindNext Trouble
VBA : Sumif on different workbooks! *********
Creating a Formula
Control-Break
Internationalization: Addin names
Unexpected result using Datediff
Re: Renaming pictures
CountIf in VBA
Re: Renaming pictures
Percentage of values in list
Customised Buttons
Delete part of cell value
Delete part of cell value
Windows API calls
Compare Differences in Blank Ranges across sheets
Re: how to test whether selected variable is within defined range
control the controls with a control
DOEVENT stops working??
How to set an arg list for my VBA functions
How can just opening & closing a workbook prompt the Save? dialog?
label captions
Problem Setting Range
insert rows in Multiple worksheet
Re: insert rows by vba
Replace file without being prompted to save
Array using 2 columns
setting Range from address
Input formula into a column via macro
Hide automation add-in functions
Sending a selection by email
NOT ABLE TO ENTER VB CODE
Loading Sheets into a Customer Collection
Conditional Formatting - Formula - Excel '97
RE: Excel Column "SET Filter to " in one column count in another
Validation for Textbox in Userform
Re: Change 'ENTER' key behaviour on different cells
Re: Change 'ENTER' key behaviour on different cells
Re: Change 'ENTER' key behaviour on different cells
C# 2005 Excel access to Axis (xlSecondary)
Macros and VB
getting macro installed in each new workbook
Check if shape exist
Re: VBA CODE SOLVER TO RETURN VALUE
Re: get number of service pack installed
RE: export visible rows only