Excel Programming [Archive] - Page 32

Open Internet from Excel
One single character to upper case
Message for Bob Phillips
Variable range
Filter Static List
Urgent Help ....
Easiest way to Debug Code
Look up number entered into text box and populate another with res
Two Questions Page Break Preview
find a word, within many words/columns and put a copy in anothe co
combine worksheets about 130 sheets
Can data validation ranges be linked to a referenced cell?
Creating a Changing Range
Link to atpvbaen.xla
Rearrange entries
Listbox Column help
MS Query - Use of Max?
using advanced filter for several of fields
Advanced Filtering by top scores
Range Select Syntax
Value as part of another value
Trying to use end down in a macro.
Find Method Help in VBA
Clear cell when drop down combobox is changed
Looking for a formula
RE: ChangeLink problem
Stop all cells from calculating after deleting a row
Issues with Word when exporting data from Excel - errorhandling
Select Cell within range
Using VLookup, how can I retireve the related columns.
List/combo box/form? Want data entered to fill excel sheet
array in formula
Pass Cell Value & Formatting to Another Worksheet
Insert a Text box on a form with VBA
Automatic Color on Export to Excel
RE: delaying cell entries
Find a theme in a article in a single cell
CreateFolder from Worksheet Columns
Copy Selection as Picture from Excel to PowerPoint 2007
Loop and SaveAs Question
PasteSpecial giving error #1004
check termination refresh of .Connections command
Remove macro programmatically
naming multiple ranges
Improve PageSetup code
How to force the immediate window in the VBE to clear
Userform Command Button not available until another command buttonhas been used
Excel 2007 Data Labels
Update links/save = false
email
How do you count specific values in a row
cell link to userform
Data Validation
NAMING OF A MODULE AND MAKING IT UNOBSERVABLE - VERY BASIC
Using Pictures to return numeric totals
Saving a file with date and time as filename
Workbook_Open Sub not called when spreadsheet is opened
Comments - populate using vlookup
Data Val Reset Does Not Work With Sheet Protection
Adding Encrytion Password using VBA
Resetting Data Validation with VBA
Naming a new workbook without saving
Columns hiding too soon!!!
Concatenating text cells in a row (No. of cells not fixed)
Position of MsgBox on screen
Change a column data without new row?
Setting line width in chart
Passing Type Arrays
Message box bleeds when moved on a userform
copy sheet to other workbook[C#]
Macro to copy only used cells
Sum Forula using variables
Deleting the last row
Visible = True - Not Working
Migration of Excel Add-in
Setting Keyboard Shortcuts for locked XLA add in
need to reference a cell from a changing range
VBA Code to open an Excel file on a sharepoint site
vba code to run files
cell-range relationship & non-standard symbol recognition
how do I total the value of the cell to a single value, 37=3+7=10
Code to save workbook without macros
How do I manage Baan by a macro?
Trust Certificate/Digital Signature "Breaks" Upon Addition of Shee
Move data from 1 sheet to another
How to test variable for chr values
view raw sheet code
Excel 2000 VBA form questions
Status Bar Message
Excel 2007 formula calculation
Match Error Handling
Word to Excel conversion of addresses
Protect sheet but allow user paste
Radio Button Printing Problems
Select Case: Multiple Ranges?
Open a File and Run AutoOpen Macro
Macro location
Macro to add border
INsert Formula via Macro
Import a template?
Show indicator based on the sum of 2 criteria
Multiple Ranges - Same Worksheet
Toggle Button Format Options
Subtle Cell Protection
Using Pictures to return numeric values
Using a cell located with the find function
user defined functions
Validation with null value
copy by timevalue to last row
Browse for Folder from Chip Pearson
How do I: If Pie Section Label = X, Make Pie Section Color = Y
Run-time error â€˜1004â€™
To determine that cell is on top of page
Reading from a folder
Macro !!
Locking cells using VBA based on other cell values
Do I need to destroy a collection I made when I am done with it?
2008 East Coast US Excel User Conference
Macro to print to IP address
How to make First letter of the cell in capital letter
Emailing Spreadsheet as a body
Application Quit does not work at all
Hide Rows
How to write a Clearcontents command in a macro
workbook specific custom toolbars
How do I setup page and margins for ALL sheets in an EXCEL file AFTERWARDS?
VBA and Excel
VBA NEWBIE Need A Bit of Help
Drag and Drop in user forms
Updating spreadsheet links from VBA
Pass ActiveCell Value to my Add In Workbook
Linking Excel to a text file database
Determining Target font colour
add-in not showing in function list in Excel
copy method failed
Date Picture Taken
Saving a worksheet to a separate file
How to ignore user input during macro execution?
My VBA Project Explorer quit listing modules and worksheets separa
Stop Screen Updating
MouseMove on Shape
Excel form file
Label caption
running speed
Pivot Table - How do I "Show All Data" of a particular field?
Conditional row selection
Web Query
Finding gaps in a Pivot Table
Use IF in a Function
2007 code not working in 2003
create a button to link
Concatenate with Formatting
string extraction not working.
Conditional assignment?
VLookup (Find & Retrieve) Problem
Excel macro that creates a Visio Document
delete cell value if there is data validation error
If Formula
Tracking xls File usage in Excel
Help with dulicate range and highlight rows
Mailmerge - Hide Select Table dialog box
Updating pivot tables after creating file
Force to Directory
Copy & paste ranges from 1 wkbk to another
variable problem error 424
File in use
what is the proper file format for excel 2003
Working With A Loop
Row Select
getting 1 line of text from a cell comment
Fastest way to delete rows
Professional auditor of VBA models
Run A Macro Every Time Excel opens any file
input box
Changing Ribbon buttons
Problems to delete blank/empty cells
Why do I get an error?
Compare and highlight duplicates in two workbooks
Automated Email
Format Cell
insert formula in cell
Add Item To ComboBox List
Looping through all cells in a workbook
Finding averages
TURN NUMBER TO TEXT IN TO BESIDE COLUMNS
Compile error hidden module
ListBox does not support saving
Multiple functions/formulas...
Activecell problem
Protect ComboBox Lidt
Print Macro code help
programming custom filter
How to move a form under a cell?
Conditional formatting of dates
Sub to append data below existing
count if two conditions in two arrays are true
Sub to update data
Macro- Relative reference
WHEN networked file is accessed in VB, get 'program error'
Query Changes
run-time error '6' - overflow - once I declare a pre-used variable name as integer
do until blank
"Nag Screen" pop up
mail a file with a macro, changing the user session
Newbie question defining ranges
Loop thru some sheets in wkbk and call macro - better way?
VBA to create dir's based on 'date picture taken'
Do Loops
Handle a value from a Range instead of value of a Cell
making comments within a formula
Deselect Command Button by Selecting another Command Button
Advice Sought
Compile Error - Procedure too large
Desktop path?
Excel 2007 copy sheet with controls not working
runtime error help panicking!
Deleteing rows after a Go to/Filtering
Select folder path
XL2002: Selection.SpecialCells(xlCellTypeBlanks).Select
Making comments show - momentarily
Morefunc ARRAY.JOIN function
Print to PDF using PDF-XChange 3.0
Is there something faster than select case?
Using the next reference number automatically
Geeting Background picture from the worksheet
Re: synchronize two pivot table
Vlookup Help
Please help with Range.Resize
Need help with a transpose
ME, BACKUP
Variable not defined for "number of trials" ?
Error when running Solver ("No return or halt function found...")
WorkSheet_Change event
Add years, months, days to a date
Unwanted conversion from Null to Zero
cannot access macro in another file
Simplify Code for Copy/Paste Special
Selecting values in sheet list box using vba
why the code make the error "Overflow"?
Putting named range into sub written by Tom Olgivy DataVal
Problems with the Close statement not releasing the database fastenough.
VB in Excel
Sum a Range of Cells
Listbox + Multiselect + Pivots
Hyperlink from the web
Evaluating (Splitting out) a formula
Evaluating (splitting out) a formula
Customized function
Using vba coding to change text
Create a vba coding from one workbook to insert data to another workbook
SOS- getting 'program error' and excel closes.
Statistics and Excel 2007
Statistics and Excel 2007
determining the intersect of 2 lines using vba
Where can I find documentation for the axSpreadsheet control
VC use Excel?
How to stop ## showing when cell contents too wide
web page entries
getImage and VBA Callback
Can I use Excel to measure time?
Date formatiing - using code to block months together
Network printing
Modification in Recorded Macro
Check whether text in cell contains "?"
Image Control - MouseMove Event
what does the operator ":=" mean?
Making a cell a color using color numbers
Matching values in different columns/workbooks
UBound function does not work
How to check one cell value to diffrent cell
Could someone review my first Excel VBA program?
excel 97, VB project unable to view in another comp
MVP Question
Array Copy - Paste Special Add Help
VBA Clear Screen
How to get all info on a specific name from diferent worksheets t
Working with a Loop
worksheet_change
How to print the values of cells
Formatting cell poulated by User Defined Function
Find works sometimes
Precedents for formulas
Breaking up an array into parts
Select and copy a variable range
Macro to select a variable range
Do Loops
seasonal adjustment
array
Blanked out on path
Bolding Subtotals
Excel PivotCache Recordset property is it Read/Write?
Email Macro
maintaining a variable's value outside of a for loop...
Load Picture on Image Control
code to change formula
Variable passed to database query
Excel VB issue
Creating a table of random numbers
Macro accessible by all users
Digital Signature Issue
copy folder using IP address as destination path
For without Next error
Show amount of RAM and Windows OS?
Excel form
Pivot Table - Filtering on a user defined field
2008 East Coast US Excel User Conference - Regular registration ends
Problem with macro triggered by worksheet change
merge data from two pivot tables?
Event rename worksheet
adding to Context Menus in Excel 2007
XLL Functions from Excel VBA
API - ActiveX - COM - OLE - Confusion
Comparison operator
UK Based data format in ListBoxes
Easy one - My string contains "
Saving the same workbook uniquely
copy multiple worksheet data from 2 different workbook
Find cell text and replace three cell in same row
Need help on Evaluate function
computer programming
Copy & edit formula
Printing
Pivot Multi Page Diff Change
"Strange ComboBox Behavior?"
add tick in listbox
how to select rows after autofilter
Excel print code modification
Access Data from Workbook without seeing the workbook open.
locating specific cells marking location
Load & Access a UserForm ComboBox
Problem with ScaleType propert for Axis object
Adding a Zero
Code for Excel 2007 to hide rows based on sum of several rows not ina range
Copy data from specific sheets from one workbook to another
Code to Quit App Doesn't Work
Windows Task Bar
Return the row number of a cell if its interior color = 50
Extract string w/ 7 characters
Trap forward/back mouse buttons
DSum Criterion
Help with spreadsheet
Formula for Last Cell in a Row with a Value
How do I take the data from a table and format it in a report?
Merge various cells value in one row into one cell
Re: Fixed width parsing with trailing minus
RE: Limiting possible responses on multiple User Forms
FormulaArray - Works in worksheet, not via Macros ?
excel 2007 saveas
Re: 2007 How to get to VBA code section and sheet properties
RE: moving numbers from text into new cells
Strange Open behaviour
RE: 2007 How to get to VBA code section and sheet properties
ExecuteExcel4Macro Error
macro to copy/paste print area
Comments - display on dirty
ActiveSheet (IF statement)
waiting (or pausing) for user selections - nested loops vs. serialexecution
localeSpecificCellName
Remove files
Designating Sheet vs Workbook When Doing Find/Replace
Excel 2007 does NOT keep vb library references ...
Creating a double lookup
Resize issue
Need help with syntax
Before_Print event
clearing cells
Loop for formula on one sheet with reference from another sheet
vbyesno msgbox
Sub parameter passing
vlookup multiple docs & add results together
VBA code optimization - why using long instead of integer?
Addin to open and hide a workbook
Macro for Comment box
Export contents of Immediate Window?
GetValue() Does Not Work
Test for >1 occurances meet same criteria. Display address in MsgB
SetItem and SetValue Does Not Work
VARIABLES AGAIN
How to run a video clip through macro.
Database query.
Copying columns (but cells should be copied in different order)between two files or worksheets
Dynamic Hyperlinks
Counting in sheet
Strange problem writing Excel formulas using .NET
C# AddIn that Formats Cells for Feet, Inches and Fractions of an Inch
How do display a formula
I want to update an excel 2007 file automatically in batch mode.
Add Borderlines
excel 2003 to 2007 changes document dimensions
Getting an Daily Avarage
Working with cells that generate errors
reusing code
Check if file exist based on list
How to create a confidence bar as a function.
Commandbutton question
Bringing data from multiple sheets to the summary page
retrieving data from one workbook to a worksheet in another workbo
unwanted design mode during macro exection
Macro to uncheck the (ALL) item in a pivot table field
Programatically Enable VBIDE Reference?
Word to excel
Help novice
Is there a maximum number of characters allowed in a cell?
Comparing two columns
Copying only cells with data in them
Capture InputBox vbCancel
Code Stopped Working
Import Data from Multiple Sources
Disable Format menu
Where is the "Eval" function located?
Toggle for Macro
I need some changes in a code
make a list of the listobjects on a worksheet
Copying Form Fields to Log
Having two variable's in a macro
Automatically import tables into Excel using ODBC
Macro to automatically add column values when number of rows chang
If formula based on digits?
Length of integer
help pasting data from an array
Too many IF functions
Event not firing
Application.VBE.CommandBars -- Compile error
userform variables
Problem w/ Do While - For Each
sum non contig cells based on hidden rows
Getting total number of used rows
Date problem
Count - Coloured Cells
Add-In has menu for user but not for Automation ?
small function
Select #VALUE cells
including a macro in all workbooks
100% RANGE
Make the cell to be visible
hyperlinks
How to set style in Range object?
For each cell method, is there a much faster way?
Registering parameter/function help for Excel User Defined Functio
formula add value in 3 column
A condition and a variable
sumproduct/evaluate
DSum not recognising criteria correctly
SaveAs using Hyperlink/Path in a cell
Finding outside set range
Finding outside set range
Macro for Condicitional Format
Saving an Excel Wookbook to a Variable?
Excel-MSQuery Out Of Memory error
Custom Views Applicable to the Entire Workbook
"can't enter break mode" error
Dydnamic date in an autofilter
Round up to nearest multiple of 5
CC the Sender in VBA Code
If then, hidden rows
Selecting color number to use in vba code.
What's wrong with this ??
Is there a quick way ?
Custom Excel 2007 Tab disappears when editing an XLAM add-in file
Putting a form into a macro string
Importing Word text into Excel
Copy code from ThisWorkbook using VBA?
Export Excel data and scheduled task
Changing 2 cells based on another cell
Copy from File 1 to File 2
Copy row on criteria
sumproduct vs array formulae
Merge two worksheet with same criteria
Find non blank cell in range and fill the rest with that value
Display input data in separate window
Looping through every file in a folder and opening certain ones in aspreadsheet
Using Wildcards for Folders
how do I correct a "run time error 1004-unable to open" problem?
Cells with Duplicate Name on Other Worksheets
Addin Auto_Open code executes only in debug mode
Runtime Error '7': Out of Memory
Rearranging Data
how to create a URL in an Excel?
Extracting data by data difference
Simplified Code
Opening an Excel spreadsheet from within an Excel spreadsheet
Generate date in cell on changing value in drop down list
Moving active cell in several opened windows
Move Top of screen to Cell
Immediate Window?
Output to .TXT-file?
Adding a "tool tip" comment to a button
Data Aggregation Question...
Changing pivot filter causes chart type to change! Why?
screenupdating and macro status
Sheet access monitoring
We Required PDF to excel conversion software
Update PivotChart Legands
how do i pick ot list from the attendance
Sum cells with specific format
Range name vs Sheet name [again Otto!]
VBA code
custom auto filter
Copy data from Single cell to Merged cell
Variable Filename
help with database
RefEdit error message "Element not found"
Hyperlink programing question
Find all Sheets !
Modify Macro to Include Inserted Rows
code to caputre time in vb in a specific cell
Date range - recognise end of each month
Using Or and And Operators
Excel 97-2007
Format a result
what's the best way to convert a table in Excel to Powerpoint or WORDthen PDF?
What is .OpenTest
Select and then cut and paste rows based on a value in 1 cell of t
How to get the value of a merged cell using c#
Question about Speech
Cell Names
I need to intentionally set a variable to 'error' (iserror(x) = true)
Help saving workbook
Five plus minutes to execute
Copying array into disjoint range.
Extend Selection Question
Exception from HRESULT: 0x8004040A
screen updating file open
App_WorkbookBeforeClose
How to get the first day of the previous month...
working with 2 or vba's on the same sheet
Please help! Database lookup from excel
Unprotect, Run Action then Protect
weird listbox behavior
Finding/Copying Top 10 Items From A List
Email & Format
Value from userform to macro
need help with SUMPRODUCT
VB Code to List all Sheets and Charts in a Workbook
Basis question about Group/Ungroup
Hyperlinks on Ribbon/Office 2007
How to update Excel file using MFC?
Range names vs Sheet name
Match the HEADINGS
How to setup gutter + double sided print for Excel?
INT to ROUNDUP
Adding button in sheet & assigning it to a macro
How to read Excel file in asp/Asp.net/vb/vb.net
Passing the Value of a Cell to a VBA variable.
email macro
Delete Columns
Missing PivotItems
Excel crashes
Time the Execution Speed of Procedure in Milliseconds
Error Calling A subroutine from a User Defined Function (UDF) that
Unable to get the VLookup property - worksheet.function error
Re: Dynamic Charts
Importing Word tables into Excel
Calendar Initialize
Change text in a cell from a command button on a Userform
Formating date ranges for weekends
Macro Excel to automatise the copy of data from one worksheet to another sheet
Old VBA code modification help
Application Level Events
highlight alternate row in excel
How to automatically delete formulas in an adjacent column
Summing Group and insert value next to it
Activate Freeform crosshairs with code - possible?
Mixed format
Using Solver to Minimise the Result of Another Iterative Routine
set an array of shapes visibility
VBA croaks on Nodes.Clear if TreeView is *not* Visible.
List Box Columns - Revisited
Help in VBA.
VB6 Com Addin versus VBA Addin
Presentation quality Excel tables?
Use of CallByName()
Workbook Open Event Procedure
Auto insert a vb module to a new workbook -riv
Workbook size?
FOR NEXT Problems .....
UserForm Control references as variable
Finding data in an area that changes
Paste picture on a userform control
hiding rows containing formulas which return zero values
copying to powerpoint...error message
How to get variables from worksheet code to userform code
Breaking Internal Passwords
Can't Contenate
Defined names
Can I copy data (Values) from one sheet to another with macro
Detect if spreadsheet is opened off the web
Move/reset to the beginning of a TextStream
XL2003 VBA: Debuging...can not break or run in break/step mode.
How do I add nodes to child nodes of a radial diagram?
Return array of page ranges
How to run a macro when a form opens?
Renaming Visible Sheets Only
Unlocking Project When Condition is Met
merging sheets to master sheet in a certain order
Storing multiple ranges using a macro
How do I copy a formula with the cell increasing by increments
charts
How to Save this?
Disabling a shape object
Is it possible to programmatically determine where a user is?
SUMIFs for particular cells in blocks of data
Vlookup problem - unable to get the vlookup property
weird listbox behavior
Macro Fails
error 400, again
Concept question re ranges and calcs
Run Time Error 1004: Application Defined or Object Defined Error
Custom Menus and OnAction
Financial Statement creation Macro from external source
Piping debug info to a txt file
Graphing
Print the date when VBA code is printed
Strange Excel Application Object Behavior
Convert Cell w/ Manual Breaks into New Rows
"Strange ComboBox Behavior?"
How to address elements in variant array?
Making ranges adjust automatically
Excel macro crashes if an entry in a combo box is not in the list
2007 excel formula spellnumber
Execute My Code on Menu Option
Enable Macro on open
creating rows of colored cells from adjacent numbers
DELETE ENTIRE ROW
COPY DATA IN SPECIFIC WAY
dual Y axis
Workbook updated from Access
Create directory on hard drive?
Re: ADO from .xls to .xlsm file - "Unrecognized database format" e
Application.Selection and its items
Re: Spreadsheet or Chart?
Re: URGENT HELP NEEDED
Re: URGENT HELP NEEDED
How to programmatically refrence a .DLL file in Excel
VBA autofilter
Click on a cell and have check mark displayed in MS Excel
found old messages
Delete Empty Rows Macro
Formulas, Please help!!!
Re: Update Personal Workbook Macros when Workbook is opened.
2007 v 2003 compatability
.FormulaR1C1="abc" works, .Text="abc" doesn't. WHAT the?
Method ‘Add’ of object ‘CommandbarControls’ failed
Dialog Box
Message box whilst calculating
How can get values from another cell relative to current?
Controlling the file
Re: Excel2003 Control Array with CheckBoxes
Highlight Cells
Can an OLAP Cube be the â€˜joinâ€™ of multiple Excel tables?
Don't add to range if row already exists
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4
Debug Print
cell totals
Filtering using multiple selected items in a list box
Testing for Code in a Workbook
Conditional formatting
Error refreshing pivot tables in Sharepoint
Re: Select Case by Sheetname Property-String vs Array
Compare and highlight
Weighted Random Selection
Viewing IDL
Link to database
RE: Speedy code required
Create an "Add-In" with changeable forms.
File>Send To>Mail Receipient (as attachment)
Excel 2007 Macro and VB Buttons
Type Mismatch error while checking range value
Save Unsaved File
Mapping to sharepoint drive
Drop down list with ability to add variable input
Setting worksheets not maximized to relative size
RE: Speedy code required
Rounding in If Formula
Re: Pop-Up Calendar
Re: VLOOKUP Returns #NA
XL2007 - checking build version and applied fixes
Help with variable ranges
Clear 4 cells in every file in folder
Re: Marking points read for coordinates
Calling a python script from VBA?
RE: Excel 2003/Excel 2007 Add-Ins Do Not Reset after closing files
Print a Chart worksheet
Re: Compile error - Sub Function not defined
Sorting in 2007
Name of Module from Procedure?
How can I insert a callendar (point and click for date) in excell
Very complex Loop
RE: Too few parameters
RE: Speedy code required
RE: Copy sheets from source wkbk to another wkbk
RE: Macros
How to Modify the style of a picture with VBA
Run Macros based on cell data entry
parse from txt file
Autofilter code and assigning Criteria1 equal to value of workshee
Macro must run multiple times before completion
Looking at each cell when range is selected
Error 91 in Autofilter
Copy Specific Cells To A New Sheet On Condition
Command Button Color Palette
parsing a column of data into a single entry separated by commas
Macro lagging during loop
Using Wildcard in VBA IF
Excel 2007 and Trusted Publishers
#N/A isn't charting in VBA
Open next excel file in directory and stop when no more files list
How to Lock cells and have them be unlocked based on a cell being
Deleting rows
PPT in excel macro
Problem with a macro finding cell values
User Form Crashing Excel
Macro to return user to previously viewed sheet
can I test if a variable is a member of an array
Creating a Dynamic Link from Excel to Word
Copy _ Destination := Range, Transpose:=True? Can it work?
Font size problem in text box on user form
Help with error 53
web browser visible state
Why do I get an error in this code???
Creating a new worksheet from non zero values
Re: Can you open Office 2007 docs in Office 2003 from code?
UDF evaluate string output
Need to make automatic macro changes
Further Protection Question
Calling another macro?
ITEM MASTER
Variation on the protection themes
Can you someone use Copy Destination:= using a transpose element?
Reading values from inputbox into arrays
Scale my excel chart
how to search the upper and lower of a range
Strange behaviour with replace function
wait before executing rest of a macro
Remove Data Validation with macro
Don't move or size the button
DonButton
Putting page numbers into this macro, How??
set cell in one workbook to find in another workbook
using the IF statement
number/text problem
Word opens Excel workbook - how to close it?
Re ordering help urgent!!!
Unprotect Worsheet
How to write STDev formula in a macro
Enforcing Macro-enabled saves
sum a range from a starting point that varies
interactive column width
Enabling macros in Excel 2007
irregular image map
Custom Vlookup Function
Add-in Already Open
Single line of code with line separator
countif or please advice
Countif or please advice
Left, top, rigth and bottom points dimensions in a 3d Chart
Recorded macro fails after save, close, then reopen
To get row id
Sorting and the Worksheet Change Event
excel programming
While doing multiple cell copy paste the Selection.PasteSpecial overrides the protected formula cells
Validation of 2 rows of cells, only 'X' or 'x' allowed.
Insert and Copy
Prompt user to select a shape
PlayWavFile
Excel default module when opening visual basic editor
Pulling files by the creation date
Saving the contents of a worksheet table to an xml document when theuser closes the workbook.
Passing Paramiters and UDF Question
How to leave Selection.Sort Key open....
Excel Sheet Unviewable ~ able to open, but sheet proper all blue
Using Replace to remove part of a string
User form varible passing
Run the macro until activeSheet.previous.Select = Sheet2
Save as Macro
Save as Macro
Excel Form for updating records
Hide text in a cell.
drodown selection
Subtotal macro in each worksheet
assign the formatted cell value (date) to another cell?
sum values in multiple ranges
my macro is remembering specific range instead of 1st to last
dictionary count is greater than number of keys?
Can I abbrevate the following (would I Dim and Set it as a Range?)
Have a problem with "Find" code
Copy data from all the file file from a folder.
place cell value in header
Deleting columns on multiple sheets
Copying results to clipboard. Is there a better way ?
Socket component in Excel 2007
adding all the cells in a group of cells
Macro to insert multiple images at specific cells and resize all i
disappearing querytables
run time error 53
Macro Code not reliable
InputBox methode
May I called a Programmer if...
Using a value in a cell as a Reference in a formula?
Save problem with multiple workbooks and event workbook_deactivate
Requesting Help Please on Auto Worksheet Setup
Find all in one sheet
Place wingding on specific coordinates - possible?
How do I convert an Excel template to an Outlook form
Add subfolders and name - Possible?
Text box date format
Mutiple comboboxes on user form
beforeclose
=IF Color
Create scripts from Excel
Autofill with Column as a variable
Assign Web Query Result to a Variable
Function writing cells
combining several sheets together
Ribbon visual state gets refreshed when multiple like workbooksopened
look up
Changing number format to remove %
Inserting a Row after finding a Name in colum
AutoFit
Custom function to find top sellers
Find Column Letter - When column header is found
delete and replace
How do I Get a String... or any variable for that matter?
looking for true result if number is a %
Object variable or with block not set Err 91
CONTROL WORD FROM EXCEL
VBA Auto correction Issue
Help with UDF to search through a table
Macro to insert Rows
Chart Question Using VBA
Macro to find and log all formula errors on all sheets
Sound files VBA programmed from Excel
Cannot find macro file
Assign a folder path to a variable
Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
Update a cell based on the pivot table refresh date
Can you set 2 ranges to both be from the same cell?
Getting new empty row ?
run time error 1004
Disable "On Open" macro
Run-time error when path parameter changed
Disabling clipboard prompt
RE: checkbox for commandbar
Filtering Dates in a table with input boxes
VB macro code does not save
Looping though sheets in workbook
Problem with (One location = Another location)
type mismatch
Check boxes in drop down box
email code
Macro for adding text from one cell to another cell
Terminology Clarification: Is It Correct For A Spreadsheet ContainingVBA Routines To Be Called A Macro?
Sub before and after 'Get External Data"
Problem formatting header font size
Creating a table based on user input
automatic change cell's colour
Go to Error (what is this? Is it for findign #DIV! erros in Excel?
Sort Sheets
VLOOKUP!@#$%^&*
WorkSheet Selecteion Chage Event to prompt Input Box
deleting rows based on criteria
Determining which Print Button was clicked
vba xcel
Selectblank cells
Command button executes without code???
multiple ranges in cell notation
capturing the values from a combo box into an xml file
RE: Find Text in Cell and Copy
Refresh Pivot Tables without refreshing functions
Adding time by a Numerical Value
Macro not running correctly
Attn: BOB BRIDGES
Find/Delete skipping rows
Assigning string values to a range
Error when running VBA Help's Find method example
Print Area Pivot Table
selecting relative ranges
maintaining the value of a variable outside of an if construct...
Expected end of statement error
Delelting previous row
The best way to import data from Access (Performance) ??
Path Name issue for file opened from Z drive
Selection.Value Error when multiple cells selected
Sheets to new WorkBook
Some Excel dates can't be imported into sql server?
Adding sount to a macro
Paste year as a specific date
Boolean Variable Definition
List Box
Follow hyperlink to show form
Adding sound
excel date format problem
userform comments
Find first non-blank cell
Restrict Prompting for Macro Security
Unload a UserForm
Copy All Workbooks Sheets(2) Formats & Values only from Folder A toFolder B
Re Post - Please Help (Excel WebBrowser Control)
Divide two numbers in data subtotal function
Rightborder
No borders/gridlines around some cells
Graph with variable range
xlDialog to select Cell/Range
MACRO QUESTION ????
Using case
Increase the number of lines buffered in the Immediate Window?
Get rid of SaveAs prompts
VLOOKUP Object error
Vlookup and print loop
How to store formula in Access table ?
Show userform from another workbook
how to "synchronize" VBProjects & VBA.Userforms?
highlights cells that are not a dependents
Auto set value/formula in entire column cell
Macros
Loop through files in a folder and unprotect sheets
Updating path in defined name
Formatting columns of data with alternate font colours
Copy Destination parameter issue
Access a Variable from the Worksheet
How to create a function?
Validation list driving macros
Workbook_Open Event won't work
Storing configuration data in XLA file
filtering unique value
How do I activate the visual basic editor in Excel 2007 ?
Re: Splitting one single cell into pieces
Re: Splitting one single cell into pieces
Copy Formula down x Number of rows
remove button
Excel to Word Macro
RE: How To Insert 3 Rows and Total
Need general directions
Find Column without Changing Refs in vb
ComboBox last selection
VBA - UserForm Reset Option
Excel XP: sending data to SQL Server 2005
Worksheet Listbox selected item?
Formatting cells within VBA
"Compile Error: ByRef argument type mismatch" when calling my function from another module
Copy Column data to Page Header
RE: Challenging Task Ahead
Iterative process of running queries frequently abends for no clr.
What am I missing - Workbooks.Open
baffling find method problems
What am I missing (Opening Workbooks)
Const or Variable that doesn't change
Need Help in cut/paste data from text file to another using excelmacro
Find Cells with Specific Format
Macro for Opening Reuters, Opening Excel File, Closing Excel File
Select method of Range Class failed
OLE Question
VBA: How do I find a value within a selected range?
VBA:
Wait time between Saving and other activity
Formula, quotes, and variable
how to use variable that should be in "quotes"
Programmatically removing data filters
Inserting Rows - Complicated
Filtering with VBA
Click Colored Cell -> UserForm.Show Question.
Importing XML through web-based query
Get All Files from a Directory
How to use the worksheetfunction Vlookup
Slow spreadsheet
Trying to get worksheefunction match to work
How to retreive the name of a named cell in an excel macro
MATCH
Sendkey not working
Combo Box Event code self triggering??
Problem using Copy:=Destionation across different workbooks
ActiveX Toggles
Tab between ActiveX controls
Launch Excel On Event?
RE: What in the edited code below makes it crash?????
Macro To Avoid Link Update of Open Files
Using VBA to sort a column of data
Using VBA to sort a column of data
Finding the first cell in a column that is not hidden
Why won't my loop recognize empty cells?
RE: inverted commas
Something in this is causing a crash
Application.CutCopyMode = False
RE: command button to run an Acess query- I know this can be done
Creating new workbook from different workbook
Re: What in the edited code below makes it crash?????
Add a name based on a number
RE: count unique values in a col
Re: Trying to cobble together two bis of code (Unsuccessfully)
Prompt for cells on open
FUNCTION SYNTAX
using filename or a cell value for a custom menu
Date format cannot change
editing/deleting text
find concatenated values question
Substitute the value from another Workbook
Vlookup to a table on a webpage
Copy text box contents
memory problem of Excel 2003 copy & paste
Listbox problem agaie