Excel Programming [Archive] - Page 64

Hide Row Per Value in Two Columns
Run Two Macros from Same Button
IF cell equals then help
How to extract file name for use in a cell?
SplashScreen
Copy Range including Formats and Forumulas
Pose questions to Microsoft when an answer is not forthcoming in g
VBA code to import stacked text files
iterate through chart series collection
Pictures based on conditional and used more than one time
Marking a range True or False based on a single Checkbox
Worksheet to be saved in current directory
C++ Access to Windowclass Excel<
Opening a file and disabling open events
Move cursor down one cell
Show/hide details in pivot chart
Time sheet totalization
Determine delimiter in csv or txt file
VBA Code...
Closing Form and prevention
MATCH NUMBER From another wooksheet Macro
Macro to hide blank rows
Assigning Formula to a Range
Changing cell text color based on cell number
spell check ranges in a do loop
Setting CenterFooter on Multiple Worksheets
Deleting Rows that Match/Contain Search Criteria
calling a shared lib from VBA in Excel
Excel vba loop?
Multiple graphs
Avoid "MK_E_UNAVAILABLE" with a COM in Excel
Need an Excel Add-In.........
validation
Selecting 10 charcters on one cell and pasting to another cell
using UsedRange.SpecialCells(xlCellTypeVisible).Areas(2)
VBE Code
CalculatedItem suppress running total
deleting automatic links
Source Code Control
Pivot table - Hide the Data Sheet
Make directory structure variable
worksheet_change colour of a row on change of cell
RE: worksheet_change colour of a row on change of cell
collating/consolidating large amount of data in excel
Aliases Cell formulas Convert to VBA
Identifying rows selected by filter
Script to Pull info from website into Excel
Data of Sheet1 should gets autometically posted in Sheet2
Rew Macro For Computation
totalling dates
Reducing Size of the file
How to be notified when user changes cell value in selected column?
how do i calculate a running payoff amount?
Getting system OS language and then.....
Close Button Removal
Saving Forms
Setting chart Xvalue errors
How do I create a formula that will enter the most recent data?
SUMPRODUCT #value! error
How do I disable the right-click shortcut menu on charts
Excel Not Entering Data
Comparing Large Data Sets in Excel
How to pen the Find dialog box with a macro
How to validate that input was entered into Input Box
Round off error
Col alignment problem
Go straight to next value in a For... Next loop
Try Before You Buy Install
Find specific column and copy row.
turn off pivotfield sort
Adding totals to columns where number of rows varies
Do Multiple Regression with VBA Code
Travelling cell values with filter in Excel macro.
'On Error' within 'For' loop
Excel SaveAs not using specified FileFormat
Pivot Table Calculations
Calculating revenue over fiscal quarters
multiple pivot tables from 1 pivot cache
Randomly sorting a group of 5 values multiple times
Check Mark appears when a letter is entered in a field
continuing: Incorporating error handling to Bob's code
Excel VBA as a programming language
DisplayAlerts not working
right click menu
How do I get input from an edit box to a worksheet?
Similar SaveAs
Spash screen on a Mac?
VB code in excel.
Error using Application.WorksheetFunction
Excel automation: are there some timing constraints?
Block sheet entirely....
Firstname Lastname Field, Split two cells
Anouther loop question
Creating Report
Using the values in range of cells in an SQL query
code for counting/shifting
New Group in Menu
help with loop to delete rows
SaveAs Macro - Build filename from cell contents HOW?
Automatic Sheet updating
Recording macro to save file with name change
multiple choices from pulldown... how to apply to several pulldown
Search wildcard to limit only alpha characters
VBA programming expert required
Which Fires First?
Layout troubles with VBA-generated OrgChart in Excel
averaging arrays
Saving takes soooo long
Workbook_onChange that shows/hides rows crashes after printing?
Do until loop
pivot chart exclude rows
setSourcedata
exclude cells from calculation if custom format
Setting Combo Box to display a blank
Cut a range between 2 cells containing found data
Clearing the keyboard buffer after sendkeys
User Form
Barcode reader - to store data in Excel
DDEPoke only pushes the text contents from excel to word
exit macro after test of cell value
Merging selected fields from 4 worksheets to a Master Worksheet
detecting formula containing a constant
Column Chart with two axes
copy several sheets from a workbook to a single sheet in a new wor
can excel show due dates automatically?
Reversing a filter using a checkbox
Computer Name with VBA
change event; return focus to original textbox
Macro Required for Lookup Function
Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ?
How do I stop chart dialogs from appearing
Copy variable sized range to single column...
Transferring data in Excel
I still have trouble with Date Formats. Why is it so ?
Array copying to a filtered region
Name checking
Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?
Refrence a workbook procedure from another workbook
use vlook up function
Opening some workbooks with a Macro renames them
removing legend entries
VBA Find & Replace Intelligently
Cut/Paste - More problems
Copy TextBox Text
Unselect? Deselect?
VLOOKUP and stopping at the last record
averaging
Select another Textbox After Selection
Naming and saving a workbook
Copy worksheets to new worksheet and add a worksheet name column to new sheet.
Worksheet.Match the best way to go?
Macro to move a cell to centre screen
Macro and range names
Templates in Add-in
Help changing one line on a macro
Create Phone List From HR Worksheet
Excel VBA Program Won't Run After Auto-Save
Userform Values into Excel sheet
VBA - saving strings to a text file
Taking data from multiple workbooks?
pivot chart format recording & applying
Insert UserForm Values into Excel sheet
Userform Values into Excel sheet
Wild Card for partial matches.
cannot record macro
Fixed Width
Looping through buttons on a worksheet.
Code to find and replace words inside of a text box
Comma
Counting Colours
list separator
Autofit for entire sheet?
Check number of rows?
password recovery
How to discovery the color...
Conditional Copy/Paste
macro to subtract across columns
Multiple Lists from Unique Data
Excel Object in Word Document
can't create excel add-in macro to use with other workbooks
Macro stops part way through !
Load Dll
Code Works for Some Worksheets, But Not Others
Macro works on one computer but not another
Adding a button with Add-in
ActiveWorkbook.Names.Add -- Problem
Theoretical question: graph & trendlines in Excel
Actualisation problem :(
Customized toolbar button trigger macro in a different file
Create dummy file structure?
Date Format in a Userform Listbox
File size keeps fluctuating wildly!
send excel workbook as attachment to multiple users
RE: Date Format in a Userform Listbox
How to Change Worksheet Properties
Need Help: Determine Equipment Capacity
RE: Date Format in a Userform Listbox
Programmatically Select Tab on Ribbon?
Adding worksheets
GetOpenFilename - with a difference
Date format is not picked up correctly while filtering
Gather data from multiple XML sheets?
Searching for words used in VBA code
My code fails
Unique Listbox Scripting Dictionary
Print area composed by more range
Closing Files Opened Using the FileToOpen
Adding a Value List to Combo Box
Filtering Results in Excel & VBA
Microsoft Internet Tools not accessable
Conversion of WP12 file to Excel
Conversion of WP12 file to Excel
Printer Paper Source Setup
Search Range for string, then copy that cell to another worksheet
Runtime 1004
macro with multiple csv
Referencing a workbook in the same directory
Linking to separate worksheet with 2 criteria
not sure where to start
Return Array from Function
random assignments of workload to set # of people
programatically creating worksheets
if...color
Duplicate chart on new sheets
Let's try again: VBA Code stops randomly
How do I set Up a random sports scheduler
Scaling Graphs
Userform direction
Have a Big Question
How can I link (not embed) to a graphic on the internet in Excel?
renaming a query
Digital certificate blocked
Excel Camera Object
Excel forms enters .exd in registry
Determine Cells(5,4) IN SPITE of hidden rows/columns
Question for Jim Thomlinson
code to attach files
Text Box Value
Sum cells based on two criteria
Trouble Creating Formula in a Macro
Macro's checking for errors
macro question
Parsing after multiple selection in drop-down?
more than 2 option buttons on a form
RE: Merge/Join 2 Excel tables
Selecting a Range with a Variable in VB
Can I start the text import wizard automatically?
Using cell row # in a VB macro
Non unique records only
Creating Macro/Formula
Auto Calculate Question
SaveAs AutoRecover error?
VLOOKUP equation in VBA
Re-Post: Sorting Listbox Source
Copying Column in R1C convention
insert copied cells to a different workbook
convert string to integer
How to hide a column in combobox?
Method to get dates based on Month
deleting "0" rows
MsgBox repeated two times (Excel COM Add-in)
Open Office Compatibility with Microsoft office
Copy row formatting down
Add break in macro
Count only Mon-Thurs?
program for dialog box
Automatically use or update links between two sheets using VBA?
Overcome "expected end of statement error"
Opening Excel-files in several directories
Macro for Inserting Rows
ADO compatibility between Excel XP and 2003
Execution comments
Sheet Show
Export Excel in Power Point
Worksheet Open Event Q
How to open Word from Excel with VBA (Office 2003)
scanner twain
Help with Macro that searches a Range for specified information
insert a macro into a workbook using vba
Is there a way to kill all files in a folder?
Run macro when file is opened and closed
date format change when opening file with vb
Opening files by VBA
Any api to Insert objects in Excel
Import Outlook Journal Items into Excel
add the addin in the Tools menu of Excel
Formula doest work in Excel
I get Subscript out of Range second time, not the first time
Excel Colum and Rows Problem
How find maximum top+height property of a collection of shapes
Spin Button's What can they do?
Re: Is there something wrong with my code?
ListBox Selection to fire Macro
Looking for DMEDIAN
How To Quit Subroutine from a called subroutine
Pasted values keep changing to time number format
Maintaining Information in a Cell
Saving a workbook to a specific directory
clearing cells and checkboxes **ROOKIE HERE**
Find Record in Access Using Excel
Update current record in Access using Excel
XML Web Imports
How to Improve my "Vlookup" on Steroids function.....
Freeze Panes C#
Simple Find/Replace Question
Can I count total lines of VBA Code Executed in a Series of Subs?
Textbox in user form
Formulas for multiple functions
Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options
Insert a formula into a cell
Sorting ListBox Source
Increase font size within my formula bar
Copy from multiple workbooks, rename, and overwrite if exists
Difference between Worksheets. and Sheets. is...?
Do Untilâ€¦Loop Question for the Excel-Looping-Experts
Tcl's Tcom meets Office 2003 - giving pre-.NET Visual Basic for Applications a small taste of introspection the long way round...
subscript out of range
Factorial Function
File Save Macro as Cell content
Measurements in VBA/Excel
Connecting to Access Database from Excel
Copying Formulas
Incorporating error handling to Bob's code
Strange listbox behavior in version 2003 after version 2007
Access Table import
Microsoft Office Document Imaging
Excel 2007 Problem
VBA Code and Checkboxes
XL2003: Is it possible to sink a form's events in a class module ?
Capturing conditional Interior Color of cell
Copying Color Index + conditional Formats + validation
Tickmark Macro
wher to put the code
Minimum value needs to be greater than zero
Minimum value needs to be greater than zero
Minimum value needs to be greater than zero
Opening a link with Excels
Collecting data from other worksheets...
how do I set up a scoring system in excel
AutoFit Row Height
VB for A conditional formatting exercise
code won't run
Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes
how do i use find in VB
uk date comparisons
Converting to late binding (for compatibility)
Comparing text?
Response times calculated in business hours
VBA Formulae...
How do I retrieve entire Revision Number on Excel 2007?
Information Required on Insertion of series
Change Settings in Find Dialog Box
How to Set a Reference to a Copied Worksheet?
Can you Sort Listbox Values Alphabetically by code?
Will pay for need help and occasional advise on using excel ....
Not ALL values are populating to Combobox for some reason. Why ?
Is there something wrong with my code?
solver ranges
Auto-filter. Cursor on first row in new list
Still stuck removing duplicate values
Macro for Editing Data
Discontinuous range of X Values
Export from Excel to text file with a twist
Counting records
counting records
Userform Initialize & Command Button, Excel 2000 & 2003
Run time '429' : ActveX component can't create object
Cancel Button in User Form does not rever to original state
Excel VBA Expand/Collapse with Subtotals
Project- planning tempate? Where to find, how to start.
IIF Function
More than 3 Conditional Formats with VBA - Not Working
copy template to master spreadsheet
Summing
updates in wrong workbook
Re: Vista bug (?) regarding Excel 2007
Adding cell locations to a word form
-PLS CONSIDER THIS AS URGENT! HOW TO PUT SUM FORMULA IN VB FOR A CHANGING MULTI CATEGORY OR GROUP
Cell data change formatting
worksheet function with two ranges
Can I use the result of an array calculation inside a regular formula?
find an exact number in a different sheet and use the cell containing the number to output information
Excel alarms
Increasing the value of a cell by one per worksheet?
Application-Defined or object defined error 1004 When ran on exel97 but not 2003
Compile error macro is 111K. how do I fix macro
HOW TO SEE/EXTRACT LOWEST PRICE OF MULTIPLE PARTS IN ONE PAGE
Need help with Excel VB
Need VBA code for a custom function?
log trendline formula
"Variable not defined" error for form that does not initially exist...
Simple question - help please and thank you.
Indexing or Ignore Blank rows
Rule to recall collection lower bound index ?
Add or Less data automatically.
HOW CAN I HAVE THE SHEET TO BE PROTECTED, FORMULAS HIDDEN AND YET GIVE AN OPTION IN VB TO HAVE A TOGGLE TO PROTECT/ UNPROTECT/HIDE/UNHIDE CELLS
HAVE ONE REPORT SHEET WITH LINKS FROM VARIOUS SHEETS. ON COPYING THIS LINKED SHEET FOR EXPORTING IT TO THE OFFICE GET ERRORS IN CELLS. HOW TO RESOLVE THIS?
Runtime Error '-2147417848 (80010108)'
Workbook_SheetSelectionChange in going infinite
Need formulas for finding text strings
Excel services problem
looking for logic guidance
Excel Dashboard - How was this done ?
Multiple Columns in Columns Property?
Function condition statement
Flowing Row Display When Query from Access
Re: 2007 EC Excel / Access User Conference
Specify location of X Values
ListObject -> XML question
Consuming Web Services From Excel 2007
How to run an Excel 2007 macro from a VB program ?
clear option buttons **MACRO TWEAK**
blank worksheet menu bar on top
Time Date Stamp when range changes
Setting alignment in excel via vb .net
Interior color
Using Excel templates with GetObject/CreateObject
how to do a "check for updates" over the internet
Selecting a workbook to copy data from
copy Excel charts to PowerPoint and Word
Select Shape in activerow
Insert copied row at cursor position
Drag & Drop file onto Userform control possible?
Search a Range take Action
text file from url referring site
Help! Macro to send email from Excel and add other attachments
Is Date Odd or Even?
Excel 2007. How to Get Microsoft's Attention
Thank you.
CUSTOM COMMAND BAR DOES NOT SHOW SOMETIMES-- WHAT COULD BE THE REASON
Variant
how to format rows by groups
lastrow function
edit chart datapoint tooltip
Library issues
Outer join with 3 tables using MS Query
Outer join with 3 tables using MS Query
Hidden Columns
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
Alternative way to refer to a row to hide or unhide...
Access custom chart autoformats
Send excel contents to POP3 mail server such as Yahoo
problem:Structure with Object reference (TYPE...END TYPE)
Index function with quotes and '&' sign in reference section
How to make the dot in different size depend on the data in a scatter chart?
VBA Training
Is it possible run code when a cell is doubleclicked?
Creating a Loop that looks for the word "Total"
adding alternate columns
New Email Details to Excel...
generate a list from a single row of data
Comparing Cell values in two sheets within the same workbook
file notifcation table
Clearing RAM
Force external application to remain 'above' excel sheet
copy from one workbook to another
Correct code
??? Public Sub code jump to Private Sub Code
Importing an image in VBA
How do you delete all buttons in a worksheet, but not all shapes
Copy and Paste Charts as Picture in Different Workbook
Macro Help
Assigning an array to range object?
excel data link refresh
Remove Duplicate Values
Importing from a text file
Excel Services external data sources - Kerberos or SSO required??
Value NOT adding 1 ??
Calculations using the last available figure in a column
Copying Excel tables into Word
Beginners Question
How Do I Copy Only Select Data?
Some problems with shared workbooks
Hyperlink Construction and Execution
Macro: Select visible cells only
PasteSpecial Method of Range Class Failed Error a Different Versio
Creating mulitple workbooks from single workbook - *Macro tweaking needed*
Modify Print Macro,,, is it possible.
MS Query refresh changes column order - Help! (Pretty please?)
add info to excel feilds
Calling a Macro within a Macro
Copying rows with radio buttons and drop downs
Compare cell values on different worksheets
HIDING A VARIABLE NUMBER OF COLUMNS
Cell Blank if duplicate value in previous cell
Binding data from database to excel drop down
Data Validation Using Radio Buttons
Move from one cell to another
Macro does not populate later rows
Running code when a worksheet opens
Deleting unwanted files
Buffer overflow in FileSearch?
Converting 0 to a Dash without using Currency
Creating Reports in Excel
ODBC Run-Time Error Handling Help
Is color indexing dependent upon the display
How I auto send e-mail from excel with predefined subject and tex
Stop Event
IF statement
Disable Password Dialog Close Workbook
killform - VBA not Macro!
Macro to replace file name in linking formula
What command after then statement?
How do I set initial Excel workbook name?
Create List from Multiple Worksheets
Request advice on Split(sFile, "\")
subtracting serial dates
How do I append the same text to multiple cells?
replace character in txt file before import to excel
Column index returned - how to get the Letter
Licensing for Excel ActiveX
Toggle Calculation Status
help with code
Excel 2007 bug?
Paste to active Cell
Paste to active Cell
Help with IF Else:IF statement
Renaming data fields used in Row Area
copy rows and paste in another workbook
For each objcht in ...
RE: Help with IF Else:IF statement
RE: For each objcht in ...
Protecting VB
For Each advance conflict
Cell and Sheet references
Extracting Words from Cells
Need to flag numbers over a certain value
Reflections, getting info from Excel
Can't run macro as normal user
RE: Need to flag numbers over a certain value
time format
select rows and delete based on criteria
personal2.xls appears and now all my triggers point to it
RE: Can't run macro as normal user
General Names and Links question
RE: Can't run macro as normal user
Hyperlink History
Save as new file without changing existing file
How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
Commandbar
populate conditional formating on a spreadsheet via VBA
Open DBF files in XL2007
VBA Variables....
Handling library references when distributing worksheets
VBA Range Variables...
variable or propertie 'name' for self written sub or function
Udfs and eventhandler for excel in managed code
Worksheet Focus gets changed while changing the cell value
Worksheet Focus gets changed while changing the cell value
Worksheet Focus gets changed while changing the cell value
Vlookup question
convert culomn letter from number
Print visible sheets - ordering
COPYnPASTE from one workbook to multiple workbooks in the same fol
Functions 101 The basics
function for ranking ?
Get value form a cell in a loop
Using the Return Key without exiting Textbox
Sum
Value NOT being input
Date Change macro
viewing
Copy workbook without Macros
variables in formulas
Excel 2007 Design Mode
conditional format: looking for formated
VBA errors when doing "File -- Save As"
Excel - Read-Only
Making a planning sheet
Values don't behave when converting text to values in userform
VBA help: Using user's selection to copy entire row
Renaming Folders
If command with 3 options
Can result of formula not display if =0
Hiding a macro button
save worksheet with chinese characters as text
Opening a shortcut in a macro.
Linear Interpolation in excel
Help with Debra Dalgleish's Code
Copy/Paste within AutoFilter
password protected
XLDialogPrint - PrintWhat- Selection Option
Need help with VB Excel statement
Delete duplicate rows based on part of cell.
Is there any regexp and hashtable management in Excel VBA?
how can I insert a space every three characters?
Label on User Form visible
Populate a Multicolumn ComboBox with filtered range
MACRO HELP
MS Query does not quote identifiers in the generated SQL
syntax correction
Greater than, less than statement
XL 2003: ListBox ListCount (and other) properties missing from Local Variables window
Inserting Excel Data Range into Access Table
Quick .End(xlUp) Question
subscript out of range - how to determine
Hours
VBA question: adding a row to worksheet from recordset row
Text to Row automation
How to preset password for editing for new files generated in exce
window to enter a number
newbie q: how to run one sub after another
Executing custom MDX queries in Excel'2007
Format of calculated member in VBA
Face id on custom menu bar.
Launch non-office applications through VBA
Size of Row
Excel interop from c#
Combining Variables Into A Single Output Cell
Call a menu item
When Saving As
disabling tool bar
Change Page Field in a Pivot Table and Print Chart + Data
Is FIle Open
Transform positive numbers into negative
VB code to compare/validate and delete as required
Dynamic range with VBA
How to Determine the 3 of days between two dates
set range
Columns collection Address
Run Part of a Code If Q
ScreenUpdating not working
Hyperlink question
Optimising vba programming in Excel
overflow problem and variable declaration
programming button again
Substitute in Excel VBA
VBA, change 'copy line' into 'copy range'
Find and Paste Loop
Macro to Automate Text Import for Multiple Files
EXPORTING DATA FROM EXCEL TO WORD
Cut/Paste using Left(), Excel 2000 & 2003
Sorting Query
Can I use code/macro to change code/macro in an existing file?
worksheet name store in a variable
Publish Chart not supported in Office 2007?
USA-NY/NJ - VBA Programmer/Consultant - Immediate
Ignore #N/A in formula
How Do I Set A Timer in VBA?
Sorting w/Macros
How to export a range of cells on a worksheet to a text file
Office Web Component
Deleting extra rows
Excel 2003 Command bars
Error 429 VBA.Interaccion.Createobject("Scripting.FileSystem Object
RE: Pivot Table - filter by a cell reference
RE: Pivot Table - filter by a cell reference
Can't set pivot table object variable
VB Code + Runtime error 91
Allowing for Grouping and Ungrouping while Sheet is Protected
TEXT DATE Format Conversion
Loop Thru Values in a Column
VBA help- Do While and If statements
Retrieving chart series range data
Getting coordinates of an Hyperlink using range get_Top(), get_Lef
changing colors of a cell
File list - list filenames in excel
form object doesn't have a show method ?
Date addition/format
Windows Scripting Host popup method has stopped timing out
How to export data from SAP to Excel ?
EXCEL Sving Formats
Dropdown list to return different value
macro language
Excel.Interop Not Saving Column Width Changes
Excel losing focus, but remains active !
Removal of External Links -incl script
Comparing Data in a worksheet and access.
VBA question
VBA-generated Hyperlink problem
Referencing a Dynamic Named Range in VBA
Dumping data to .pdf, taking screenshots, mirroring a sheet, or other report type?
Moving colC to colA
Range.Subtotal different than menu function
Formula Help
Running Code on Hidden Worksheet
Newbie Questions
Track Date Created & Last Modified Dates
Access Memo field to Excel Textbox
Multiple If Statement
macro on exit of field
Using Macros to ask the user to enter a date
Replacing values in formulae with links
how to dynamically import a text file
Boolean Misread
Need help removing items from combobox
Help needed with connected worksheets
How to extract data without opening Excel
browsing filter
removing links to external workbooks
Conditional Formatting
Create Shortcut in VBA
why stepping thru works differently module vs. worksheet
Print Worksheet to PDF Files
OleDBConnection.Open() blocks with 100% CPU
Changing the colour of a control button in Excel
Run Time Error 1004
A ppm format
Problem with CSV web query
Backup on file open
Format Cell If Cell Not Blank
Re: macro to copy a function down a list
Re: Calcuating annualised year to date income
Re: Calcuating annualised year to date income
RE: programming button
Re: Multi-line cell formatting
Re: macro to copy a function down a list
RE: Calcuating annualised year to date income
Re: IF Conditional Formatting
Help with double loop
Re: Run-time error '1004': Select method of Sheets class failed
Re: Run-time error '1004': Select method of Sheets class failed
date format
Format footer
UserForm List Box, Excel 2000 & 2003
Importing a relative reference from a web query?
conditional formattion of adjacent cell
VBA, copy lines
If a value exists in a range
BeforePrint
Combining Columns (Bracketing Text)
user form triggered by selection change
Skip blank cells, find 'reds' and organise in seperate workbook.
Treview hangs Excel
conditional formatting question
Putting formula in cells from a loop
Quick Question - PasteSpecial
Macro that deletes rows with "0" value cells
SQL Select Where - formatting
UserForm tanked
VBA on Excel 2004 Mac
Before_Print
Insert row above subtotal
Digitally sign an Excel Workbook using VBA?
Increase/decrease decimal by programming
VBA, copy lines with specific value
Sending chat responses through XL VBA
Disable some buttons in ShowDataForm
ActiveX comboboxes on worksheet (lost focus problems)
Re: SQL Server Query to Excel
Filtering Multiple Worksheet Columns
Type mismatch error when using outlook
Excel to save as a hidden file?
BUSINESS DAYS - Need function that will list next 3 business days.
help with variable division
Reference to Add-In for VBA code?
Macro
Making Excel understand the diffrence in capitialization?
Code confusion
Delete cells not in Active Worksheet
Microsoft Query - Column order changes. Argh.
BORDERS
DIALOG BOX DEFAULT LABELS
DIALOG BOX DEFAULT LABELS
FORMATTING UNDERLINES AND BORDERS
Sort to include hyphen
Testing if a workbook is open
Macro to paste data to a new column if previous column has data
Project- planning tempate? Where to find, how to start.
Code execution has been interrupted
Programming a Command Button
Insert totals after varying rows of data
Problem with Excel 2003 toolbars in Excel 2007
Pivot Table Calculated Datafield Caption Problem
Pivot Table Calcualted field formating
Object Position
Pasting clipboard to Excel sheet
Can't maximize Excel window
Lock Conditional Formatting in Excel 2007
Create a data set from 2 different lists
help with string length limitation workaround
Reducing Excel File Size
hyperlink with name from cell
Grouped option buttons on forms
Custom Number Fomatting
Merging Rows in Excel using C#
Setting Many PivotItems' Visible property to False
Renaming all sheets in a workbook according to a specific cell.
Plot with Macros
Change Cell Values
IF Statement and Font Color
Match and update Excelsheets
OpenText runtime error '1004'
VBA EXCEL COPY BETWEEN WORKBOOKS
default file location in a file
exporting data
how to break out of an if statement and continue to loop
Count characters in 1st line of UserForm Textbox
Sum Of Columns Cannot Exceed One(1)
Open Worksheet Sort Data
Can any one help me update my database?
Might be Formatting
Defining a Row Number
Input Dialog Box - change cell data
Erlandsen Import from closed wbk (ADO)
Logic breakdown.
String of sales codes to be broken into separate columns
XL-2003 - Class Module - Controls declared "withEvents" don't sink events..
Use VBA (Macro) to Update Existing Macro
Pop Up Form Based Workbook Close()
Finding the length of proportional text strings
does range value exist in another range
Okay, dumb question.
Excel Checkbox Alter Font by VBA
macros embedded in .xlt file
connecting to sql database from excel using file dsn
Re: 2007 EC Excel / Access User Conference
Put selected names in correct place
Listbox vs Combobox
Can I run a Query from a cell using VBA
Custom menu disappears
create macro - pivot table Select all rows/cols with data less las
Question with existing page numbering macro?
update file by DDE
Worksheet_Calculate Loses the Undo function
Selective Recalculate
Pivot Table - Excel 2003 Vs 2007
Changing the properties of a Shape/ AutoShape within a cell
Option button memory
ListBox selection copy data to various cells
Self closing "modal" window ?
Check for named shape in chart
Spinbutton Mysteriously Erases Textbox
Add text to existing text string
Unable to change NumberFormat Property
Macro suffers from premature exiting
Cut/Paste - Unwanted Macro Execution
Storing Doubles in SQL
Count & Sum Consecutive (2x) appearance of Specific Numeric Values
find full file path of running excel instance
Generating a Weekly Report based on a Date Range, where 1 Column = 1 Day
Deadline Reminder
Scrollbar
Searching cell for text value from list
Searching cell for text value from list
Searching cell for text value from list
validate all cells before save
date display from excel in word
Make a deleted entry appear elsewhere and remain in a 2nd cell
Display userforms
Find cells with a specific character in them and conditionally format cell
Journey time calculator
Send mail - button on my excel sheet, need help.
break points
Open xls file from xls file in same session
Advanced filter query
Display Status Bar Function Results in VBA
Help to write a macro.....
Rename files and save them as pdf
Hung up on Transpose
Columns.ColumnWidth error...sometimes
How to catch Ctrl+P short or Pressing Print Button
Average
ADO From Excel 2003 to a access.mdb Query
Windows LOGON NAME - special case - account name different from folder name
Three lines of code that I can't understand
Convert Date Stored as Text with VBA in many Workbooks
maybe by cell coloring with embedded comment
CODE FOR TOOL
help for chart scroller
getMacroRegId displayed in Immediate window
Problem with unwanted add-in !
Userform : Font size problem
Creating a sheet to view rows from another sheet
access my vba project
Learning Excel VBA
Need help regarding ComboBox
Information Required
efficient printing of form
Sheets
enter data that goes two places by category
I AM IN DISTRESS. PLS CONSIDER IT AS URGENT. WHEN OPEN MY EXCEL 97 FILE- IT MERELY SHOWS PROGRAM ERROR AND WHOLE EXCEL SHUTS DOWN-- PLS ADV
What is the fastest way to copy a range to a 2D array?
Copy certain columns matching column A in two workbooks
Open WORD Doc and assign Excel tab as data source for merge.
Link Access data in Excel
PLEASE HELP!!!!
Link Drop Down Boxes in Excel - HELP Please
Date with a Form
excel
OLEDB Error reading Header Name ("State")
UserForm with ListBox, data from 2 fields
How do I copy a data from a single column into an array and back into another column?
Preserving VB code when converting from Excel
range().select function in a macro
Get the last displayed number in a row of columns
Deleting Rows
Calendar Control
Event Programming - Cell Value change - 2 sheets involved - VBA - Excel
Set all option buttons on worksheet to off
Delete textbox after exit
Application.Calculation = xlCalculationManual not working
XYscatter chart source
Tracking Changes in a non-shared workbook
Button-Instigated Sort: One More Thing...
excel won't pickup an Access query for a pivot table
Excel 2007 Dialog Theme
Selecting an adjacent column
What's special about iRibbonControl?
calling another module from within module
Xl2007 Conditional Constants
Missing Add-ins
auto_open()
Show worksheet ComboBox DropDown list even when your not in it
Auto_open
Open Text File in Excel
Creating tables using AutoFilter in Macro
Timming Function
Partial copy
Copy cell (C6) from multiple sheets in a wbook to another workbook
Copy cell (C6) from multiple sheets in a wbook to another workbook
Copy cell (C6) from multiple sheets in a wbook to another workbook
Copy cell (C6) from multiple sheets in a wbook to another workbook
Verifying that data exist
Newbie vba ranges
Creating help files
Removing a module using VBA
Enabling a button based on Cell entry
Userform Placement
Larger than X - Smaller than Y
Excel 2007 menus - XML Notepad 2007
import csv data in excel using vb
any value to range.formula
Create Report
Open Another Book
Creating toolbar macro errors
Track Changes without sharing a workbook?
convert date to string of numbers
Personal Macro
Which sorting technique does Excel use in the sort function?
Month and Day reverse in automatical recorded cell, STRANGE
Formating string as "#,###.00"
How do I access the access data via Excel 2002 with auto update ?
Add-In problem with Excel2003
If a certain cell has a certain value, a certain worksheet is hidden or visible
working with PDF data
UserForm Question, Excel 2000 & 2003
Setting cell values in Excel
Setting cell values in Excel
Setting cell values in Excel
Tab Limit on MultiPage Control
Newbie question re Form
statestics
Excel quits when executing Activesheet.Name instruction
Office 2000 and IE7: Compatible?
Conditional Formatting and Changing Cell Colours
Advanced Conditional Formatting Help Required - Change cell colour based on values of other cells
Copying values skipping blanks
how to format the print?
Running UPDATE and APPEND queries from Access in Excel
how to record a Macro in an intermediate state?
move unknown files
Button To Sort Sheet Contents On Column?
Create excel file from asp.net with dynamic columns?
Duplicate Projects in VBE project Window... Very annoying.
Code that keeps creating a toolbar - where might that code be hidden?
Email a chart from excel via Lotus Notes
Can't call macro from another
last duplicate value
Help with Type Mismatch error please
Date Find
Excel formula question
On Error GoTo 0
Pivot Table - "duplicate dimensions across (independent) axes"
Kink in locating last row
Webquery for page that requires login and password
Possible Validation.Modify bug in Excel 2000
vb needed i think...
Programatic Subotal Question
Formula to a cell
Rearrange row data
Message box help
RE: Can't add macros to buttons I've created....
Simple Help ASAP macro to fill range...
customize buttons
Formula in macro causes macro to fail
Look for a value and clear it
Internationalization / Localization (German) and Formulas Question
Metadata within macros
Analysis Automation Project - Bayser Consulting
Analysis Automation Project - Bayser Consulting
Combo box that pulls specific data from range
Option Box on Workbook Close
Re: screen tips and macros or automation
Conditional Error Message Once a Range is Activated
Addpolyline function
Run macro on excel open if after certain time
How scan specific column in each row?
change label font
If statement + date calculation
If Statement
statement invalid outside type block
Suppress printing checkboxes
Cell content as a comment for another cell
Charts forget range or data; fixed by manual alteration then Undo
Auditing tool question
Where can i find the Advanced Excel Programming Template??
Cope cells
Code skipping when screenupdating is turned off
UDF Challenge for Curve Fit Function