Excel Programming [Archive] - Page 55

Adding timelines to a chart
Hide rows in visual columns without data
find and paste - help with code
Macro to lookup in a workbook and append it to a table
IF Statement giving a Syntax Error
Having Trouble Creating an Add-In Application.
Run macro on columns with a "defined name"
Long VBA Code - Can it be reduced
Adding Percentages to a Stacked Chart
Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument"
Positioning UserForms, Input & Msg Boxes
help saving trees by excel *free* macro...
Custom button behaviour (activation and deactivation)
lookup for bright solution...
Solver Macro in Excel 2007
add a .jpg to msg box
RE: Concatenation prob
Help with ADO query on MS Excel worksheet ...
Adding leading zeros
(previous discussion with Tom - re:Dynamically creating pt from li
Re: Concatenation prob
How to count blanks and spaces that look like blanks
Setting AutoFilter to "Show All" when worksheet is opened
Macro Reference Cells
Macro to search every row in sheet2 then display all matching resu
Macro Saving
Link Not Embed Images from URL
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?
Delete rows with data
left align active column/cell in window
If Then ?
Halt Macro Execution
VBA - Character Removal
Rename a range of cells with a macro
sql
(repost) Dynamically creating pivot tables from page-field list
IF formula - positioning difference
Is this code ok?
Deleting
Calculating Gaps Between Numbers
Password recovery help needed due memory loss caused by cerebralinfarction
Slow Analysis Tool Pack
Place Value in Cell
Import XML file from the web in EXcel
Macro Help
Simple qu i hope
Deployed add-in doesn't load
"Another ScrollBar Question"
Insert picture
Workaround for ChDir/CurDir when path has unicode characters
Using Mutiple Sheets in excel in shell script
List all the groups a user is in
Excel Solver Macro: Contraints Get Lost! - Please Help
cant sum the values in cells
Insert row on diff sheet IF
Question on SubTotal function
Copy schema objects
Vlookup VBA on dates
Conditional Formatting Problem with currency.
Enable/Disable Command Button
IE Automation - Trouble getting changes recognized/committed
xlup to find last row
Calendar Contol with mutiple textboxes
Why isn't the conditional formatting working?
Dynamic Cell Reference
Converting Text to Numbers
How does VBA interpret Dates?
Using a variable to add fields to a pivot table
Name Increment on Open
Problem with getting numbers in some range values!?
Excel and Powerpoint
Disable command bar Excel 2007 and Vista
Toggle Macro
Importing a web page into Excel (picture)
Checkbox Event Macro
Help Can not Copy Sheet but Can add a New Sheet!!!
Find text in between to knowns
Create a list of hyperlinks
how to monitor worksheet usage - using counter workbook
Let property changing all values in Class module
Transfer Writen Notes
Creating Pivot tables dynamically from page filter values summary
How do you delet all the defined range names in a excel file
Add to Chart
Cannot change Cell value
Closing a workbook from a macro doesn't close the workbook
Extract string after specific characters
Progressbar on userform for waiting querytable retrieving data from web
Testing for <Incorrect> Dates
Alphabetic lookup within a pick box
Help about macros
Find and replace, or insert in VBA code
Storing times in an array
Removing Field Subtotals except for 2 from from PivotTable
Mail Merge with Macros
Offset issue
2.5 StdDevs
Trendline Coefficients
Copy Average Caluclations
Combo Boxes - What to do first
Extremely Urgent need to arrange data
Problems with the OnWorkbookClose() Event
Issue with For loop
RunTime Error 1004? _Default Property?
Relate a Number with an ARRAY
Powerpoint chart -> Excel
Sharepoint File Dialog
How To Automate Copy Certian Cells from Worksheet A to Certian Cells Worksheet B?
string size limitations for array formulas
Help with type mismatch error
Sum all search results?
Strange RefEdit Problem
Personal.XLS Prob.
Code for Calendar control
please help me program excel to scan for top 10 highest values
Active Sheet
Print Routine Error
Memory Issues with Excel
A real cut and paste
Need help creating, manipulating and reading global arrays ...
Retrieving Data: Speed of beating down rows vs retrieving from array?
Can Excel "extract" ranges of numbers listed in the A column?
Swap 2 ranges
Help needed for old thread Please ??
Excel / Access User Conference - Oct 24-26, St Loiuis
Pivot Table Page Field (Repost)
Delete rows where colums 4 is empty
best solution for db
Find a value and delete that row
number cells within a range
Sorting and Subtoaling
Code Protection
Global Book Protection
count number of non empty columns
Use the Excel LogEst-function at server
Empty row
Automatically add Conditional formatting on data/subtotals
Add method of "Sheets" class fails
make changes to excel workbook
Newbie Error
A) 2 Contiguous Popups B) The 'reverse' of .onaction
"Scrolling with Scrollbar or SpinButton on UserForm"
Looking for someone who could extract data from web-page to excel- with paying fee!
macro to identify columns to hide
Can I type text in one cell and have a value auto-enter in 2nd cel
Numeric data only in text box on userform
Custom Cell Format problem
Health chart
Print If Column Contains Blanks (No Characters)
Read Network Groups Belonged To
Roger Whitehead contact details
SpellNumber
VBA to lock & send multiple workbooks into Essbase cube
Why R1C1 range parameters in VBA Pivot Table setup/
3 combobox.values to one cell
Auto filtering pivot table field
Do Not Load if Not Using Auto-Execute Macro
Cells Protection
Shift cells to the left
Help!
Select Variable Number of Columns
Messing Up on AutoFit
Biff8 standard encryption(office 97/2000 defalut encryption way)
Biff8 standard encryption(office 97/2000 defalut encryption way)
multicolumn listbox
filling web forms from excel
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON
Unhide roes in a different worksheet - My code is not working
strange problem with public variable
Excel fornual to delect rows
copy range with different ranges.
Webbrowser control not loading Html string
New rows overwriting existing problem
Copy last row from sheet 1 to last row in sheet 2
Copy and paste file name
Macro creates formula with $ absolute. I want to drop the $
Basic Macro Question (Urgent!)
Excel 2007 VBA/Vista - How do I deselect a selection programmatica
Create a shortcut to a folder with VBA
Copy from Sheet 1 to Last available cell in specified column
find and delete
Filling In Cells Using Lookups Via VBA?
PivotTable question about grouping numbers in it
Shorter Code
reset ALL checkboxes (created with control toolbar) with the click of ONE BUTTON
Error Message: ‘Argument Not optional’
NEED VB FOR PASTING THE CELL REFERENCE
Heading for Report from UserForm.
How to us macro for designing a statistic table (i.e soccer score table) auto update after i enter the game result
VB program for excel sheet
Adding Validation When Source Validates To Error?
Join text and 2 dates in A2 column in worksheet
Macro to Copy certain values from different sheets to TIME Sheet
Inability to Copy Sheet to Other Workbooks
Digital Clock
Help needed with Complicated code (For me !!)
Error 1004 when setting a Series Collection.Values as Array via VB
What are the reasons for ""ActiveSheet.Paste Link:=True"" failure
ODBC MS Query - chinese character issue
which range staement is preferable?
Saving images in VBA
Pivot Table Page Field
AutoFilter - Lack or Experience
Change default Save As file type
If statement question
Help on editing a function using a macro
Cannot Reset a Protected List
Addin vs. Embedded references
UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED
Excel 2007 slow
How to handle Blank Cells?
Measurements in Excel?
Import sharepoint data to Excel 2007
Loosing values when working on different functions and modules..
Work out years from entered Date
Need help with slow AutoFilter
Search from the bottom of a Range up
Workbooks("Mappe1").Activate trouble
Copying formulas situation
Error in vba module
viewing specific columns
seeking a smarter lookup function
combine number and string
Converting doubles to text ot string
Using named range intersection in a sum funtion
How do I extract part of a text in a cell?
HPageBreaks.Add
For Next Loop to Make A4 in Each Sheet = Name of Each Tab
Make a combobox equal to part of a cell value
Code a button and Macro to Insert data to an Oracle Database
ShiftJis to UTF-8
populate cell looking at last valued cell
Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs
Excel table in userform
User prompt for data connection
Data lookup function in Excel
comparing strings on seperate worksheets
Some fields required question
. and , while working with User Forms
Data Selection for a Graph
Assigning custom commandbar buttons FaceID numbers
excel.h - How To? Add a new worksheet c++
Coordinates of Cell
many types of loops
Ignore Blank Cells on AutoFilter
SUMIF HELP
I need to set up a simulation
Loading/sorting array of Longs (> 65K rows)
Code equivalent to Alt + Tab
Match() how to workaround identical Lookup_values
Date Format in UserForm textbox.
How can I turn off the OLE warning when merging cells?
Autofit rows where a cell contains results of formula
Color Coding Findings
Embedded Excel Problem with Menus/Commandbars/Toolbars etc
The Information cannot be pasted Message
Querytable and pivot table refresh problem
paper size by name
Names.Add
File constantly defaulting to previous version of Word Object Libary
Printing an existing excel file in C#
Embedded Excel Problem via c++
Printing a Dynamic Range
Printing an existing excel file in C#
Using DSN-Less Connectino from Excel to SQL
Named Ranges
copy and paste question
Selected cells not updating
office 2007 and vsto
right click hide
SendKeys
How to select cells in specific Columns?
count no. of times a text appears in a sheet.
How to return the address of a cell found via VLOOKUP?
Resize any selected object
Change PivotField Properties with Empty Cache?
how can I fix Broken Links
Application.Run with variable number of arguments
Fed value to unhide rows in another sheet
Option Buttons Off When Program is opened
adding a self destruct feature
Expand selection
numbers (like invoice numbers) in Excel worksheet
Date range
Best Way
Search a column, enable input fields, save to row & columna, reset
Where is My Data
".MatchTextExactly = true" not always the case, please help.
WorkSheet or AutoFilter Problem
Operation is not allowed
Force save with timestamp
combining two columns into one-Excel 2007
Trying To Push Code For Worksheet_Change Into VBA-Created Workbook?
Enter Data
Macro - Find Next Change In A Column; then insert row
Newbie: Dimming a variable.
printer page length
Returning focus to a user form after getting message box response
print macro dependent on conditional format
Pivot table, average, upper/lower control limit
Shift-JIS to UTF-8
there's got to be a better way...
Changes Macro from WorkSheet to All Books
sort question
Top of AutoFiltered Range?
List file name only
Adding values from two different worksheets from workbook
Array formula in memory
VBA REQUIRED TO TAKE VALUE FROM EACH CELL FROM A RANGE AND FIND THE VALUE FROM A DIFFERENT RANGE
Import Query from Access - Bug
Popup box help?
Disabling scrollbars for an excel's built-in form (Autoform)
Problem with AutoFilter
What type of loop?
User entry in a cell unless conditions are met?
Generating random lognormally distributed numbers
vlookup not working with defined name
Runtime error 91 on website login
Ghost code from User-defined Add-Ins
Problem saving file as xls
Edit Closed XLT
Run Tab Macro
inserting three rows
printing number of copies
.Net via COM Interop in VBA
Need loop help.
Searching certain ranges and stopping when finding no match
IF statement failing
Opening a Succession
Bringing upanother WorkBook (Sheet)
ThisWorkbook.Activate Question
Before sheet copy
How do I determine if a workbook is a template?
stupid me - search across row
Data from another cell
Tab Names
Using excel built-in form, through VBA, script to initialize it
Bootstrapping in Excel
"Available Resources"?
ranges as arrays
Named Ranges
Destroying All My Work
Userform, Excel 2000 & 2003
Which runs faster
Code to track changes by row and store
insert every other column from other excel cells
Unprotect all sheets
Close all internet explorer windows
How can I enter a workbook password automatically
Move Data From Active Sheet to New WorkBook
Date problem
unprotect next sheet
Can I pgrogramatically access Track Changes?
How to Prompt a user to select a Folder.
How to Place a Check Mark Next to an Item in the Submenu of a Custom Menu
Code to show if a cell has met conditional formatting
Delete rows containing Vendor Total A,B,C etc
Editing Text Boxes
code for text
.onaction, passing arguments
run time error 1004 general odbc error excel 2003 vba
Save Time With Heading Functions in Excel
Referencing checkboxes on a worksheet from a form
Copy data from one worksheet to another
Make macro run on all worksheets except the first
Using Powerpoint inside Exel program
Copy Worksheet from Macro
Sumproduct between and
Can you pin ribbon tabs in Excel 2007?
Print one cell to one page
Implementation Guidance - Onclick or Hyperlinking
Excel running when user is not logged in to windows
litter square caused by ALT + Enter
Folder access rights
Multiplying non consecutive rows, then adding it.
Testing for empty sheet
Attaching a xml schema to a excel worksheet
Selecting only from index for combobox
Procedure Name as a property?
Compare Column to Inbput Box Variable
Calling Public Variables between diff Modules
Automatic copying of results from one sheet to another on same fil
HOW TO: capture the event when a row group is expanded or collapse
global variable not seen
Run time error 91
Date calculation
Creating delivery notes from a spreadsheet
Migrating VBA to Excel 2007 - AutoFill & Excel Object Error - ExcelFrom AutoCAD 2004
Forcing a selection
Paste text to userform
"Tutorial for Userform Controls?"
offset every other row down a column (2 merged rows)
How to make a data validated field refresh
Need Recommendation
Using Subtotal: How to update TotalList:=
Email notification
reorder info
Command Buttons Outside Spreadsheet
Codepages and displaying euro sign
Background colours...
copy the font color
File exists but cannot open from Excel
"floating" button
Absolute reference problem - Excel 2007
make selection in listbox html with vba
How to insert rows as value?
Code to add Formulas with new records
Pivot Chart - Disassocoation from PivotTable
Get rid of all displaypagebreaks in whole workbook
Macro in Excel 2007
Convert String Representation of Excel Constant to Actual Value
about worksheet_change
Newbie sort problem - Please help
Compare values in a column
Macro to change cell colour based on words
Help with conditional formating
Checking two cells
UDF to reference the cell with the function in it
Print multiple worksheets into separate pdfs
Worksheet_Change fires even when no change?
Where do I find Visual Studio Solution Explorer
Counting Consecutive Numbers
Listbox, fill by format
Retrieve Data from a pivot table
Count some of the numbers in a cell
conditional format question
how to import an excel table into sql server express?
Excel crashes on copying macro using VBE.VBproject
Autofilter and formatting
Task pane best practices
Workbooks.Open Filename
AutoFilter with protected sheets
How to create "modern" controls on a worksheet
Pause a Macro
Searching through text - Speed issue
Skipping a tab when with this macro
Excel Chart Add Series with VBA
Why won't this work? Syntacs?
Search all directories for .mdb files
Cell drives combo box change
Run macro automatically
Subtotaling a Varied length Spreadsheet
With Me statement
How does Collection.Item search
Need help with text to column code
ExportAsFixedFormat?
Totals rows dynamically moving to accommodate amount of informatio
weird problem with an excel file, asp.net and IIS
Workbooks.SaveAs - How to have it saved with .xls extension?
ChangeLink spends a lot of time
Populate Combo-box from Multiple Sheets
Can't create macro - Excel 2007
Code help?
Is there a way to compare all columns in a Row and flag difference
ListBox Home Stretch!
Excel 2007 worksheet visible problem
Turn Off Sounds in Macro
Preventing cutting/pasting
variable dimensions
An algebra/programming question
Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
Last Row In Named Range
missing functions
Excel programming - scanning values, populating cells - please hel
Count series in chart
copy excel to word
Find Copy Paste
I need Help Please
Textbox in a toolbar
Excel program 2007 does not allow use the majority of commands....
Removing "Contains Macros" popup
errors on linking for *.def file
Print macro help
How to test : files are already opened or not
Worksheet_Activate - conditional use
color change in a table
Using MyValue in SaveAs Fname
Selecting Populate Cells
Roger Whitehead contact details
Copy values only
Hyperlink to folder not opening
Borders
Application.WorksheetFunction.VLookup (Plz Help)
indices in named range
Passing variable to and from a form
Different Zip File Size for Excel with and without Workbook Protec
Move File to new folder - Problem
Macro - highlight rows
Login date & time to the VBA application.
Difference between Userform Activate and Initialize
Export worksheet in New File by VBA code
Combobox Help
running a macro, while programming in vba at the same time
How can I password protect a single worksheet within a workbook
To Place Button in Excel
Jaccard Statistic
Removing space characters
Implementation Guidance
Macro to create a new worksheet that is a copy of an existing one?
Sendmail with a named cell value as recipient
Relative path
how to program in excel
complicated macro
Macro program protect
Add-In UserForm Crash
Excel newb needs help writing a macro
Determine If A File Was Specified When Starting Excel
Stock Quotes
refer to one userform from another
Is it possible to open only form when an excel file opens...
How do I continue a routine while showing a userform?
unwanted reinitialization of global variables
Dynamically sorting a range
Clear rows with no data?
Auto Populate Combo Box When Opening a Worksheet
"Which control to use in a UserForm?"
List Reference
Work with only objects in a frame...
For...Next or Select Case Statement
Creating a folder using Visual Basic HELP!!!
Animating charts
Copying columns to new sheets
Lock cells but allow sorting and filtering
Programming Formula for Cond. Format yields different formula
Macro Help
web site query
Delete Blank Rows in a pattern
array question
Trouble with VBA code for Excel.
Why this code crash Excel?
concatenate with vba
Worksheet vs. Worksheets
Conditional formatting with decimals
Loops for copy and paste
setting range names
Resize Sumif formula parameters for added data
Syntax or Something is KILLING Me
Conditional Formatting
Worksheet.opentext....???
How to automatically stock Dynamic data?
Specifiy Chart Data Range
References
Show All Data
Need Direction
macro to automatcially delete a worksheet
Selecting a range defined in a cell
Save userform values in excel sheet
Conditional Formatting using VBA in Access
adding right click menu to textbox
Excel 2007 statusbar hWnd
Automatically Update Delimited/Comma Seperated File
VB: If Solver found no feasible solution
VBA Codes Protection
Problems deleting columns
Getting Summary Data From A large Data of Files in a Directory
OR statement VB
Compile Error: Method or Data Member not found
OpenText method - how to check if file exists
Easypdf
Import All Sheets from Closed Workbook
Fail to open unicode txt file in excel
Microsoft Charts
Open password workbook not working
Right-Click Sheet, Move or Copy, & Class Module
sum
UDF Question
Excel 2007 is asking me to download VBA converters
Variable in one sub which refers to an input box in another sub.
Copy Auto-filtered data to new sheets
printable area size
Sort Combobox Items in Userform - shahzad
5 schifts
missing something
def numbers
Clearing Empty Cells.
how do you name a range?
Coping ranges of cells
Ensuring Autofilter arrows are visible at end of macro
Transpose and VBA Resize command
Excel Workbook for Multi User Access
can't move UserForm with the mouse
Basic Questions
Automating Text to Columns -- can I auto-click "OK" on the message
Initializing Multiple Combo Boxes
named cells
separate two strings
DLL question
VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1
MIDI sound playback
Change the code in another worksheet
Macros: Moving data into separate worksheets or spreadsheets
auto-indent in vb editor
Re: Urgent help on plotting a X,Y graph...
need formula for stair stepping commissions w/ diff %per step
how do I...
Opening Powerpoint from Excel and Word
Macros: Copying from different document, saving in multiple forms
reset "on error resume next"
Need "grep" like function to search multiple workbooks
Excecl VBA: When a Dialog Appears that requires you to press "OK"
Problems with .find code
Select Case Statements
Menu Restoration
Prevent macro calculate if text in the range
When a web query fails.
export Hyperlinks
Deleting the empty rows in Excel
Enter Range value and get report
UserForm - Disable the 'x' button
Cannot find file - code error
VBA code ok in Excel 2003, but crashes Excel 2002 & 2000
"Using A Variable On Several Sheets"
Need look up of month to get total for the month
Error 59 Bad record length
VBA code for tab exists
Macro or VBA process varible row data
Macro to find and replace text in a worksheet
send mail on value
How Change Powerpoint Embedded Chart Values?
Merging Column Data
array structure
Changing the From: in an email
Posting Recordset to SQl Server
How do I stack columns?
updation from another workbook
insert doen"t work: version 2
My VBA Script
Drawing a Circle if a different cell has data
Slow generation of Word Documents
Excel 2007 slow saving with defined names
combining subtotal(9,) with an array formula?
Delete Rows with Autofilter and partial cell.
Open .xls files listed in .txt file and generate report
Hiding Pivot Table Wizard
AVERAGE / STD of groups in a table?
Sum of 15 random +/- integers always greater than or equal to zero
Paste formula into macro
Format "0000"
insert doesn't work
Change username for file transfer
Stop (halt, break) my vba code please...
For next loop and copy and pasting VBA
autofill empty cells with a macro in excel
forecast using Pivot tables
MultiSelect ListBox Help
RE: Logical test
#VALUE when trying to sum numbers
how can I make a macro prompt for a portion of a file name?
Compare 2 sheets and copy matching data
Excel Interop with in-memory document - no file system
Modified worksheet macro, where if Yes portion works but not else
copy,switch,paste,erase
identifying PivotTables
Error proof way to find first blank Row after Autofilter Range
Doing a copy-paste offest between 2 workbooks
adding comments to a cell and not using comment box
VBA Cut and paste into other workbook
Using Readpast to skip records
printer trays
Code to open Notes database and find a specific doc
Click Event
RE: induce sleeping time
Excel VBA - SQL to .dbf date problem - GETTING DESPERATE
copy cell to next open line
Worksheet Speed
Run program between 2 separate excel sessions
Conditional formatting
Slow Macro
Message boxes
How do I change a Worksheet_change event to a beforesave event?
cannot see the error line when error message appear
Re: Help deleting fields in SQL table
Absolute beginner
Delete Rows based on not existing in range
Run Business Objects Report from Excel using VBA
My VBA does not work!!
Unable to set the Display Alerts property of the application class
Message box & close worksheet
Messagr
tom igilvy\gary"s student\mike h....
Custom Sum Function
VSTO 2003 and 2007 Add-ins
batch hyperlink
Get info from a file that is already open
Copying ranges to various locations
Compatibility Checker causing headaches
cell.find not working
How to hide toolbar automatically when I switch to other worksheet
How to stop VBA in a Loop
Create Outlook event/appt in non-default calendar folder
Use formula from cell in UserForm?
copy and paste values
Rounding Problem
Imported and Manually Entered Data
Write/Paste RTF or HTML string into one cell??
Msgbox preventing workbook save
Re: Mail one sheet from Excel without using a new workbook
Update/Refresh Sheet?
option button and userform question
Finding cell matches
How Capture Cell Value Before Change Event Fires?
Please help with db query
run an OQY
tom ogilvy\gary"s student....... pls!!!!
RTD Real Time Data
Copying Named Ranges based on ListBox Results
Comparing dates
Re: Setting a variable to range of cell values
Right click Drag and Drop context menu
Call API from vbscript via excel.
Call API from vbscript via excel.
Call API from vbscript via excel.
Userform comobox equal to first 3 digits in a cell
Pausing a Macro awaiting user input
Copying data from a network file - many problems
Excel Suspend / Resume Layout
object variable are not set error
Excel Used Range
seek next line (more detailed desc)
Excel Drag and Drop
Unable to call Command Button's Click() method from a different sheet
personal.xls
functions in 'personal.xls'
ActiveCell.Formula to equal a specific cell
make a combo box repeat for entire column?
Match Entry Complete for Data Validation
Re: Urgent help on plotting a X,Y graph...
disable toolbars
seek next line
Font Information for a cell with multiple color and size
Formula - Dynamic Range
Re: Cell colour doesn't delete
Excel template behavior
Listbox MatchEntry Property
Hyperlink Copy
importing XML files
Re: Excel 2002 and IE7
Re: Dates In UserForm Textboxes
Excel 2003 in a WEB SERVICE - would like some input :)
Excel 2007 Weird Image problem
Re: updating formula when a worksheet is added
Looking for a Macro to erase particular rows in a given pattern
application.match with multi-dimensional arrays (syntax request)
Macro that will run from Excel but act on Excel, Word & Access
Re: _filterdatabase
SumbyColor Function
Error Message regarding .TextFilePlatform = 437
RE: Dates In UserForm Textboxes
RE: Macro to Check Two numbers and insert a line
Automatically Answer Prompts
RE: Mirroring worksheets
RE: Convert a range t ype to a string type
Updating Macro File
RE: Recalculation problem
Auto Update Formula Rows
Validate Entry
Retrive Records in UserForm and Edit - from shahzad
Sort Excel objects by their creation order
Printing several worksheets as on page
CopyFromRecordset method
pause/re-run macro to enable DDE updating
Togglebutton to change Checkboxes
Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting
Nested if statement and vlookup problem
Conditional Combo Box Fill
Excel Convert Multiple Rows into Multiple Columns
How do I create a computer admin'd multiple choice test in Excel?
Grouping Date Data in a Pivot Table
SUM formula for data from one column when another is populated
How to sort pivot table by Data Items
copy from sheet 1 to sheet 2 values
How do I check if a cell has a dropdown
Help Improving VBA to update Chart Formats
Scroll bars in a user form
How to select named range list dependent on another selection
Load text file into memory for searching?
.selection.find not working via automation
vb Command seems simple but...
How to add data into a text file without overwriting existing data
How do I remove a UserForm from a workbook?
Macro loop problem
How to Construct a Formula Based on Text In Changing Cell
Hanlde "New Workbook" Task Pane Events
Screen Flashing
Complex Copy/Print Macro
Truncate value of a cell
Transferring data from one worksheet to another automatically
Print_Title start in middle
XLS 2007: Icons or Colors in a dropdown list ?
Duration problem
Delete an entire row if a selected row doesn't have a specified value in a cell
Insert Picture Into Form
How to Autofill HTML code into Excell spreadsheet
UserForm
Find all 6/1/2007 in the Workbook, Sum Corresponding Dollar Figure
UserForm help
Excel 2000 Opens, but spreadsheet cannot be seen
Scroll bar (control) doesn't scroll!! ???
XLL Internittently Fails to Load
How to submit data from one sheet to another with a macro and butt
Splitting Excel file into many workbooks
Refedit Retaining Focus
Macro to cycle through worksheets
Personal marco workbook
How do I exchange data between worksheets?
Getting special formatting to apply to all worksheets
assign formula to a cell
Relation between hide(orunhide) and protect
How to generalize sorting range in macro???
Jagged arrays - Cannot Define with Arr1()() as integer = New integ
How to select all sheets in front of a particular sheet???
Creating Excel Documents from Scratch.
Does excel macro automatically enter data by date?
How to obtain cell address of a succesful VLookup?
How would you set this up?
Removing Hotkey Assignment
Class modules Custom initialization Line
vlookup, change aray if
Hanging Instance of Excel
Columnheads...
Macro terminates upon opening text file
Creating Server Certificate for Excel Macros
Open Access Macro, then put a value into a parameter field
Getting a reference when a value is less than 0
Adding a Button
Project or Library missing
Multiple range selection issue
Form/Module Code Question
Cell Colour depending on Value in Range
ODBC Connector Help
clearing an advanced filter
Delimit using 2 spaces instead of 1?
Set Errors
WorkBook_SheetChange for non-Active worksheet
Issue Recalculating VB Formulas in Excel 2003
Date Selection
Testing for Valid Macro Name
User form question
Code for searching & copying Text from 1 text file to another
Print Preview XL2007 still not working properly
Return Column of Found Data
Digitally Signing Excel/Word Macros
How to count number of Cell have Strike Through Effect & Bold as font style.
object invoked is disconnected from its clients
Clear content of textbox in userform
Using Application.Inputbox with shapes
VBA that finds the bottom of the sheet
VBA to find the bottom of a sheet
Saving a File to a Name That Already Exists
Web Site Lookup
Find last row in a column
To let us choose the file
Protecting the code using code
Command button error
Conditional format : return to default format
{=max(if(........))} Array Function not working after range length of $A1:$A339
RE: UDF
Number format of textbox in userform
Linked Tables Dilema using Excel 2000
RE: How to define a range using variables
How to define a range using variables
character limit in formula
Re: UDF
RE: UDF
UDF
select instruction is not able to work with a sheet
How to streamline this macro
Start reading text file at line 3
Fill in formula with dymanic address
Editing multiline textbox
Problem with and Excel Add-in installing on customer's machines
Conditional Formating for Time Sheet
combine rows of data to one row...tough one
workbooks.open - another option
How do I remove the ' from the begining of value in a cell
Textbox
Merge csv file from many folders
Make a Zip file from Excel
Automatic Population of one Column
VBA print character on chart
IF Function testing a range and a cell
Signing VBA Project Using VB.NET
Format a Double to have one decimal place number?
How to stop a msgbox pop up from another workbook
Monthly Total report based on 2 or 3 criteria. VBA or Formula
excel programming
Array in VBA
Organizing Information Using Excel Macros (or any other solution)
IF FORMULA....
Excel Progress Bar while Calculating
Createobject for FTP
How to create a function that fills the current date in an adjoining cell
List AutoFilter Changes to "All"
Data from Worksheet to Worksheet
VBA put number on bar chart
Date Range (Starting & Ending Date) - syed shahzad
Order of Files Opening
unhide columns in named range
Setting up a way to track accountability and where they are going
List AutoFilter Changes to "All"
set of numbers ranging from 0 to 240
access internet through VBA
Find string in Data
Design a Form for Excel
Delete worksheet in collection
Soap problem
How do I compare 1 excel file to another and save what is a match
What is default property of name object
Deleting Rows based on hierarcy
Opening a .pdf file with Adobe Reader 8.0
VBA.convertFromJava("instanceof")=?
Project Still Open When Workbook is Closed
Need a program that gets excel file's name and deletes the first row.
Excel Macro
VBA to find the bottom of a sheet
Macro to copy data
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet
data structures
Excel QueryTable Refresh Causes "Choose Profile" Dialog to Appear
Grouping Date Data in a Pivot Table
reference disappear
Check box in a text box?
delete spaces
Importing large text file ERROR
If statement and exit macro
insert a row when theres change in a row.
Automate cut paste
Querytables refresh gives Subscript out of Range Error
Importing LargeTextfiles Over 65,563 lines Error
Reset conditional color VB
Value or Text
How to enable macro later
When first displaying a sheet -List box is not filled in.
User forms - How do I...?
find differences between two columns
Transpose
fullscreen changes corrupt display of listbox control
Visual Basic as a Tool for Financial Modeling in Excel
VBA for deleting duplicate rows
Unlocking a Locked File
Chart Legend Names
4 conditional formats
sending emails using thunderbird as email client
Print sheets in order 'x' times
Copy text with more than 65,536 lines into Excel
Excel crashes when VBA window is closed
Help please!
Hyperlinks change on publish as webpage
AutoFilter can't work after the worksheet is being protected!!!
empty cell
find format of cell
PLEASE HELP - query results to multiple rows.
Webpage Navigation
Reference to adodb.connection (or objects in general)
Input Boxes on Web Pages
Edit within a cell to select parts
Truncation of string problem
Warnings on Web Pages
Chart Auto-Size Behavior
Test
Get Parent directory
dynamic Range in ADO
Drop down list - most frequently used
Listbox in a form
export data to an existing and open workbook without knowing the f
DTPicker Bug
Registering UDFs
Copyingand pasting
Checkbox - Source types
Excel manual calculation probs
Saving emails sent by Lotus Notes through Excel
Handling dates in VBA
How to save with a name in a particular cell?
Same name - multiple data - how to combine
How do I create a new work book with selected worksheets
counting repeats of data
formula and offset
Collecting data from excel forms into one spread sheet
ADO while being used
Range of Days in a month
scroll a few columns at a time
How do I unhide the subtotals in a pivot?
Code to Insert rows and copy formulas
Pictures in Footers (again!)
To reset the Interior.ColorIndex function
COMPARE TODAY WITH DATE IN COLUMN
VB for Applications
How to get Leading Zero's passed
Local formula evaluate
Toolbar buttons how do show and change the status
clearing an array
Multiple External Data Returns
How to control the page break
Automating new line items for worksheets that will be added?
How to terminate an object that's in a collection
macro security
Is it possible to remove the Select method in this case?
Is it possible to remove the Select method in this case?
How to obtain the Row number of next visible cell Down?
Security - Setting