Excel Programming [Archive] - Page 56

Set current cell to a specific value
Need Code to SaveAs under different Menu.
Looking up data in a large sheet
inverse fourier
Get Open File NAme
Storing/Finding Info Trees
Pop up Clock?
Exotic Menu Controls
Insert an row without using select
Returning reference of frozen cell
Argument List; Arguments Passed to the Procedure
Option Buttons
button disappears when column is hidden
Query fails, requiring excel to be closed and restarted
Need help to make date comparison work, please?
Attendance Tracking
Time Sheet Macro
Column Cut/Paste possible?
How to import data into multiple worksheets from seperate text fil
Run-time error '438': Object doesn't support this property of meth
Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
macro count date
ComboBox, linking cells, vba, worksheetchange function, and overal frustration
ActiveWindow.Width
Command button code to include worksheets_SC
VBA memory allocation
Changing order of conditional formats
finding conditional formatting cells
Exporting from worksheets into new workbooks
Looping Issues
Optimizing Excel Code
Dynamic ComboBox Reference
show and hide a text box
Userform Label Click
count number of sql query result
draw chart
Find value then offset, to set variables
Date Range of Week
Program design question...
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial
Updating a coumn in Excel based on new entry data
Checking a database/excel sheet for new entries
Copy comment to another cell
Checking a database/excel sheet for new entries
Timesheet
Using msxml2.xmlhttp to automate downloads
Merging two different excel spreadsheets
macro to call up sheets
If Statement Help!!
Help - Update a SQL table from a specific range in Excel
Error in CommandBars
ListBox data validation
Auto expanding x axis of a chart.
NEED HELP - results to row???
Writing own formula 2
Multipage - default to particular page
Dynamic Charts
Excel / Access User Conference - Oct 24-26, St Loiuis
Paste not working in With statement - do I have too many 'With's?
Reading Excel data using Java Jakarata POI HSSF
How to create crosstabs in a table?????
Export from XL to Access via ADO
Open Excel
Application-defined or object-defined error
screen capture
refering to a variable in a cell.formula
VBA moving a worksheet to another Workbook
Selecting cells by colour
Set reference to different versions of AutoCAD from Excel VBA
Execute command in Right Click through VBA
Getting the row from a range
Add-in with IDTExtensibility2 and worksheet formulae
Use of COUNTA
Name and save files with current date & time
Help needed for sorting the data and plotting graph
Activate the solver witin a macro
answer to Rick
Hyperlinks?
strip out < sign and then calculate
cell has decimal value returns whole number, why?
find data another workbook
help with macro
define name
Using ADO and Late Binding
Searching for code for insertion of dynamic excel formulas
UNLOAD ADD-INS utility?
Hide names of columns and rows by code.
Retrive Data in Userform [from Shahzad]
Help wanted with Code, Please
pass parameter to Query
VB6 component does'nt exist
Boxes in my text
initial value in a cell with validation
Compass Heading drawing from an angles list
Problems loading user form
Code for getting Access recordset into Excel
SendMail Problem
Loop problems
Selecting listbox items programmatically by using stored parameter
How to turn on the pop-up "alternatives" while editing in the VBA Editor
Need help with a % or $ value formula for excel
Edit Listbox in Userform
Loop Unitl with timer
Problem with setting value in validated range
Copy a selected Range to a Workbook
Excel template with VBA Code intact
edit and forward mails
Taskbar and applications
re-post as still need help!
Can you change linked Excel file to Access path with Excel VBA
Average
Columnwidth change not correct
Search Formula
How to force all of the cells in a worksheet to recalculate?
how to use reference cell in VB?
Not finding file to print
typed character sensitive listbox
Running a Check prior to crating tabs.
CCP Uses Executed Prisoners to Dodge Allegations of Organ Harvesting
CCP Uses Executed Prisoners to Dodge Allegations of Organ Harvesting
Pivot table - How to create dynamic filters
Application object missing?
Stop users from inserting new lines and columns?
Sheets.Add
command button to save
Picking a random number from data
Now Function Question
determining array with no bounds set?
Sub(), Modules, and Private/ Global variables
How much Can Programming do to Excel Printing?
run time error 1004 : application defined or object defined error
Which Sheet Is Named Range On?
Looping Through Public Collections
Save As problem
Scroll Area Problem
Freezepanes odd behavior
Copying code behind from a sheet to a sheet in another workbook.
hyperlink to individual files?
Return Partial File Name to Cell
Need help with a Macro Procedure
UserForm question
MATCH multiple values
HELP! Someon's gotta know this
query results to row
Window Message to Verify Data Already typed
Problem accessing binary data from mysql data base
cant seem to get a function to reference a variable cell?
Warning Message to Prevent Overwritting
Error Handling question
Add in to spreadsheet
Forms
create a dropdown list for data input
Going Crazy
Finding Newest File
How to put footer's page number into a cell
Folder Tree
Copy a range of information to a worksheet in a specific file
Check for specific email in Outlook
how to compare two columns on two sheets and copy associated data from one sheet to the other?
change =NOW() to permanent date string
Copy and paste sheets between workbook
Syntax
Excel does not quit
Call an ADDIN function from VBA code
Zero divided by Zero
ActiveX Combo Box ListFillRange = Worksheet Named Range
Cell formula that captures name of the file's folder
If/And Greater than or Less Than
Trapping expansion or collapse of outlines
Help please! I'm confusing myself.....
Move Multiple Sheets - Name Variable
Importing text files asa group
¤j³°ª±LineÝ¯¤k
Add a filtered range to a multicolumn ListBox
Enable/Disable ComboBox
Count open workbooks before closing
macro to save current excel sheet only without losing formatting
Upload file without user interaction - VBA
Saved Web Page into Excel
Exporting graphs causes unwanted resizement!
Capturing a row being inserted
how to crerat star rating in a cell
problems using printout method in excel 2007
Excel 2007, VBA/VB6: Read the different colors defined for a workbook...
match two worksheets
Code to import data based on selection in two listboxes
need help macros excel 2003
Making Changes in a Group of Workbooks
macros
Help with Application.Match and it's funkiness
file not found ...\local~\temp\vb514.tmp
BeforeClose event help
two worksheets - matching macro
Challenging Problem
BorderAround won't go away
inporting data from website where website address frequently chang
catch event
Go to next line
Differente .xls files generated when VBE window closed vs open
Need the code for a simple macro
Link Excel form to Access query result or any other ADO
Possible BUG (Listbox item selection)
Setting a range?
Link form to Access query result
VBA to Make Check Box Entry
Finding a "Min" value
Update access DB record when finished running macro
Combo box Row source
Text with leading zeros being converted to numbers
Variable arrays & checkboxes
Gather info from two workbooks to make a third workbook..
Macro to perform action based on value in cell
Extracting Text from a text string
UDF not updating
run excel macros from shared drive
!@#$ Query with Joins???
dropdown - accessing values
Opening pdf's from Excel
Conditional formatting
Runtime error "1004" on this code, help pls
clipboard in excel
How do i import excel tabs in access with Docmd
Semi-Automated Copy and Insert
Listbox has some items selected when userform containing it opens.
Check Input, into Input box question
E-Mailing an existing file to a specific e-mail address
Importing files
using Frequency in Excel 2002 VBA
Remote Assistance
Problem with ComboBox, dynamic range and change event
Conditional formatting error
Excel Macro to Copy Word Text into an Email
Find print area when no print area set
deleting sheets
width of combo box control on toolbar
Inconsistent Sort
Find an value and clear contents of that row
Macro
Extra space with vbNewLine
Combo drop-down edit box
Absolute External Link?
Select Method of Range Class Failed
Setting Macro Hotkeys Programmatically
Formula to find a value in a list that doesnt match another list
excel function
Adding to a ListBox
Newsreader Question
Filter and immediately overwrite same sheet with results
Please help!!!
lookup in 1 workbook to get data for another workbook
Urgent!!! VB Developers for UAE
Do while
Update user form labels
Check if file on intranet exists
reorder information
XL2002 - Select All Objects in an Array...
Can I have a temporary message window appear during code execution
Comparing a range of values against a cell
Chart2JPG and export to webpage directory
Code to kill all modal dialogs
Macro - Please Help
export location
Query Refresh Error
Trying to stream back data into Excel from ASP.NET - charset issue
Close Message box after 3 seconds
Why does my sumif criteria appear as RC[-2] instead of B4 etc?
Button tip
Macro: search word, select row, copy.
New Filesearch & Foldersearch functions
Enable / Disable User Form Fields Based on Input.
Triggering an event whenever a new shape is added in a sheet
RE: Change cell color if...
filling sheets with Oracle ????
RE: Setting string based on conditions
Running Excel macro
Changing the format of a cell after a time limit
Re: Best way to manage product database
Re: Setting string based on conditions
Re: help with vlookup or similar
Combine Comments
Passing Query String into MS Excel
copying data into a file with a modify pw & read-only recommended
RE: Office 2003 update problem - Please Help!
Loop
Hard Returns
Getting links from other Columns
Loop
Print Range
VBA - Edit Procedure from Excel Userform??
Links From another Column
Re: Change cell color if...
Checking a database/excel sheet for new entries
Help with msgbox showing cell values
matching macro - very compicated....please see eact details inside
excel macro missing worksheets
Inverse Fourier Transform
Exchange Rates
Dynamically enable combo box if check box is checked
Combo Box Default
Array keeps returning Null Values
Find Next Blank Row
getting data from an array of varying amounts of comboboxes
Retrieve pivotitem range
Apostrophe's apearing in range address
Adding columns based on new worksheets
Conditional Formatting > 3 Conditions
Vb code help needed
Changing Chart Size with Excel 2007
extracting data from different excel sheets
Pivot Table with Quarter Subtotals across the top
Make Excel know 1M is 1,000,000
Test if a Cell contains either of 12 different words
Help!!! Form Controls & DB Query's
Copy Sheet with dynamic chart?
Is there a better way to enter data than Data Validation
Aligning comments
chart sizing and titling
Creating a spreadsheet to calculate probailities of winning raffles
Way beyond me: Calculate ROI of home energy improvements... while also taking into account increases in energy prices
Popup Window
Loop ?
DT Picker
select next
Excel Drop Down Lists
excel report
Highlight the cells referenced in the active cell formula
macro filter column for most recent date
convert text file to excel
Program editing to copy in text format
Code for duplicate rows?
Center Userform Controls
next object selection
Help with copying range btw workbooks (advanced example)
Sort a Record Structure within a Report Routine
Excel database
Namespace Microsoft.Office.Interop
send the data to lotus notes by email
Further help on cell highlighting if change to contents
How to Copy entire Worksheet from Workbook S to Workbook D
how to use vlookup in this case
Unprotect WS on clicking Group
problem with excel??
workbook Book1 missing on Exel start
Info Box that disappears by itself
Creating a collection in a class
save html
Strange Problem
Help with this challenging VBA coding
Capture multiple sourcefile filenames
Creating and displaying an email in lotus notes thorugh excel Options
HELP for coding?
text or numeral
AutoColoring
Option Button?? Help
Excel Lookup to Exchange Global Address List
Option Buttons Added at Run Time
Array Problem
combobox - default value
Option Button Size
Macro copying an array and pasting to a Word bookmark
selecting non-contiguous blocks of cells in vb
PivotChart with DataTable cropped when copied to PowerPoint
Cell formatting -- why so slow?
Identity on Database Fields
recalculate page breaks after setting Zoom in pagesetup
early beginner, simple question about End(xlUp)
Creating a macro that opens and runs multiple workbooks and macros
Data Validation based on data to left but several columns dependen
Custom Toolbar/Menu for UserForm
kpi display in excel 2007
Delete key casue a litte trouble
Copy and Paste seperate ranges in excel
Setting Chart Range
Change Format of Only Some Text in Cell
create a file, put a excel sheet in and a icon
Excel template link to table
VBA with Linest non-equal observations
Confirm Data from Other Cells
MORE combobox questions
Read from source of a Website to Excel
Ribbon command idMso for "Insert Cells"?
Help with code for selecting pivot table field by typing in a cell
Choose a macro from within a macro
code to save as webpage
format all sheets
target.offset(0,-1) does not work as assumed
Prevent Repeating Data Entry
Timer to lock spreadsheet?
workbook_open no longer occurs
Decimal Symbol
ODBC bridge to oracle with vbs
Sleep Mode
Have macro ignore error
Concatenate list of cell values into one cell
Excel / Access User Conference
Form Click event...
Cell pattern-style and color in Excel 2007
Query Error? (Works in mySQL)
close workbook/pdf conversion
Help setting chart series values with non-continuous range
how to consolidate two ranges in a new workbook
"Catastrophic Failure" error using ADO to query Excel Workbook...
Return to module after userform
Loop works correctly but takes extremely long to execute
Vista Registry Entries
Excel conditional formatting - how to make exceptions?
Combine data in rows based on two citeria
How to get a date stamp whenever a value is changed?
Workbook reference
Pause while user clicks on chart series
Add-in version check
determine if cell is #N/A
Double Double Quotes
passing objects
Excel Calander code changes
Loop through range and open files
Capture OLE Error
Formula Programming
myRow = Cells(Rows.Count, 2).End(xlUp).Row
Two columns combined into one dropdownlist
Programing a button to copy and email
PivotCharts On The Same Sheet
Re: Highlighting when a cells contents has changed
Highlighting when a cells contents has changed
Hyperlink or Command Button Program
Theory behind passing workbook
"%^{F9}" doesn't cause calcaulation
Program a cell to add its contents to another cell
Test on Username
re-asking for help
Excel 2007 - Crash
VBA FEatures Not Working
Vlookup error
Tricky chart axes synchronising question
Setting Autofilter using code
Convert Excel file to Txt file
Filling Lists with Workbook_Open
Reversing bytes
Sorting product row with header result
edit and Forward email
Any way to use R1C1 notation to access an online spreadsheet in a ZIP file??
Re-size active window
Close Shell
Macro for opening and copying
Populating One Listbox from a second listbox
running code only in selected module
SORT: Is it possible to supply operands via function / vba sub?
Application.match - apparent error?
Format problem
PivotTable.columnfields(index) vs Pivotcell.columnitem(index)
Keep formating from old sheet in the new sheet
Querytable Class Module
If statement to call module based on cell value
Display ONLY the LEFT Most 6 Charaters
Restore an invisible commandbutton on open?
Avoid Window Message while deleting a sheet
Method 'Union' of object '_Application' failed (Runtime Error 1004
UCase Column BH in a Sheet
converting cell formulas to into VB
sent as attachment
Pause While User Clicks on Chart Series
Script works very slow!
chart formatting
Text string to a number
Cell pattern-style and color in Excel 2007
Interview test questions?
First Time VBA user- really easy question :-)
Program Pivot Table Buttons
Program so that clicking on a cell will copy that cell to another
chart formatting
create a folder
2002 Vs 2003
Using Goal Seek without a macro
Call Macro
Tab color, Font color
Find and Replace
active Printer
adding ComboBox programitacally
dont confirm save with yes/no/cancell
Selecting the item in combobox in excel file through C# application
taborder excel
Sub to check & force open Parent.xls
Rows Group -looping issue
Deleting Workbook
Browse to Network Share
Passing Excel Values back to a SQL Table
code to run once on first open after save
Programing a button in excel
merge sheets based on common id with VBA
ADO Error Handling
Data Validation Unique List & Alphabetized
Minimum/Maximum Dates in Range
Updating a datasheet without all the blinking
"Code Page" ??
Workbook.Open Question
VBA editor problem
Macro not exiting correctly
Can I write a macro to ask for a specific number?
Copy a Range of Data to another Work Sheet
Adding event when sheet created
Deploying an Excel 2003 Automation addin (C#)
extracting data in an array
Radio Buttons
Two problems with Application.Run "ATPVBAEN.XLA!Random"
Searching for values in a given range and then prepending a formula
date created on picture files
Rental fees
Menu add-in
Countif type thingy...
changing font colour
SheetBeforeDoubleClick and merged cells
send to command/ e-mail and attachments
send information to word
Hide Scrollbars
update multiple cells by a percentage
Writing own formula
Open "xlDialogChangeLink" Dialog with VBA/VB.Net
Is it possible to get data from several word files having static format to one excel worksheet.
Macro or VBA Code to un tick CheckBox
HELP ListBox Save Data to Hidden Sheet, and ReLoad It upon opening
Opening a file
Very simple...early vba learner - range name in excel and in vba...
No sound with display
Accessing a Remote Server
macro to run on first open after save and close
Print form from other application
macro from desktop
refreshing web queries
Populating Cells From Dropdown Lists Aimed At Other Worksheets?
Day calculator form Given Date
VBA Converters Excel 2000 to Excel 2007
auto safe macro for workbook
Help with Copy based on dates code!
Paste Problem
paste macro to a workbook code
VBScript from VBA excel / wshShell.Run failed, error 80070483
export a workbook to specific loc on other computer via internet
Old VBA code in MS office 2007?
.activate on hidden sheet
auto save code for vb in excell
Is it feasible to use Excel as a database front-end?
Hiding the Insert New Worksheet tab in Excel 2007
if a cell equal to zero how can it delete entire row
Autofill in Database problem
excel prob - cant save worksheet if someone has it open in a veiwe
Generate sheet names from list, assign data to summary sheet.
Macros in Excel that work with Word - 2003
pivot tables long string formula for calculated field
Strange userform activate behavior
how to create a new workbook based on a template...
VBA code store address with areas separated with "," and I need it sometimes with ";" instead
Faster way to find what part of a range (actually addresses) not intersect with another one?
Embedding Data From MS Access Table?
Partitions in Short Cut menues
VBA reference via code
Help in highlighting and displaying found data.
problem with With, End with...
VBA Run time error 91
Return blank cell from conditional
how do i get system id to a excel sheet
Delete All VBA
Arrays and Loops
Sendkeys in Visual Basic
restricting data entry to non-times
controls in excel
data validation
Total Value of a Range
Breaking the data of column A into two columns First Name & Last name.
Who launched Excell?
Change Case for Names
Lost Important data
Launch external file based on cell value
How to delete selected columns?
data entry restricted to non-times
Combine like rows
Unable to open file
Unable to Open Excel File
Use VB to move to adjacent cell
Testing for and ungrouping grouped sheets
Sort Runtime Erroe 1004
Unhide 1 column at a time from named range
Print Charts
Formula will not evaluate in VBA
Macro - how to
Need help with an excel macro im trying to make
VB Code for saving PDF Print File
Macro to delete rows with different data
TextToColumns Method: How to use xlFixedWidth?
VBA userform troubles... adding to database no problem....updating modifying info = :(
Exit All Sub Command?
Help: Unprotect Sheet Re-Protect Permitting 1 row Deletion
macro to locate picture
Need help with multi-row filter/sort
Excel VBA cause Word to Crash
Not existing procedure correctly
How can I download from the web thru VBA
referencing file paths
How to Use a ListBox to Print Files in a particular order
Color Palette
Prompt for user information at startup
summing groups in a column
Need an explanation
How I calculate an integral in VBA for excel
animated image in user form
Code to check if word doc is already open
Adding to rows - sign issue??
For...Next Loop
Chart Events...
Find the last cell in a selected range?
I Dunno
Setting a user's "Regional Options - Short Date" from Excel?
Having "Or" in If statements in VB doesn't work?
If blank cell continue macro
Range Syntax for Script
grab values from a range
Creating VBA Functions When Creating Spreadsheet Via VBA?
Trying to write macro to combine data in multiple tabs into a single tab.
How to sort in most effcient way?
Getting data from IE
automatically numbering cells for large data from other sheets
auto count-if with subtotal's autofiltered layout
Most efficient code to "flip" a range of values + vs -
Set Focus on dialog box
Equating page filter value to a cell drop-down value
Highlighting cells when errors occur
Download text file from website
Beta distribution t test
Applying a macro to a range of cells
Merging excel worksheets
File Name
MS Query
Disable only the Insert Column option in Right Click
early beginner not satisfied with simple macro
stringed userforms won't hide
Manual created in Lotus
Excel 2007 builtin dialogs
general query about reporting of procedures
Convert Date/time to date only in vba
HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"
Data from Access using ADO
Help! Plotting to scatter graph
Last Entry
Tree View; selecting and pasting data to cell
change format of dropdown list in combo box
Gaining the correct Listbox Column value
Combine similiar rows
Using a Macro Button to Move to a Different Cell
Finding the first instance of a name or partial name in a list of names
setting up library check out
Best position in VBA code line for
Hiding/Restoring Built-In CommandBars?
Range and non contiguous cells
Creating a Pivot Table with VBA
combobox in userform
check to ensure all files in folder
Documenting a macro
VBA Find and Replace isn't working on apostrophe within cell value
[Excel 2007] Set Focus on Dialog
Updating a SQL table with information entered in an Excel Database
Input Color Scheme for Date Column
Combobox drop down
Need to loop
Random Number Array
From Access to Excel Question - VBA review
Find the Length of a Text File
vba to loop until process finished
Iterating Through Workbook if Don't Know Sheet Names
How do I Compare common fields to update a Master table
Comparing multiple fields in an array with multiple fields in a table.
RefEdit Control
Merge into a Template Form?
Need help with formula please
Adding two columns ...please help
copying every other row
export to outlook task list...
Long shot? Copy rows but have XL2K insert a space between each row??
Insert to Access table
Complicated Formula?
Highlighting whole row in this macro
Worksheet_Change - determine how it is triggered
Procedures stop with no indication of problem
Capturing a Drop Event
Need error trap
Function reading range with formulas
Macro to select multiple columns
Determining formula reference type
Open a wb and keep the focus on it
Looping over non-contiguous column selection
Forcing PT page filter values to equal my cell value on summary pa
Macro to change pictures
Problem with Format function
Customized Menu Executes Without Mouse Click
Save a copy from cell data and close orignal
Nulls within a .Find command
How to detect if a macro is in the middle of running
How to insert the Thousands Separator (comma) in Excel?
Sum Range of Cells to a Target Value
help me clean up this code
combo box list error
Find and Replace Exact Match
Cut/Paste Duplicates code?
Automatically "Click" Default Button on Message Boxes
Testing each cell for error
Created automatically sequence numbers
Replace method problems
create formula with seperate cells
ADODB over HTTP?
distributed vba project - multiple thread / concurrent file access
Entry Form Problem
Charting - bubble series
Accessing external excel files
Missing "Examples" and "See Also" in VBA help
Private Student Loan Consolidation Programs
Uppercase in non adjacent columns
ADO: run a stored Access query from Excel
Selection.Item Query
is date?
Huge Repository!!!
Add-in / XLL beginner
Insert...Function ???
What language to learn?
Copy range to / from CSV file
Paste into a 2-column listbox?
More on N-by-M assignment into a Worksheet
Non-blocking socket listening
Re: SUM with variable range
VBA compare two file paths and delete common root
Customize/ Hide data in pivot table
Create Macro to copy a formula to range of cell
Create Macro with variable search feature
selecting a printer within a macro
Referencing set columns on multiple worksheets
A shortcut to set colmn to count (example: A2=A1+A)?
Excel Chart macro to paste into Powerpoint
Export to MS Access
Excel Cell Data Limit
Macro for conditional formating more than 3
ActiveCell.Value copies unwanted currency format of source cell
retrieving top/bottom n rank()-ed data
using dateserial in vb
File size Limit in Excel 2003
Extracting Trendline Coefficients
RE: Deleting rows based on values in a column
Code Help!! PLEASE
Use cell content as range address reference/count?
Can't call Excel Services UDF from macro, object not found error
Excel Sort Problem...
Application Event Procedure <Falling Over>
Pop up message
Relocate Value Axis Title
Command Button
enter a value for a cell according to a criteria in an other cell
VBA Permanent Code
VerticalAlignment = xlTop also removes indent
How to use custom validation
Conditional Formatting Not Working Out
fix switch view....
StickyKeys Status
Combobox item selection+pop up list
browser integration
How do you stop the Find method?
Turn off toolbars
Importing from CSV file with the BASIC procedure
Running an Add-In on the fly
listindex and blank rows
xloper structure, excel
Simple VBA code not working on new laptop
Can I automatically add apage breaks to a sheet at each row witho
How to extract data from File Path
Copy range from multiple .xls files - output to separate columns per .xls file
Help with updating transaction entries
filter and copy
Excel Print All Tabs Macro
Vlookup
Filter Problem - show column difference
VB macro != NUll expression
Formula for calculation
protect unprotect sheet vba
Custom Floatable Toolbar Popup Menu
INPUT BOX
Searching and extracting data within a defined dataset
Little help please...
Como se faz um grÃ¡fico termopluviomÃ©trico no Excel?
Re: Exporting comments
Re: Using User-Defined Functions in Cells
RE: Use Excel to update Access tables
Arrange columns
Re: Modifing a userform txtbox code
RE: Exporting comments
Can I run a parameterized macro with medium security?
Re: Project Explorer and Properties window (VBA) have disappeared
Protection
Re: Error on Excel Startup
clear contents
Capture Screen Position
Re: Converting Tab Delimited Text File to A Comma Delimited Text File
Re: Error on Excel Startup
Re: Using User-Defined Functions in Cells
How to group rows using VBA
Re: Using User-Defined Functions in Cells
Disable Auto Calculate Office 2004 Mac
Re: Deleting rows based on values in a column
Test condition never satisfied in loop
Programming exercise, array
Problem with Range Object
Copy active sheet to new - do no copy buttons
save changes on close using vba
Linking the ENTER key to a Button on a Form?
Can I have "Shift-Click" or "Ctrl-Click" Code on Form List?
Block Equation Copy
UserForm initialize event run when UserForm is shown
Reading File and adding contents to spreadsheet
Store cell & workbook references, to retrieve later in Macro
Looping "For Each" problem
Select sheet, Pause till Enter pressed, return to previous sheet
saveas and excel template
Getting a list of files in a Sharepoint Folder
how do you use microsoft excel to calculate year to date average
Array values with UBound
Finding blank row and entering data in row from userform
Search form
major errors with macro code - VB question constantly doing "ELSE" part of if statement
Why am I getting a recordcount of -1
ADO from Excel to Access
Add New Line Feature in Form
Do Until
If row 2 contains nothing then move onto next macro.......
Prompt to Select Cell
Userform, all fields required
Bug?
Adding/Updating Records in Access with Excel
assign a button to a macro in excel 2007
Correct Useage of .FindControls
Can you help me figure out why my macro is running slowly?
Excel add-in problem
Excel print to Adobe.pdf
Writing data to an excel workbook
Does Excel has different behaviour than other application like MS-Word inm printing
Manage groups of WS
Error: Cannot expand named range
ON_OPEN Question
1d Variant arrays?
link list
email layout
data validation
Summary Worksheet totals
sorting w/ errors
copy cells in two columns if in bold to another sheet and insert rows
Problems Pasting in Macro
Insert " " into a string
Cut/Paste duplicate rows?
Read range to array
Moving a sheet along with macros
How switch off space auto-completion in VBA editor?
Funny Character ????
Range reference
ODBC takes time to update
Homemade symbols importet and used on the QAT?
Excel Outlook VB
Subtract named cells
IF/THEN/ELSE for sequential numbers
Off Set printing
change cell on exit vba
Decrementing row after deletion
Re: Strange calculation in PivotTable
macro to find a max value in a column select corresponding userfor
macro to copy columns
Passing an Array between Forms?
Multiline textbox for data entry
VBA for prompt to fill in the certain cell
hide option dialog box
Adding a new file extension for Pipe Delimited files
Switching from VBA to C#
Dealing with merged cells
checking if a column is hidden
Modulo 43 spreadsheet
File length of large files
How can I update VBA code in a module that is running my VBA code?
Looking for best method to automate monthly Excel report
Change Printer from A4 Portrait to A5 landscape and back again
input box default values (current month, year)
Distinguish between '<' and '.' with KeyUp?
Cannot Find Button From Control Properties
Msg Box With Exit Sub - How to quit application
if statement
Getting XL to work with only selected range
Relative cell references
VSTO updating excel dlls
how do I automatically group according to text color?
Disappearing Posting
Toggle between two opened files
Please help
VBA Intellisense
Activeworkbook and Internet Explorer
Going Rate for Excel consulting fees
UserForm In Range Out of Range
linking arrays
referencing cell via another cell
tip text for user defined worksheet functions
Changing values of an array of arrays
Autofill Question
Code work but a easier way to do this.
find count of multiple excel instances
Protecting WordArt objects in Excel
Interactive Sheet help
Data/From Web
Macro to delete certain rows in a spreadsheet
workbook_Open
Slow Structure - Row Deletion
Excel VBA Key-Code Effects Rendered by vbKeyLButton
Worksheet name
display alerts= false not working
Cube Analysis Addin and c#
XlSaveConflictResolution
error - Cannot shift objects off sheet.
How to limit user's input with data validation
SaveAs Issues
Get right Excel application
Excel to Access and Access to Excel
Offset not working with variable
Office Web Components compatibility
Error when VB tries to open file from Windows Explorer
Deactivate automatic macros on import
Find & Replace String Array - More Than 255 Characters?
1004- Unable to set the hidden property of the range class
Turn off Excel changing all date like strings to dates
Pulling data OUT of Excel in real-time.
Forcing Jaws PDF Creator
Paste data to a Word bookmark
check userform values in combination
commandbutton on workbook assistance
Copy fixed range of multiple sheets into new workbook
What is the best way of collectiong as much debug info as possible when users hit problems.
File Name Select Case
SEGREGATE THE SIR NAME
Customize column field of pivottable
Lists in Visual Basic - Excel
Check if i'm connected to the internet
Command button code
Drop down list with pricing
Cut is unsafe - call for solutions
Excel Progress Bar
Avoid Outlook macro security for Excel bades macro
Copy
Deployment of Excel addin (.xla file)
Problem with code
Outlook Object Model via Excel -- return code after send?
Copy, then Paste "Value" to the same cell...
Macro to Delete Partial Text in a Cell
Sorted appearing table (vlookup, if, concontinate)???
CDO, SMTP Server Name, and Excel's SendMail Method
Importing Multiple Text Files
MS Query From Excel to Access
hyperlinks.follow result saving
Write data inthe worksheet / array
controlsource cells(2,3) ?
How to lock the Data Controls' location from being altered by othe
SELECT THE FIRST CELL IN ADVANCE FILTERed worksheet vba code
Radio button glitch (SC)
Command button code(SC)
Forgotten VBA Password
If then statement in excell?
Slow Macros in Excel 2007
Selecting column within a selection
Calendar Control 12 printing problem
Trying to set print area dynamically
How to select the last 6 entries in range with a formula?
type mismatch
Search Specific Column for a matched entry
Saving user data outside Excel
K-Means, X-Means or other Clustering Algorithms
IFF files
Anchor Reference in a Formula
How do you program Excel to import/export data to XML files
What is the command to select a button in alert message?
Create and name new sheet...
Changing drive letter in VBA
Select a range by column number
Saving to a specific location
Need help with one line of code
Add item to 'Cell' context menu with XML (RibbonX)
Help! Search Range Using Two Criterias & Returning Cell Contents.
Pivot Table from MS Access Database
Help with Logon Information
Revisiting "New issue with "With" statment" post from 6/7/07
Catching edit mode error
Add-in programming
Get data from all workbooks in a folder. Paste into my worksheet.
strikethrough row number
convert date from oracle format to MS Excel mm/dd/yyyyy
GetOpenFileName - no array?
Number of UserForm Control Objects
Scrollbars won't show
Check for Addin before Update Links
Hidden personal file not hidden anymore
Long error handling section, safe to break out?
find text match, then grab text following
Button
Custom Button Images
Progress Bar Stuck after Crashing