Excel Programming [Archive] - Page 50

Web Queries
supress display during execution of an excel macro
Re: How can I remove leading zeros?
How can I remove leading zeros?
Beforesave - Save copy on my desktop
Popluating data from ms access
Delete variable # of rows depending on conditions
Restrict area where I can use button with macro
How to Set Focus a row - Option Button Click
Lookup Code
Conditional formatting
Use a Piece of Data for File Name
hide vba code
Access VBA outside of Excel
Accessing data stored in the worksheet (named range) in .xla file
Workbook contents disappear
Help! creating code for time to decimal calculations
Formulas not working
VBA6 cores when hitting Reset button on the VBA IDE
Adding New Workbook
FORM Drop Down issues
Clear data in a FORM row
Making calculations with times.
Workbooks.Open Fails
Variable coding
WorkBook Open & Right Before Close Subs Not being called
in vb, what is the 1-line code of assigning a macro using click
Button to change view location
Can not read file
Help. Converting word to PDF
Determine Workbook Mode
counting weeks and days between dates
Detect New Worksheet being added
Trouble with Sharing Addins
Sending data to excel
Workbook contents vanish
VBA access to call stack
LEFT(D2,3) but no spaces
Adding leading zeroes to selected alphanumeric cells
Copy specific range from files in folder => enhancements needed
Rename an Array
Re: How to zero out non-contiguous ranges
Application.Caller Problems
Absolute Reference to the Left Until Change in Row
Loop to specific rows
Excel creates massive files on calling vba workbook.save method
Date Query
Activating Javascript with excel Part 2
Input box to allow user to select column
RE: How to zero out non-contiguous ranges
linking data from text file on ftp server to excel file
Is there a formula that I can use that will give the row data?
How to select Cell address between Specified Range
Using DEC2BIN(range,6) in VBA Code
Slow Calculating and optimizing
Syntax problems
Sub to clear range above n below diagonal
Macro Question
Sub Vs. Function
Need thoughts on integration approach
Checking cells for value
displaying a information window on opening an excel file
Problems on XLSTART DLLs in Office 2003 SP3
Check overlap sunday/weekend
copy unique values to validation list
RE: Worksheet Calculate
Remove VBA code
Re: Hidden formulas.2
Re: Automating Excel Macros
Re: double click macros
RE: double click macros
Re: Writing hex numbers to a binary file
Highlight a row
RE: double click macros
Problems with Web Query
Re: double click macros
Browser Functions Problem
Office (Excel) 2007 & 2003
Please help with Loop
Calculation state
Please help me find veryhidden sheets
AutoFit - Merged Cells
Save Textbox "" value
EVALUATE Method and arguments
Object varaible or With block variable not set?
Finding the first blank cell in a row..in column "A"
Specify Image Location?
preserve last row while looking through a column of duplicate information
How do I Import a spreed sheet
macro save as delete original file
Can I "hide" the database login info?
Wrap Text Format
Close/Delete corrupt or open spreadsheet
Random Number Genarator
Show cell value based on list selection
VBA VLookup or equivalent
Form
Formatting Word Tables
Sort columns by color
How can I lock the header cell so it's not alphabetized?
count if and format ranges
Access to hidden sheets
Building a Phonebook
button macro
Printing with restrictions - VB
how do I get donor names to list by alphabet
What is the #define equivalent?
Redim with string input (MATLAB Zeros function)
Formula to capture Document Properties
how to copy first 2 characters only from prior cell
INVOLVED - I Suck With User Forms...
Datagrid-Flexgrid
Userform design - keyboard to move controls?
Help Files
command button on form to open sheets
Delete Rows based on cell values.
Detecting user cancel out of "File Open" input box
Using validation to move cells
Need help with For-Next block
Need Help Sorting
Data Transfer B/W Excel with Calculations
Displaying different worksheets based on user input
ADO connection Open failure
Determining row # of selected cell
combobox multiple columns
COUNTIF Query
Remove Modules
inconsistent excel execution of cell logic
Cell address of function call
Keep User Form Active
Need help in creating dynamic drop down list in userform
Interpreting some code in C
Displaying a Userform
sorting column order
Convert excel formulas from worksheets into standalone ie. databas
strange range access
sorting by Contract #'s
Simple Macro task driving inexperience user crazy
Last Cell
how to change 1 line of data to multiple rows
VST"A" with Excel
ADDIN TOOLS
Match two excel spread sheet using Macro
Workbook_Open not executing in Excel 2007
Pause Until Mouseclick?
need to stuff the array with the nth number of service groups
check for last day of month
Please help with my code
In Excel 2007 how to switch off macro with a macro
Refreshing External Data Ranges
how to fill an array with the nth number in a list
Text Property of the Range Object
Compare and Highlight Differences
vba code to show specified sheets in list box
Import binary file and convert to HEX data
show / hide chart data
How do I find all zip codes from the web?
The fastest way to count values in a range
need to add 24 rows to each service group
macro to add 24 rows to each group in column H
Macro to stop data entry errors
Making all past dates bold, looping
add xtra rows to before the subtotal rows.
printing list box in the user form
countif using multiple criteria
Vlookup in multiple sheets
Open wb from a wb and run a macro
Run-time error '1004'
File Exists 1
Determining if certain row # is blank
USERFORM CONTROL COPY: IS IT POSSIBLE?i
VBA To Calculate Across Monthly Worksheet
Using Excel VBA to run C function in DLL
Making Access Queries Static Data
OLE Link bug introduced in Excel 2003 SP3
Change cell reference type
Check Input for Valid Month
Quering a changing range SQL
list box based query
Java Script
Open all workbooks inside a folder, run macro and save them?
How to check for duplicate values within a column
userid in macro
BackgroundWorker and Excel
Sorting Backwards
Cannot close a workbook in VBA due to Run-Time error '1004'
Using a workbook name
Range or Array?
Saving file when path is unknown
Nth Day Of Week For A Month
Can macro return me to cell edit mode
Import data from a log file
XML schema edit
When I type an H in Excel, I need to to change to the colour red?
comparing text strings
Creating a macro that reformats data in excel
label control from macro
Functions for manipulating arrays
UserForms - how to return a value?
Colour Coded Shapes
Fine
efficiency
using text box or list boxes info for email distribution list
Indirect & Named Range
referencing a cell in a hidden sheet
Cummulative Totals
Worksheet-level event
Is Conditional Format met?
Run in small window?
Huge problem with comparing cells in different ranges and sheets
Hidden formulas
MultiPage Control
insert named cell in header
determine the name of the selected pivot table
Double-Click to Change Interoir Color
How to delete CONSECUTIVE duplicate Rows
Simple If statement encounter error
Very Simple Copy and Paste Sheet - Error
What is the Cause of this Error Q
Email button
Moving Average of Array : Can use built-in functions?
Additem problem
ARRAY QUERY
Worksheet events inactive
Getting Started with Excel Programming
Incrementing a string
A Property or Collection?
Operator is in excel cells, how to reference it
How to use operator in cells
Entering a value into a cell with a formula or by tying the value
Total number of cells
How to get the mouse scroll-wheel to work in Excel VBA IDE?
How to declare global variable in Excel VBA?
Color macro
Clear Blank Cells
Clear Blank cells
MultiTab userform question
Use of Tab key in a range
Copy and Remame Sheet in active Workbook
Use Keyboard with KeyDown and KeyUp
Worksheet_Change
Find a string in a column
Hiden sheet code - need access
How to return a value from a function?
Save copy on close ?
Cell Value
remove items from listbox together with add item
Application inputbox, Range versus Cancel
Apply macro
How do I set up a progm that allows entry of daily tips.Waitress
Change Cell contents
How to find the Day of week in a Month
Help with text length of cells
XValues series breaks on disjoint ranges - but works fine in Excel 2007
Writing array data to range object always writes 0's on worksheet
adding multiple spreadsheets onto one to sum up values
Pivot Table Data format
Track Changes
On Error Resume Next question
Chapter 5 professional Excel Development
How do I Automically add the file path to a new document?
Displaying A custom menu as a popup menu
Clear print preview dotted lines?
Change filename & auto_open
Formatting and data loss when migrating from Excel 2003 to 2007
clear cells containing specific values
printing to a computed column
Max Name Ranges Allowable in Excel 2003
Pass array of sheet names to subroutine
Copy and Past Macro
save textbox as number wth Cint?
Aligning buttons
Import Web Page
Type-ahead on multi-column combobox?
select listbox item
reference a cell within the header
Validation List
code is not selecting correct range
Pick value off sheet list for VBA code determination
Can't set Application.Interactive
Writing to windows directory in Vista
complex IF statement
Identify Last Cell and autofill last column
runtime error 1004
Multiple results for vlookup
Address Referencing
Assigning a macro to a picture
macro for arranging by Contract #
Code modification?
Copy a Module - Please Help me decipher the Pearson Code
Macro to log .xls file names
Macro to lock project from viewing
Format affects precision?
Change the worksheet tab name updates hyperlink on first page?
pivot cache in VBA
right-click cell menu only for specific range
Coding Formula
Pivot Table Macro
Excel Range of multiple columns
Protected Object
Automated Search and Replace; Sheet2 to Sheet1
VBA Code to Delete Part of Row with Data
password protect a macro on a command button
Array?
collapse conditional formatting?
Re: Issue with mail merge date field
VBA - array or collection literals?
Calculating Counter
Function breaker tool
Which one is most powerful for developing a Excel Application
Conditional Formatting
Re : Excel Hyperlink to Open an External File
range names in macros - syntax again
Using 'i' to calculate public variables
How do I code auto email alerts when a certificate expires?
Last Value in Column B Shifted Down & Value in Column A Shifted Do
Late Binding Problem between Excel and Project
Fin End of Used Range
calling a macro upon selecting a cell
Simple Excel VBA Question
Looping through different comboboxes in an excel sheet
Insert Row *below* button position - no need to copy formulas
New Tips Website For Excel
UDF's and Workbook events
how create pie chart reflecting data from multiple worksheets?
Macro doesn't work when sheet protected
Adding up unique numbers in a column
Text blocks and multiline textboxes
OpenText Method with "StartRow" as a variable
How can I enable hide functionality for a protected worksheet
StrComp numeric
Wild Card?
Save Textbox into Named Range
PasteSpecial Constant
Odd behavior of ActiveX ComboBox on worksheet
GetPivotData
Excel 2003 Macro in Excel 2000 Environment
calculate a correlation with ranges
Organizing the VBE
Finding the last one
GetWindowsDirectory in Vista
Find values over a certain amount
Evaluate IF(OR Statement
Excel code from 7 day data to 1 day data-pivot tables
If then statement
OK, I simplified my problem a bit, smart people sound off!!!!!
Validating checkboxes
Worksheet name with space problem
Round to nearest month
Importing an Excel file and prompting user for input
Shell Command read Range and Loop
Checkboxes are duplicated over and over as emf in the Temp folder
Refer to a specific element of a UDF created array in another UDF?
Advancing Cursor
Delete Data in Range -macro
Changing default menu item behavior
Avoiding a range in recalculation
Solution: Calculating Time Elapsed Between Two Dates
Delete multiple rows
How do I round a date?
Different results when running macro vs stepping into macro
ot- link to fixes in office 2003 sp3
time function
Znak ∑
Font size and rows height for whole sheet
Moving a Comment into a Cell - automaticlly
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet
Use Command Button from each Row to fill UserForm
closing form when pressing escape key
Border for range
Macro to Select
Excel / Access User Conference - Oct 24-26, St Loiuis
Character Limits within an Array?
.Display (One for Ron De Bruin maybe!!)
Shift+Del buffer
Auto Capitalization annoyance
FInd value and insert rows below
Passing a variable to UserForm_activate() event
Using .AutoFill with a CELLS() reference
Activating javascript with excel
VBE Coding tools
Inputbox used for password
Auto run a macro
Disable message box when trying to save a read only workbook
SQL
How can I detect that the user canceled a close?
Change color of an autoshape
HELP with Syntax please !
Excel automation: connecting to Excel
"How do I un/protect sheet by macro program with password
Creating a toolbar that works in Excel 2000 and 2007
Eliminating dupes in a single cell
Is This Possible?
real time read & write of excel spreadsheet on website
how to excel automation erase macro name..?
Default Formats
Conditional Formatting
run-time error 1004
Is this type of VBA Logic possible? Delete Unique Row
from a cell to my textbox
Is conditional format met in XL2007?
Re: Error - SendKeys in between a macro
Automating requery
Lookup function in VBA
Help with TEXTBOX control
Re: Concatenation prob
Newbie needs help
Code for deleting rows?
Need help by smart people!!!
if fill color = this, then increment this cell by one
How to refer to the specified sheet in the workbook?
How to create a UDF to return an array of values with input variab
Iseries - Transfer to
Insert Varying # Rows
Drop Down Lists
How do I get a complete list of all VB Functions
Want to change color based on Text, NOT using Conditional Formatin
Regular expressions
Conditional formatting in a programmed cell
how do i extract multiple data from a cell(string) whose length v.
addnew record automation
ListBox & TextBox Save
Programming a pivot table
Nulls in Pivot Tables
Help with solving
Toggle Between SheetVeryHidden and SheetVisible
Excel cores when trying to close a workbook after exporting+removing VBA modules
Copying select data frm one workbook to multiple workbooks & save
Odd Lookup Formula
Nested Do Until Loop
Removing with formula
Using worksheet_change
auto update text in cell b as date in cell a changes
macro cell add a comma
Converting WeekNumber to Weekday
Open csv file with all values as text
pivot table refresh
Data validation list type
Opening Hyperlinks
Arrays and deletion
Execute Worksheet_Change before recalculation
Replacing a module by coding in VBA
GOTOs
Automation in excel
format date
Interest Rate Help
Do I have superfluous code?
convert multicolumn/multirow table into two structured/formatted columns => feasible?
Find cell contents within a data matrix
Problems with Pasting Array contents in cells
Navigation
Reference for German Code
Help with insert a row
workbook level name vs worksheet level name
find entire string then row background red
Macro with input box to Select a column on active sheet
Compare Rows on different Worksheets and Output Difference's to other Worksheets.
Opening a Hyperlink using macros
VBA way to access of the cell being calculated?
closing workbooks
Sorting and graphing
finding first empty cell
Converting Hyperlink formulae to real hyperlink
Flickering screen while processing macro
Restrict Copy to Values only?
Text File Import - File Origin
Cell bg-color
if todays date is in the month of january, then specific drop down list, if feb, another list, etc
How do I Autosave a workbook to a webpage every minute while worki
File freezing - Trust access to Visual Basic Project setting
Error - SendKeys in between a macro
Custom properties to Sharepoint
Grouping function in VBA Excel
Change document properties
Saving Worksheets
Open "Find" Userform
Open "Find" Userform
FileSearch error 1004
Remove Item from Listbox by Item Name
PIvotitems visible
Need macro to add 100 years to a cell's date
External Reference Data Updates.
Print to PDF file in Excel or Access
Subtract 5 minutes from Now()
setting up blank lines in an excel 2003 pivot table
userform question
Here's one for the masters
Excel automation: Problem with inserting an array of formulas into a range
Excel phone number formula
Excel problems with macros
Frequent Crashes with User Forms
How can I insert a row in MS Excel using a formula?
Using VBA - create array - parse values - find differences
Changing For...Next index
Count?
Listbox Formating
Mammoth Insert Formula
VLookup Function in VB
Run time error 9
Opening .xls files
Converting Text to a hyperlink
Dynamic sorting and selection of data
VBA String Output adds Quotes when I cut and paste to Notepad
Add New AutoCalculate Function
Delete row
determine if value in pivot table
Checking which row is selected
sorting a changing range
Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
Excel 2007 - Using a Named Ranges in lieu of Cell References
To Do List
Pivot Tables - DisplayEmptyColumn question
F1 Help key in VBE problem...
removing #NA from the list
permutations/combinations
Unique data...!
Deleting Blank rows as a result of a formula
Copy a File 'n' Times, New Filenames are "File_n.xls"
Save only the code from a Sheet?
Delete Row 22 in all Sheets
Use loop to re-arrange:
Worksheet_Change Event problem in 2007
Spread macro
Help with known issue
If then, adding more choices
move offsetting values
Disable Right Click
Opening Hyperlink
Selection
Count if begins with AAA
Macro Using Cell Data for .Log name
vba
Coding needed for shaded cells
Save As
F2 Cells in a column
If Then Statement
No cancel on input
'BeforeClose' code problems:book won't close if more than one book is open
UsedRange and Ctrl-Shift-End Mystery
Need help using date as an index
seting a changing range to sort on 3 different sheets
data in a column
Scripting Dictionary to hold User Defined Type
data on top
File open - .xls not recognized as spreadsheet
appending series
Last day of the month
Hide rows if...
Formula for the last day of the month
Compare multiple column rows on different worksheets.
VBA 2007 -- How can I tell if the user cancelled a Save?
Automatic refresh macro
Call a file name from within string
vba coding
"... or one of its dependencies, was not found."
Excel app as web app
new version# when opening file
Histogram
caption of Triplestate buttons
solver add in / excel solver / vba
Extracting numbers from text string
Date Format
Re: Alignment of Figures
Re: Summing while hiding?!
Changing Chinese Font in Excel
Re: How do I display cell name with Msgbox?
Insert Concatenate formula in Cell
data validation with indirect ref to dynamic range
list box column widths
Testing if Commandbar exists
Looping thru multiple files to produce a consolidated summary by Code
Importing CSV just like Excel opening CSV
Combobox on Quick Access Toolbar
CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
Print preview creates problems in macro heavy reporting tool
Full proof UK postcode validation
Running Conditional If-then script off a command box
How do I Run Macro on Opening if user is not the "Last Saved By" U
How do I write code to "Workbook_Open" from within a VBA?
Macro to Paste at next blank row
Coding to remove and import Module
Generate list of numbers between start and end value
Multiple selection (range or individual) capability in a drop down list
Imported .csv file - illegible data
manipulating controls
Can you limit the amount typed in a cell in Excel 2003?
name validation
rename column header after filtering column results in the MS SQL
Multiple Search Criteria - One works other does not.
Re: How to Disable a special button
Macro - Share with Users on a shared network drive
Loop until finished
need help with nested for-next loops
Re: Command Bars - working with the built in buttons
Deleting Duplicate Rows
select range of cells in multiple colums automaticlly
Sheets("sheet1").Copy
Easy Syntax Question - refer to current row & column to pull a val
List Modules in a user form
Excel 2007 autoopen shift key doesn't work
match two excel spread sheet using macro
PageSetup changes not working in VBA
Looping thru multiple files to produce a consolidated summary by Cod
SetText Format in Excel sheet Cell
Enforcing worksheet Naming Conventions - Trapping Copy/Rename work
How do I stop 2nd row deletion
Can Outlook contact data be linked to an Excel Workbook cell?
Auto-correct macro or VBA
Password protect worksheets
Help on Macro
Re: Type Mismatch Error
Re: What happen when a row is hidden?
Modified McCauley Duration From VBA?
Re: Filtering on String Length
Macro to Unlock All Protected Worksheets
RE: Filtering on String Length
Help with VBA date
RE: highlight a column
Define Range Dynamically
Protecting & Unprotecting worksheet
sumif question
Variable type
Compare xls & mpp files against a master file register then flag missing.
What is Runtime Error 6028 and how can it be resolved?
Improving the code from a recorded macro
Run Time Error 6028: Help?
Import data from a secure website to Excel
Button to email?
Whats happened?
Find a Number and Date - VBA
pivot table running total problem
Stamp a Cell with Time Q
Help with For Each ... Next and control
row index number in a hlookup formula
Data Validation Macro
Compound IF statement
File Exist
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
all open workbooks
end if without block if error
Dates and Conditional Formatting
Return Value from MsgBox
Is Worksheet Empty?
Macro function to read text file
Selective Worksheet printing
Save it giving as a name the content of a cell
named range as rowsource
Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
How to Find the last non empty row
Two related Data Validation lists
Table Live
a1+a2=a3 How can I change a2,keep old a2 value & increase a3
MsgBox with Two Questions
Cal formula upon sorting
linked cells not updating
can't activate chart
Null Value
Copy Module to new Workbook
creating a formula with a loop
Tidying Recorded Macro Code
Macro to change font
Cannot change column name in Excel's MS Query tool
Accessing the text of a form command button from underlying macro
Make shortcut to Excelfile on desktop
select data from dropdown menu
Error on E-Mailing Q
Build whre statement
Invoke Edit Mode
Changing a two-dimensional, one row array to one-dimensional
value of one cell in a named range
NUMERICALS CAN CHANGE IN ALPHABHATS
How do I create a pulldown value list for data entry?
form population macro
How to write code for find a word in excel?
Pivot Table Custom Filters
Find a Number and Date ...
Transfer data from one workbook to another workbook based on a key
Pivot Tables - DisplayEmptyColumn question
AutoFilter
Visual Basic v6.3 and Excel v2002
VB Help/Request? Compare and insert to different data in columns
Capturing Listbox Selections
Conditional Formatted numbers add based on color?
On File Open
Counting Worksheets
Finding the path of a folder
if questions
Buttons disappear when projected
Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
Question on this conversion code switching between r1c1 to A1 format tia sal2
Hiding Columns
goal seek reference
Run-time error
type mismatch error when passing collection byRef
Only want to see half of my result
Remove a cell from a range
running Access procedure from Excel
Macro to delete rows
how to suppress auto correct?
Xlusrgal
Import from MS Access - Lose the drive letter..link only to drive
Fill Cell with Asterix
Hide all toolbars/menu bar when open file
Counting elements of array and range type data
Answer msgbox with macro
Copy Command Button Code.
Undefined MergeArea when MergeCells is true
Changing Numeric value to text
IF statement in excel
Find error!!!! Is there any other way to do this?
Find error!!!! Is there any other way to do this?
how to recognise a c# dll in vba excel
Not Enough Memory to run Microsoft Office Excel.
allcaps option in excel like word
Preventing corruption of dynamic range names on cell deletion
Application.Volatile not working
Deactivate Code
transforming poll data from rows to colums
Help- It's only a tiny change
Exception occured
TreeView1
Open Forum 4 ALL
Check a workbook exists before opening
"view page breaks"
Getting file name and Modified date
Linking to several other spreadsheets
Conditional formatting based on what function is used in a cell.
Columns limit 512
Using an Array to Speed-Up Range Copy
Set Class1Var = New Class1
Matching two worksheet?
align left and right in listbox
How to print out matching names?
macro to color all text red in worksheet if within certain date
Excel error message
check control names
Deleting Rows if certain criteria isnt met
Starting excel and running it on the same process
excel 2003 Reading workbook properties / details from an XLA how do you do it?
excel 2003 Reading workbook properties / details from an XLA how do you do it?
Auto number formatting
Hide rows and prevent unhiding
Inserting sender in voting response
Workbooks.Add = Macro Regression in 2007
sql
Macro to copy data with a date criteria
Use cell values as object names
VBA code to email 1 worksheet in a workbook
Instead of the word "dropped" could I use an arrow?
VBA Question - Delete set if any member meets criteria
Removing Blank Rows for Excel VB Newb
Calendar with weeknumber?
How do I use the Shift+Ctrl+down feature in a macro
code reopens file
Active worksheet problem
macro to close file and not save changes
Partial sheet protection
Copy only basic number without dollar sign or commas (or cell formatting)?
Best way to import .csv
Is there a way to run a procedure before the paste command?
Tab printing Macro
Macro acting wierd with Zip Codes
Missing Reference causing strange errors
What's the fastest way to push this data around?
hide sheet
Code to Print single cells
Worksheet_Change
Grouping Checkboxes in a UserForm
display cell contents
range values
Two Parter: filter list and search for a match for the password
If Then statement comparing date values
Flag me if macro errors
Worksheet Change event code, but retain Undo?
Why does VBA mess up
Checking if a property contains another specific string
Batch deleting invalid defined names from a workbook
this code crashes excel. How come?
Code to Create a Command Button
Can VBA Code change itself?
Printing to Local Printer and the not the default printer.
Location of Cell with Value in Merge Area
Finding Embedded Object Type in Worksheet
Finding embedded object type in Excel Worksheet
Excel / Access User Conference - Oct 24-26, St Loiuis
use a variable for a worksheet name in a formula
How to create a time log sheet
Excel cannot complete this task with available resources. choose less data or close other applications
defined name with formula as source in VBA
opening a file from a cell reference
Copy-pasting from Excel to Word
Is there a code to clear clipboard to prevent pasting on mouse mov
Export and Import Userform from Excel-file to another Excel-file
Using Shape's OnAction property in C#
Draw Entries
Error in Insert Row command.
Conversion from columnwise to rowwise
Find function using chr
Excel macros
Track Changes History sheet (Who changed the last cell)
Code Needed For a Macro
Selection.Replace What and double quotes
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
Hiding Columns
Split first name and Surname
copy checkbox to multiple cells?
Formatting the excel window
Sheet CodeNames
Stop a user from opening Excel if the Add-in is not found
Sumproduct, array
Option Explicit when install Essbase
can't transfer to worksheet
Auto size named range by .Net or VBA
How do they do that?
Macro not running when it is supposed too
array data to cells
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
Arrays [Why does this not work?]
if database exists... MS Query
TRANSPOSE and INDEX limit in Excel2007
Hiding checkboxes
Convert numbers to text (from product id # to name of product)
Search all worksheets
Search all worksheets
help with this loop macro
Finding the nearest match without reusing results
List Worksheet Names in a Dialog
End(XlDown).Row - Problem if only 1 row
Named range reference in VBA for Excel 2007
CHANGING FONT SIZE
How to read a string from a variant array ?
VBA or VBE
Selecting a file in a macro
Formulas
Automatically Creating a Command Button
Open a read only file as a writable file
Change PivotTable Field By Code
Call macro in worksheet from userform?
Specifying a range within an array
Copy a range of cells to all workbooks in a folder?
deleting duplicates
Get the Data Type of a Property
Copy-pasting (unformatted) to a word document
Summary Sheet from range specified in a worksheet
Wrong code?
Detecting open workbook
VB Editor Window
Help saving file; exporting as .csv
Solution: Actual Row Count
VB programming
Replace with an Offset?
Deleting Rows Based on Column Critieria
Simple query
IMPORTING WORD TO EXCEL
Enhanced Inputbox
comments in cell and web pages
Get cell address from Lookup function results
Sheets("Sheet").Copy problem
File save As
UDF won't refresh - please help
Custom Button that will automatically open another application (SA
Convert to HTML and e-mail selection as the body of the e-mail.
Refreshing external data
CallByName() doesn't
Remove Command Bar when excel file closes
Referencing an add-in in VBA
ADO Recordset to Msgbox
Trach Changes Without sharing the workbook
RE: Return names
Counting data
Reading files in alphabetic order
Copy and past using a lookup
UDF using Dates
Validating/Checking data integrity in cells
Adding an appointment to Outlook
VBA Help downloadable ?
Mandatory Field in Excel 2002
Update Links after Closing Linked File
Textbox font color change (update, but still not quite there)
Fixed Width Layout
copy certain data in a excel to another excel
Delete Cells when error
How do I: Query AD from a list of usernames in Excel
Using dedicated spreadsheet
Converting a Column of Numbers Displayed as Text to Numbers
xl2007 limits on TRANSPOSE and INDEX functions?
Insert Formula
Storing flag values at worksheet level (Property or Properties)
Making a selection while using a formula in case of redundant records?
worksheet change problems
Having trouble with this code
weird bug - Excel 2007
If cell equals anything then
Selectiemenu in Excel
FileDialog question
vlookup - Multiple references
On_timer Q
Input box format variable to $0.00 Format
UserForm text does not wrap
Reference offset cell
Excel into Excel
Add Custom Button to Quick Access Toolbar
Excel issue ...
making a function usable in every sheet
Copy/Paste Column Issue Using a Range
procedure too large
Why is my variable assignment not working?
branching macro
Dynamic dropdown?
Compare two worksheets and Highlight duplicates in each
Edit/Replace from table or named range?
Rotate Control
Show Tabs by date
Passing contents of a cell to a macro
Excel to Word Bitmap PasteSpecial Problem
Macro Help
Formula JLI
VLOOKUP
Change SELECT FROM When Using Excel to Query Excel
Bitmap PasteSpecial to Word Application
Renaming modules
Copy & Paste to Last Empty Row
Refering to new sheet name
Integrating Excel with Outlook
Using stored variable in a formula
Update Protected Links
Unable extract data from WEB query
Bitmap Pasting to a Word Application
Need help writing output to a file without <cr><lf> carriage contr
SumProduct If?
Why can't I run an assigned macro?
Macro to record sheet name
Append print job to an existing PDF
supress message
WorkSheet customproperties
Personal.xls in Office 2007 and Office 2000
Macro to search for a text string
Help on this code please
Application.StatusBar not refreshing after ThisWorkbook.Close
Macro to AutoAnswer
evaluate contents and select correct column
Find & Replace Whole Words
Newbie: Problem with 'Select Case' testing syntax
RON DE BRUIN: Help with CDO Please
How do I pass a value in a range command
Text lookup and return
programme run help
Help required
Code help
Macro to go to the last value
VBA Userform Textbox help
Web Query
Macro to Search
Need help on the formula
Old Excel 2000 macro won't run under Windows XP
copy until certain condition
Worksheet.Change macro doesn't run in 2007
Copy Selected Range to new sheet
Excel Macros work in Webpage ?
ado connection sql script select via listbox
add multiple controls
Run-time error '9': Subscript out of range
cycle thru controls
Intentionally not validate Sub or Function
Set focus on field not on active page of a multipage
Protected sheet question -- way to allow user to change text alignment and font style?
Macro Removes Cell Borders
splitting text in one column into multiple columns
Export file as a fixed width file
Moving data if cell is empty
Combining 2 arrays side-by-side
Help with Vlookup a date
Pivot table reports-summary
Does file name contain the characters XYZ
Memory problem
Opening a workbook to a certain sheet
Excel Services
Build a Macro that uses keystrokes
Date Issue in excel vba
combo boxes
How to leave form displayed
How to leave form displayed
Printing Macro
Inserting rows
Created list of worksheet names but need list to be hyperlinked to
set print area for variable number of columns
VBA to say IF cell = any one of 3 values,then do something
Adding and Deleting custom commandbars
Compare two excel spread sheet with macro
Loop - Tabs
Copy Paste from Excel to specified word document
Count number of sheets
Checkbox variable number
ClearContents
Copy and paste (special) a series of cells into word
REPLACE
Stop Data being sorted
VBA References
Rows hidden by Autofilter vs hidden by changing the Hidden property
AutoNumber/RecordID