Excel Programming [Archive] - Page 38

How can I increase the capacity of a listbox?
Improve code that checks a range of names - currently using Activate
Predict based on range or series
Changing Series Colour with VBA??
Confirm Empty Cells in a Range
=IF Formula to find both < and >
Letting buttons depend on the sheet?
Custom Angle and Alignment with VBA
Compare 2 files and show deltas
Need Macro to take me to a different tab to specific cell
LIKE won't work in VBA/ADO app
duplicate a row with a macro
How to get number with in order
linking excel data into Word
Web query
Excel 2003 to 2007 Migration Question
Programmatically determine if Workbook contains Macros in Excel 20
Place formula in cells
date format in CSV
Dialer.exe - I am actually trying to get dialer.exe to dial Excel cell phone numbers. I am using Excel 97 on a XP Box.
Automatic, conditional chart creation from separate files [Excel2007]
XP Problems with SendKeys - dialing a number in an Excel cell
Macro that adds up the sheets of similar workbooks
Ignorance is not bliss
Resourcing and counting staff
Unprotect the sheet
Personal
if cell contains this AND that - like operator?
ComboBox question
Need VBA to remove command buttons
AppActivate / Minimized Windows / GetWindowPlacement
Query & IE7
Offset vs. Range references
RowHeight and AutoFit wit Merged Cells
Need macro to copy active sheet to a new workbook
How to disable TreeView screen update?
Changing value of Node.Parent destroys .Bold property of entireancestry.
How to return to worksheet where macro started?
Advice on correctness of using subs
Userforms in Excel
Custom ribbon dropdown
Open PDF File Using Reader 8
ActiveX control button hint
Macro to Break Links Before Saving Sheet
Resize comments with only picture.
Move Control with Scroll
Userform Text Box Formatting
Call a Private Sub using a variable
Dialog Box and Save As Location
HOW TO PUT MSGBOX CODE IN MACRO
Please can anyone help me? Big problem with date format.
Arrays and Loops
How: Marco on Pivot Table to save as file up to 300 files
Activate data according to the value key in in other cell.
Help Command Button
Import query from access into excel via vba, but will not refresh
reset all pivot field properties
Copy formulas between workbooks without copying links
Activating a BAT file from a HTA
Backup to multiple locations
Call sub from worksheet_change
Are the Windows.Arrange ArrangeStyle:=xlHorizontal settings persistent?
commandbuttons won't trigger code.
datacontrol grid problem
Reload from DDE
Getting duplicate names
and, or in vbe
Allow macro to work for a group of cells but not the other cells
Date sorter
Formual/Macro Help
macro help
Excel Calculation taking too long
Conditional Formatting driving me nuts
my macro won't run
Merge all files in a folder
Column re-arrange in a worksheet (Macro help)
Check for wrong cell content
Workbook_BeforeClose
Workbook_BeforeClose
Errors when using range names in VBA
How do I make an absolute ref in a macro able to loop?
apply cell change event to single column - WorksheetChange Event
How do you record a macro
Text box control does not respond to mouse scroll
File Location Based on Cell Reference
Set Error handling INSIDE error-trap
format columns as Text while using "Workbooks.OpenText"
reading values from multi-area selection
Custom Calendar Help?
Where'd my code window go?
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable
Error Message
VB Lookup Syntax
Copying Worksheets
Command Buttons
Upload data in User Form
Override Excel's Heroin Addiction to Calculating
Thesaurus Find Function
sort problem
Subtotal Group Titles
MACRO TO MULTIPLY AMOUNTS WITH PERCENTAGES
On Error Goto
Open two tiled windows on workbook_open
Suppressing dialog boxes
object required
Make text in a cell appear in a footer
Sort Macro (2 levels)
Input Message
Excel vba to SharePoint 2007
Find sub-str in a cell.value
browser gives run time 1004 error
macro confusion
Add Custom Worksheet Control To Toolbox
Copy Formula Issue
Formula or Macro for CF
2 Questions
Get date from prior sheet and add 7 days
Copy Data between Worksheets
A point in the right direction...
Copying Excel Data Into Outlook via macro
Macro to get Amount and Date
Sort macro error
Simple Autofilter
Instr syntax help
Bug with DATEDIF and Md is it possible ?
List Box - Select an element?
macro on pivot tables / pivot items
Inputbox
Macro to copy and paste values (columns)I have a macro file built
request help to combine two similar macros
Preview of a Excel-file in Outlook 2007
Testing for validation property
[Excel '03] check-box menu items and cell context menus don't disp
Workbook Openning
Really strange!! Switch/Open code fails occasionaly?!
Calendar Control Missing ??
FileDialog Filters.clear
Convert data to array
Bulleting and Numbering in a Cell
VBA Form integrated into sheet
adding calander control crashes excel
Conditional Formatting
How to AutoLoad Macro
Code comonr to all worksheets
Convert Hours and Minutes
Insert Date and time in Cell
Need help combining
run time error 1004 only on web run
French Words used as index
Suppress prompt upon installing an addin programatically
Selecting A Cell Value And Displaying A Popup Or Tooltip
Office 2007 Excel security stronger?
Passing argument from cmd.exe to Excel VBA
Procedure calling syntax
Control Worksheet_SheetChange Events
Pulling Data from one sheet and grouping it on another
Repeating Rows
Links to password protected workbooks
populate array with list of named range
macro to run IF condition met
Too many nested functions problem
run time error 1004
text pop up box
what is sorting script level
Export multiple datatables from a C# form to Multiple Excel sheets
Macro conversion from Lotus 1-2-3 to Excel (Sort Macro)
Combo boxes (Swines)
combo boxes (swines)
Selecting Rows based off certain criteria and deleting all others
weird loop problem- extra rows dissapearing
Auto_Open from Outlook
Run and edit a Macro
Cut and paste if conditions are met
Subscript error in 2007 when testing if Addin is installed
Macro help
simple cell formating question.
Delete selected Item from listbox
Help Please
Autofilter
Counters
why can a pc open file but not mac
Validating Data in User Forms
Disabling Autocalculation when opening CSV files
Find data and copy and paste
Refresh background query in Excel 2007
Can I automate the launch of a macro using the result of a formula
Problem using VBA for Excel to protect a Workbook with a password.
Using VLOOKUP and HLOOKUPS with named ranges
Geting around XIRR error
Macro to close without saving
Problem with Workbook_Activate event
HOw to create the progress bar in excel through vba.
Removing confirmation POP from excel
RE: Removing confirmation POP from excel
Macro to break one row of data into multiple rows, with calcuation
RE: Removing confirmation POP from excel
RE: Removing confirmation POP from excel
RE: Help! I need a macro to check dates and autopopulate cells
C#: Adding OLEObject--how to set object properties?
EXCEL VBA
Text and formula in a same cell (Excel)
Load UserForm ComboBox And Autofill 124 TextBoxes
Iserror with Search
Excel process slows down
Very strange indeed!!!!!
Buttons and macros
Design question
Need help with a date
Excel VBA advanced course, London
Retreiving only numeric values from a string
Is it possible to make a workbook "undeletable"?
Compiling Spreadsheet Into Application
listbox
What Range was Missing
Excel automation in ASP.NET, error 0x800A9C68
How do you get the Invoice number to print black
Command Button
Excel Macros Tie Up Computer
Send e-mail option- delivery to route to group mailbox
I need a macro to run on a set condition
Blank cell with Formulas
Loop through charts
Need help with Calculations
Auto increment a cell
Add text based on imput in another cell
Send mail with outlook message options-Delivery OptionS
Problem using multiple criteria to get a count
Latest Office Automation Techniques
Improve method of calling a private function in a private module
Visual Basic Copy Clipboard Paste as KeyStokes
BeforeClose order of events?
Compare Rows
Running Macros in a Shared File
formula for last cell
Group worksheets
method or data member not found
excel macro and java applet
help with macro
Use VBA to copy macros from one workbook to another
converting date combobox to show date
If extension of a path in a cell is .pdf then
RTD methods in excel called before workbook_open event
I'm having a problem with excel formaula... need help?
Problem comparing dates
List Box Populating problem
get access data using ADO from an password protected mdb
Log web data
Chdir does not seem to change the current directory -- ??
Tracking 'last written to' range
Lost in the shuffle: where is my old NG page?
drop down menus
Convert VBA to well written Excel formula or similar?
How do I know if user is pressing a key from the CommandBarButton class
Excel Range calculation breaking application.calculate - horrifyingproblem
distribution of work
Mismatch Error
AutoFill to start with Selected Cell
Open or switch to a file
Last modified user
VBA Currency datatype and NumberFormat
Re: Excel 2007 Compatibility mode error "Not enough storage to process
Related to Excel-2007 MACRO
Update Pivot page field from a cell entry
Can I refresh more than 1 external (web) query data at once?
excel names in a group
Get Names of ActiveWorkbook.CustomViews
excel VBA text
How to export a linked cell sheet to get only values.
Excel XP VBA Called Dll , throw Run-time error '-21462
RE: COMException 0x800A03EC Whn Calling CheckOut
COMException 0x800A03EC Whn Calling CheckOut
clear user form after entry
Golf for a league (teams of 4)--Help
Delete chart without being prompted?
Command Button to Swap Cells
relatuve reference
Excel and Shift-JIS
what is the not equal symbol?
Creating gallery in dynamic menu
Create a subfolder in Outlook contacts called delintel
Macro Help for Filtering
set of dependent list boxes
set of dependent list boxes
Confused about the ListBoxes.
Ribbon displays labels even when showLabel is set to False
Time sensitive please help..
Error in Personal.xls - calendar
Re: PrintPreview in I.E. ???
Delete every other row in a 2007 spreadsheet
RTD update problem with Excel 2007 when Excel is not the active ap
Moving sheets in code
Format font base on DirectDependent address
VB Code
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
How to Reference a Cell
If File exists Then NewFile="XYZ"
Send mail with outlook message options-voting importance
Matrix Creation
Font format according con cell content data type
Excel 2000 vs 2003 date format issue (reposted)
AutoFilter Selection to Change Page Header
Adding to Excel menus
Re: compare and paste macro
MAJOR PROBLEM! --- Menu Bars don't unhide?
Text insensitive formula
MACRO HELP NEEDED
method or data member not found
Matrix Import Help
vb for nested if with more than 7 statements
Excel VBA drawing Arcs programmatically - not lining up!
Macro Needed to pull specific columns from worksheet
Copy Sheet
How to set a textbox to be a print object
I need Help with VBA link between Poject & Excel
Specific Mile Calculation
Indent and format based on Col A
Deleting non-alphanumeric characters
change in the formatting of data series
changing font size of chart title
email macro using sendto
Unexpected formula generation using named ranges
Loop through folders
Asterisk in VLOOKUP search
RE: Deleting a command button...
Miles Calculation?
Set statement for non active worksheet
Replace in ranges does not work.
Named Ranges Disappear In Excel 2007
Sharing information between classes
looping problem
Inconsistent behavior of listboxes
Needing help with code in a macro
Excel crashes while adding calander control on form
Resizing Image in Excel, Saving to Sharepoint. Size changes
Loop code, capture exceptions, and display pop-up
Type Mismatch Error
RE: Mouse Over PopUp display Lookup Result
Select Cells in a specific Row
loop on pivot items
SUM a row of data and then use VLOOKUP to paste the total value intoanother worksheet
RE: Can't get pop-up calendar date passed into worksheet
Re: Web query problems
Re: name prefix for DA
Excel2000 worksheet Change event doesn't work in Excel2003 or higher
Font.Bold Property slows down macro
Changing values in column 1 and 2 based on values in col 3 & 7
RE: Can I simplify my Modules
RE: Open a file in 2003
RE: SumIf Calculation in Code Problem
Error handling part way though code
Re: open new workbook
Re: open new workbook
Re: open new workbook
Save as Shift-JIS?
Listbox autosize?
Sorting question
User form issues
run once function
Unshare and Reshare a workbook
button to seach columns for blank cells, then sort by two columns
Alter ribbon button label on the fly?
vb code question
Inserting Cells
Who opens my file?
Print Preview - 2 pages
VBA Newbie
Why so much non-OOP syntax in VBA?
Stock quotes from web site
command Button
automatic macro
Entering values into a ListBox.
Counting Rows in 2007
Check for format in form field
Can XL send email via Novell Groupwise?
modifying countifs
Automated Excel Workbooks and Task Scheduler
Shorter 'Or' Statement?
How to make a public function procedure with undefined number of r
colour cell on condition
Excel 2003 'SpecialCells' VBA cell Selection - how do I do this? Helpneeded please
Getting values from other applications
Using browser to login and fetch CSV
Cell Format
Input Box Trouble
Filter and select the upmost rows
Excel VBA open with Password
format listbox columns
re-visit old question
Identifying rows in a message box
vba newbie - explanation
Script: Clmn A = Row Number
Text Box as opposed to HourGlass
Comparing cells written in text to cells producing text from a for
Worksheet_Change event very slow
How do I assign large number of named worksheets to a varArray
Excel 2003 to 2007 Gotchas ... so I can be prepared
Formula
Hiding columns in a named range
run a macro to extract hyperlinked sheet to new workbook
Macro to record data monthly
Import csv to different tables
IsNumber (in Rick Rothstein's example)
counting only results in a column of formulas
Import tasks from Outlook into Excel
Macro code to set range
Hide Custom Command Bar if Workbook opened Read-Only
how make an angle to show in degree, minute,second instead of degree
Timeouts on VBA code
XIRR and #NAME? Error
Close 2007
error with oleobjects.add
losing Application.FindFormat.NumberFormat after finding first cel
Detect Delete
userform property change race
Getprivateprofilestring Crashes in Vista SP1
Excel 2007 Print Preview
Excel 2007 Sorting Question
From SelectionChange into UserForm
macro to add button to a spreadsheet cell
How to quickly name cells in a row using VBA?
How to dynamically modify unserforms
Require data entry in column before moving to next cell
Referring to a relative cell within a function
Lookup Formular on Table
Open Excel sheet, modify, print and lock
Use VBA to get values from named range that contains an array formulaexpression
Edit/read from data base
Auto List Members
sort data and copy to another sheet in a different form dynamicall
summing a range if it meets criteria between 2 dates.
Need help creating a TRIAL version of an EXCEL template
Catching Ctrl+clicks and getting to the selection
Extract time for comparison
Select same cells in all worksheets
Problem With Recording a Macro in Excel 2007
PLEASE CAN ANYBODY HELP WITH MACRO
SaveAs command
How to use the Worksheet Change event to monitor if cells haveerrors?
Refer in macro to cell
Varible scope
FindNext Errors
Get max & min dates from column
Compare 2 sheets against 2 colums
Static references into variables
help with dates on form combobox
can i send excel workbook as attachment form excel.
lucking a cell automatically ...
Lucking the cell during operation automatically...
Retrieve value from .Shapes.AddFormControl(xlDropDown...
Permanent Date/time entery
Urgent Help
Formula and Macro Needed
make a spending tracker sheet
ActiveCell.Value
Hot Key on Menu Bar
MACRO TO DELET ROWS DEPENDING ON CELL VALUES
Automatically create worksheets by entering a number
UserForm
Cannot Update Links ??
Text To Columns Looping Macro
vlookup using contents of clipboard?
List property
Run Time error '1004':
Deployment of XL programs in 2003 vs 2007
Problem with VBA code - Can't figure out what is wrong
Excel 2003 sticks to the low macro security level
Can file history be seen in Metadata?
Counting Conditional Format colors
Ranges - Location InTable
Adding random #s in a range to equal a specific #
Delete cell value in ColE based on value is ColA
How to copy and paste multiple files
Copying functions and formatting
Amend sub to read from names in col A
group 3 optionbuttons and call them
Automating Excel and closing program
Sheet disappears from Project Explorer
Code to get the Active worksheet on change of worksheets
Help - Loop Function Giving Incorrect Output
Chart difference between Excel 2003 and Excel 2007
Comparing cells with text to cells with numeric values.
Functions
How can I use excel to accurately predict A4, & A5 ?
How to program move one cell down and copy?
supress/answer "name ... already defined" msg when overwriting w/m
macros on an invoice
Autofilter
Unique Random Numbers
This workbook contains links to other data sources
ScreenUpdating and ATPVBAEN.XLA!Random
Select Case - 2 causes problems
Assign ChangeEventMacro to unknown SheetName
Ineed a combo box to change its list dependant on the active cell
searching for data labels with specific text
Problem with ScreenUpdating Property
hi, how to compare two string values, if the string values r from inputbox in VB
Method range failed
Need VBA Code
Help...first time macro user question, loop needed?
Macro Help
Use Dir() to fill out missing components from Path?
add to listbox
I am new to VBA - Help needed on Macro
Call parameter query in Access from Excel VBA?
merge
PLEASE CAN ANYBODY HELP - MACRO NEEDED
Column Breaks
Cubevalue (Excel 2007) versus Cubecellvalue (Excel 2003)
Excel Programmatic (Existing) Workbook Access in .NET 2.0
Sort Current Worksheet
Using IF EXISTS inside CASE block in SQL
password & Links
Why does Range.Group() method crash after 7 calls?
Pivot Macro
Update my spreadsheet with MLB team records?
university courses in VBA
File Size Matters
PivotCaches.add Difficulties
Auto_open won't run on multiple files
Sub to copy n rename book according to list
Have code, need to travel
Compile error using array
additem
Copy data from one sheet to another in Excel
How To Use The Number Part Of A TextBox Name As A Variable
How to count rows with text
A macro that deletes all green triangle error indicators in workbook
vb code question
PLEASE HELP MACRO NEEDED
Reading file saved from Excel as Unicode text
Background Processes in File Save versus File SaveAs
Attaching an Excel Worksheet as An Object...
Merging 3 rows of numbers together
Force to run maximized
Select Leftmost Spreadsheet
Many to One Lookup Match in Drop Down List
MACRO TO WORKOUT PERCENTAGE
Troubleshoot formula's between 2003 and 2007
Vlookup not refreshing data values
How to delete that row if same cell in preceding row is identical
BLINK CELL COLOUR OR TEXT COLOUR
Range.Group() method fails after 7 calls
Save As Macro options
Message box and Save as Macro
VBA Excel decimal formating problems
Adding a calculator(Numberpad) to a text Box
comparing abr. Date Text cell to a date formatted cell
Macro Help
joining spreadsheets together for reports and queries?
Query
Selecting Range of Cells
Workbook_Open() won't run macro unless breakpoint set
Need Help With My Loop That Creates Output File
PasteSpecial failed
XL 2007 records print command as XL4 macro
Sort and Extract Macro
Sort and Extract Macro
Automated add-in UDF lookup in Excel 2007
why won't this work???
VBA Routine to split cell data...
How can I protect cell from user entry but able to alter/clear in
Code to do edit checks when user moves out of a cell
Savepicture
Choosing Multiple items from Data Validation Lists
Calculate command
Getting <Title> out of HTML source code
A puzzling duplicate data issue...
Is string allowable as a file name
Modeless UserForm
Add Row after last entry
Username
Is there a VBA command that will keep an program always on top
Listbox data
Macro to compare names
Help getting next sheet
UDF for multiple heading indexing
auto_open problem for Expiry date
Dropdown menu
Non-modal dialog tracking Ctrl+click'd selection
Conditional Formatting via VBA in Excel 2007
Worksheet_Change doesn't work
Macro copy data into another workbook
Getting the function name (NOT SYMBOL NAME) - not quiteapplication.registeredfunctions...?
APPEARENCES DURING THE MACRO RUN PERIOD
Chart Deselect in 2007
open then modify file via hyperlink
Copying worksheet into another worksheet
check lettered ticket number
Excel 2007 Chart-Objects don't work properly
Vista has broken my SHDocVW
Workbook before close
Vba code
entering value in a cell
Where am I going wrong? (losing the variable because of need for quotation marks)
The specified device is not open or not recognized by MCI -"mciSendStringA", VBA
Compare two columns, delete rows that match?
VBA / Formula
Help with Vlookup of Find date
replace copy and paste
Using More than 7 possibilities in a formula
spread out fields in different column
Protect a sheet
Macro for e-mail
Previous active cell
Code format question
How to link PP shape to individual sheet in a workbook?
Refresh form
Insert new row after a name range
hyperlink to password enabled website.
Textbox
VBA - before delete
median of combinations from values in a column
Get Dimensions of Image File Outside Excel
Ignore a sheet
If ...Then Statement
Highlighting fields based on a dropdown in Excel 2003
Shorter way to create multiple identical Event Procedures?
xml toolkit not working in Excel 2003. Why?
find box
Excessing excel error responses
How to delete the duplicate pivot cache.
Task bar
Controling a Pivot Dropdown
Objects/properties that don't trigger the intellisense
The web retains focus after Excel is launched from it
need help.
Combo Userform
Copy cells & sheet name to master sheet
Cell color
Excel 2007 Macro Security
Call a callback to toggle a tab visible/hidden?
Select Cell when hover over action hotspot
Can't paste today
Dynamic List box
Revision clouds?
Dynamic comboBox on Ribbon
hiding columns in grouped worksheets
Computer freezes when user clicks "enable" macros
Command Button Changes Data Each Time It Is Pressed - Want it to workonce per worksheet.
Insert text in cell using VBA
Format Selected Chart
Workbook name is read only property?
find workbook names that are in sheet
How to set page orientation to "landscape"
Dates US and UK
PopOver Help
Change colour
User-defined type not defined
Macro: Copying to all possible rows
cell ref in a formula
XLAM for global macros cannot be run
Find End of List
Info about "Office Developer"
Final space removed when moving to Object variable
Change column headings or freeze row 1
RibbonX Separator problem
Pivot Table - VBA
Userid
Protecting sheet through vba while allowing some actions
macro to change number format of a highlighted range in Excel 2007
Macro to mail and save range from one sheet
Class Module Method
Error Message - VBE6EXT.OLB could not be loaded
calculating percentage on timevalues
macros -enabled Workbook is getting slower and slower!!
Automating F2 to edit
Listbox
male & female lists
charts, data in arrays, can same be done for ErrorBar figures?
Avoid multiple select constructs
Error Handling construct
Combinations Sequence
Lookup value
Sending a date from VB2005 to Excel
Calendar Control Drops on Distribution
PLEASE CAN ANY BODY HELP
Opening hyperlinks in separate windows
Triathlete Club Needs Help!
Lookup value
ADO recordset: Convert RTF field into plain text
Taking hours to save excel file
how can i no margin string in listbox from left
Chk sheet exits, copy all to another book.
Edit VBA Code without opening the workbook
Do Not Export Button Objects
Address of cell invoking current UDF call?
Why am I losing my Range object?
Extract a section of a text string to anew column - Excel 2003
lock a workbook until certain cells are filled
Is it possible in Excel to have the result of a formula hide rows.
Remove end folder from path found with ThisWorkbook.Path command ?
Simultaneous scrolling for 3 worksheets.
Unselect Forms Toolbar Listbox
Recognizing When An IE window changes URLs and closing the IE wind
Find filename of open file
copy several files into one file
"Dim" query
VBA Checkboxes
Need to create table that shows last rolling 30 business daysdifferences on 4 accounts
check for numeric values in a column
RE: Automate Pivot Creation
VBA Code to go to one Bookmark.
RE: Vba Password
IsBlank() in VBA code?
asset allocation optimization
Password issue
How can I unprotect multiple same passoword worksheets at once?
combining multiple find/replace subs
ADO Field Size issue
Automatic Conditional Row Deletion?
visual basic code runs very slow in 2007
On Change Event and Intersect
Macro to hide rows?
FileSearch worked in Excel 97 but not in Excel 2003, how to fix???
Split Workbook based on user Input
Re: Sheet names in a MenuBar menu
Re: Sheet names in a MenuBar menu
CAN ANYBODY PLEASE AMEND MY MACRO
Dates in SQL query won't match
macro: Copying to all possible rows
Re: Sheet names in a MenuBar menu
Protect cells based on Date and previously entered data
Calendar Control
calculate time if greater than a given time
Read value from text file line, process, then Loop until EOF
GetOpenFileName to select a .URL file
disable objects on form
Excel 2000 open using C# error - Unable to cast COM object of type
Textbox
ToyotaKV
Format Cells with VBA?
DELETE DEBIT AND CREDIT FIGURES ROW BY MACRO
The hunt for the disappearing textboxes.....
Copying cells from one worksheet to another, within the same workbook
Adapt code to copy out pictures as well
'object disconnected from client ...'
Find WkBk Path, Then use this path to open another WkBk in Subfold
Last Item of Listbox not getting displayed
Using CREATE TABLE DDL on Excel creates two tables
All macro are disabled due to encryption?
VB CODE for password protected sheet to release part of the worksh
Protecting Workbook on Network while Allowing VBA Updates
Switching monitors
Automation:Selecting a different worksheet from another excel work
List Directories and Subdirectories
copying rows to all possible records during a macro
Copying worksheets - loosing range names
Inserting a row in one named range and having it update another
Link Sheet tabs to Org Chart
Stock Quotes to Excel
RE: Points, pixels, in, and fonts
Printing what is between tags
VB to run a .exe file
Using RIGHT function to get right-most digit for each cell in acolumn
How do I bold entire row with an asterisk in the text?
MS Internet Transfer Control
How do I refresh user defined function data?
Programatically set control source - not working
Random selections with criteria
Row Height and Printing
Toggle Command Button to Show/Hide the Shaded Headers Columns
distinguish Range and "Single"
Excel 2000 vs 2003 date issue
Re: Excel 2007 - Deploy a function across the network
Copy A File From Internet To My Desktop
Solver dialog box
query code failes on different PC
INDEX
Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction
A macro to deactivate Input Message textbox without deactivatingError Alert messages
Microsoft Visual Basic UserForm 2 columns, Excel 2000 & 2003
Error after chaging file access in Office 2007
Re: Pivot Tables in VBA: Problem with AddFields Method
Re: Sheet names in a MenuBar menu
RE: Selecting tabs - tab names given in a list
Make a copy of a sheet and add it into a new workbook?
Help with vlookup
bir hücredeki sayıları başka bir hücreye metin olarak yazdırma
Referencing Sheet names/numbers
Query Help
Formula/Function to lock and unlock a cell in excel
Re : Excel AutoFilter being Toggled of VisibleDropDown
MULTIPLE CALCULATION
CALCULATION IN BACKGROUND
Formatting in Text Boxes
A little help for a newbie
Standards and tips for VBA
Selection.Cut Selection.Offset(1, 0) HOW to understand this code
RaiseEvent Problem
sorting with a macro
Shade date headers, if Weekends or Holidays
data pulling with sharing violation
Macro to add the " symbol to the beginning and end of cells selected
Can I blanket update all controls inside a frame?
Lookup help needed
imagelist filling at designtime
creating labels using MS exel and MS word mail merge
Cells will not change from text format.
VB CODE for double click?
Copying Worksheets with macros
multiple web querys
Extending a range selection
VB CODE for moving the range of cells down by one row?
VB code for Active cell to the last cell
Replacing formulas with values programmatically
Menu disappears when selecting a graph
Save & Load A Range
Record Name of Workbook on Close
How do I lock certain cels i a worksheet
Need help with a formular ?
Paste-Transpose macro needed
Automation Server Events Usage in VBA
Can an array be redim inside a for loop?
array of labels
archery scores templates
Get Folder Name
How to enter a macro that performs when a file is closed
Help please - real beginner at form code
page problem
Code for form
Displaying active cell in particular position on screen
Date formatting
Pivot Tables and Macros
HOW TO SELECT RANGE IN MACRO
Error control dont work!
Cecking for duplicates
copy and sort data then past in specific area on new sheet
How do I loop in EXCEL !! Pls EX-cel-erate me!!
Lookup Macro
How do I loop in EXCEL !! Pls EX-cel-erate me!!
Can I change the format of a control at Runtine?
How to align decimals in a Listbox
Is there a way to view the VBA code dynamically...i.e., while usingthe record macro tool
ComboBox Query
xla and add-in
clear data and named cell
Can Chart Refresh be Disabled temporarily?
What's meaning of the Number Format?
HyperLink function runs wild when unrelated column is filtered
urgent help required.
Want to select row
totally newbie question about macros and programing it
Listbox
MAKE SUBTOTAL APPLICATION ON AND OFF IN MACRO
HOW TO SELECT SPECIFIED RANGE IN MACRO
Funtion as Matrix function?
why is this form code not working
Activate Excel application event
Checking the connection to a network Share
Is this a valid IF statement in Excel?
Macros dont work when file used on another computer
Copy dynamic range
Avoid DIsplay of links
Extracting Values and inserting Rows/Values
Unlock certain cells based on ColorIndex
FTP MVS to Excel
Application.StatusBar or equivalent for user defined functions
get cell value where offset cell = X, use this value to populate list
Not exporting controls to a new workbook
Problem creating PivotTable from ADO recordset using VBA
Day of year (Not Julian)
Initializing Form Controls
Worksheet Protection Question
Automatically resize a picture to a cell
Why null reference to ListBox?
how can I make a graphic that have two scales?
CONDITIONAL FORMATTING TO VBA. Row format based on cell value.
replace special character for filename save
Moving the last character within the cell so it will be the first
HIDE-UNHIDE VBA MACRO
Help with VBA Code - once again
execute a make table query in an access database
Show Image When File Opened
undoing a pivot table
Show Image When File Opened
Letting users calculate Excel forms on the web while hiding the logic
Run code based on version
What is missing from this form code?
Problem with formating
VBA code to run & wait for cmd line interface application
Excellent resource on line for the Ribbon
Before Print Event
sum certain columns
listbox
Get Text Value of Dropdown
Limit an GoTo Function command
Macro
Help Needed in Macro
Hyperlink Help
Bug? Unwanted date format pasted on two sheets when csv file importedin excel using ADO
Shell or shellexecute
how to plot a chart with 3 axes?
Multiple Conditional Formatting in VB
F8
how to export a column as text separated by comma?
Insert a line at the bottom page
Variable not set
Deleting excel rows based on multiple criteria
worksheet_change not working
Help on coding please?
VBA Worksheets save new file to Folder on Desktop
ListBox1 - returns no value
Using excel to access MS Access saved query
Vba to go to another sheet in same workbook
I have formulas larger than 7 functions, how can I use them?
Creating a conditional formula
CAN ANYBODY PLEASE HELP ME WITH THIS MACRO
MACRO TO LOOKUP AND SUM
Formula needed changing font color
Custom Excel Entry Form
logical expressions of formats
deselect any "active" charts in workbook
Create external link to another workbook cell programmatically
Dynamic WebQuery freezes around the 50 or 60 iteration of the loop
Save file as...
Conditional Formats on Autofilter Headers
Pivot Table
save a workbook using Two different cells for a reference
F8 macro step by step
Can excel export to, run, and run a spread sheet that is closed?
Text plus formula
Document.Body.InnerText is empty in Excel 2003
2 Macros in VBA???
Find and Replace with Formatting
delete pivot table data fields
save all component in project...
Need to disable my vba macro once I email out the file.
VBA Macro
Save contact to a particular folder in Outlook
BeforeAssignmentAction
Conditional Format assistance?
Use of Public for data declaration in Excel 2000
creating columns based on date range
Conditional Copy Macro
AciveWindow.ScrollColumn / Excel file embedded in word
Excel 2007 Chart Plot #N/A Data labels
Scrolling in a form's listbox
PLEASE HELP - MACRO NEEDED
Get certain words from a line into a cell
Need Help With Finding Date And Copying Everything To The Right OfIt?
MS VB 2005 / 2008 EXPRESS EDITION
Forms: Why do they cause Excel to crash?
Is there a formula for identifying prime numbers in Excel?
PLEASE HELP
Help with VBA Code - again
Formula to choose X number of unique random cells from array?
Cancel query
Command Button VB Code w/hyperlinks
Excel VBA FTP
Test if File is Shared using VB
userforms
Nested Import Loops
Names.Add - compile error
Macro for cross referencing
Issue with UnProtect userinterfaceonly:=true
Help with Forms
Popup-Message when using UDF from add-In
Selection.EntireRow.AutoFit
listbox
Run Different Macros for the Up & Down Spinner Form Buttons
How to group empty cells in a column
how can i to use excel to analyse?
CORRECTION NEEDED IN MACRO
Query adds rather than replaces
How to generate a random uniqe alfanumeric number?
how to generate series of random numbers which are all unique
Input Cells on a Chart tab
Anyone know an answerr?
OLEObjects: Adding jpg Object
search for variable worksheet name and rename
Format Text Boxes
Pie Chart Colors
reformatting "text" format for dates and numeric data
conditional formatting
Macro terminates early without error message
Help with optimization
ScreenUpdating = FALSE
Hide Userform when viewing a different workbook
Formula Help
Auto Refresh and Protecting a Sheet
Pop Reminder
Can I write a macro to insert a row after a data change?
UserForm - Right-click a Textbox and Paste
help with vba/Macro sorting
Simple Folder, Workbooks, Worksheets Import ?
Display of control check boxes and option buttons
vba instruction for file saving
html
linking worksheets programmatically
Writing from an excel user form on one spreadsheet write to anothe
Sorting files by name(i)
opening and searching files in filesearch
How do I convert HTML tags within cell to text?
From Immediate window to Text file - create a log file
Find cell value, set cell shading
Lines not executing
Average of low five numbers?
Help! Why doesn't this work after 2 times?
info on faceid
Run-time error 3265