Excel Programming [Archive] - Page 59

UserForm ListBox Height
Copying filtered rows
Seems there is a bug with long integers in VBA
I need help with large data set
How do I go from time to decimal if over 24hrs
WorkBook Open & Sheet Activate
Replace Formatted Cell Contents
How do you stop calculating when running a macro?
Pivot Table
What is the best way in excel 2007 to save hidden large data objec
How to use MATCH function to return multiple values
What is the numeric value of xlNone, xlDiagonalDown and others?
Tooltip on Macro Button on Toolbar
Run-time error 9 when running add-in
Update Access Query save and close through Excel VBA
Manipulate workbooks without and Office Instalation
combobox change event triggered without change
WEB Query
Worksheet_Change
Open the Find & Replace Window Using a Macro
Pivot Table Macro
HLP - Make comment appear when click cell
Input box doesn't close if input is false
Save Excel sheet as webpage with macro
remove rows from Pivot Table
Help with Two questions
STUPID range object error
Choose a specific calculating formula for a cell
Borders
The Binary Data that was saved by xlDefineBinaryName can't be retr
Prevent Corollary Event
Vlookup to choose two fields
Capture current WS Name?
Vlookup to choose two fields
Link Excel with Internet explorer (particular site) through progra
msflexgrid doesn't exist on vista
Choosing a service with a formula
Time calculation in excel
Accumulating Data From Sheets and preparing one summary sheet.
experts help required plz
Column Headers down the rows...
¥u**·s¦~..¥þ·s PSP $998,PS3, Wii.¤½»ù7§é
Protect sheet with PivotTable based on OLAP data
IF Duplicate row then cell
Copy Several named Range in many sheets to a summary sheet
Fixed length cells
Problem Using If/Then Statements To Hide Columns
protection sheet
Currency Format within a Concatenation
Wait for press a key!
Chemical formula with sub/superscript in TextBox, Label etc.
two interesting questions
File size MASSIVE but why?
Obtaining the value of an ActiveChart.SeriesCollection(1).Points(2)
Loading Combobox, but avoiding duplicates
Search a address range and street name or number return a map file
open word from excel & then back again
Advanced Filter Multiple Criteria Range not working
converte date julian to greagorian in VBA
open word from excel & then back again
Indirect to a closed workbook
Get the MIN and MAX of filtered answers?
¥u**·s¦~..¥þ·s PSP $998,PS3, Wii.¤½»ù7§é
textbox spell check
Slow Text File Import
Macro/VB Help Needed
Save as
Help! trying to send emails through excel
Hiding rows based on user input
Check for Sheet
Monte Carlo Simulation on Long / Short Equity
error when I try to convert hex to bin with more than 8 chacters?
Checking for Invalid filename characters
How date stamp & save filename?
Calculating Early Login & Last Logout
programatically change source of multiple links for multiple files
how to add bullet formatting to excel text
link and filter two w/s beginner
Change Event across every sheet in workbook
VBA & Oracle Applet
Extracting font color within a range
run time error 13 "type mis-match"
Macro acting on all Sheets
Altering an open excel document
Run aloop using a list
Passing a TextBox Object
Moving around a userform with enter
Changing cell values based on a worksheet name
Hide Zeros in Pivot Tabel
Display 3 lowest numbers in column.
Goto location of another cell value
Listbox Height Question
format microsoft query data
XLL loading fails unless load through File >> Open
source code print margins
Create a 2 column table used for data entry on a user form?
Reverse Engineer complex spreadsheet
Question regarding returning a variable value to a cell
Wanting to Create A Command Button Command
Copying sheets into a new work book
Date formatting problems
codename and cell selection
Shape Height Goes Down!
Set itm = doc.MailEnvelope.Item Error
Problem with my Nested IF, the Else output is incorrect
Check all textboxes
Comparing Formula Strings after Row has been Inserted
Looping through Option buttons
Vlookup and IF
Count Data in two Columns
RoundUp Sub/Routine not defined
Simple Change Event not working
Input data for graph
Input data for graph
importing a text file and comparing
Need some more eyes to look at this ...
Prevent two network users from opening same workbook?
Excel / Access Question
How to set "top" of listbox
InList()?
"Linestyle" in Macro
How can i set up a formula to count option buttons in a column
Set objects at module level?
Duplex Printing in Excel?
Creating new shifttime
Load picture in excel cell
List Box Match
ADO excel VBA to update data in Access
Hide Userform modeless
Visualize the context help using HtmlHelp API
In VBA How to Open two text file in same time?
using xlodbc.xla with Excel 2003
CommandButtons relocate when printing
Excel Icon
gather data in selected cells and transfer value to another cell
Programming problem.
Excel VBA Charting at Axes("xlValue")
can't enter break mode at this time
Columns AV:BE Showing (Not Suppose To)
Symbol for Not Equal
xl2007 and Windows Media Center
xl2007, problem with Activechart.Deselect
UDF returning #value
Str(Answer) Question
Find Data
How to change a value in a cell based on finding value in another
Named Range Problem
Range Formula Problem
Vatiable range
Multiple Coumns Criteria
Find Number On Active Sheet
Parsing blocks of cells using VBA
Format and DDE.......Bet this can't be done
F9 vs. Calculate Sheet
xl2007 bug, Activesheet.Name = "something" out of memory, and more
Time comparison problem
replace excel submenu with my own
Range Statement in chart
API commands and personal liability in a corporate business?
SaveCopyAs (Excel 2007)
Delete columns
Sheet protection/unprotection
specify each sheet name when saving workbook as html
Clearing Array Contents
Conditional formatting
how to get the week?
ÐŸÑ€ÐµÐ´ÑÑ‚Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð²Ñ‹Ð±Ñ€Ð°Ð½Ð½Ñ‹Ñ… Ð¸Ð· Ñ„Ð°Ð¹Ð»Ð° Ð·Ð½Ð°Ñ‡ÐµÐ½Ð¸Ð¹ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑŒÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð¼Ð°ÐºÑ€Ð¾ÑÐ¾
Runtime Error 9 Subscript Outta Range
Shifting online data comes to excel to be shifted to adjacent cells as per formula with very minimum time lag or in micro second timelag is the problem to be solved
Which Loop would you use?
Delete rows at the same time from selected worksheets
Disable Ctrl-Break
Repost of listbox losing linked cell
List Box Linked Cell loses connection
Excel 200 Automation and IIS7
online data comes to excel to be shifted to adjacent cells as per formula with very minimum time lag or in micro second timelag is the problem to be solved
Generate Reports from Excel Using Seagate Crystal Reports PLs... H
Excel 2007 macro does not work
ErrorCheckingOptions
Change contents of a cell based on cell contents.
Make CommandButton on Menu Bar
transferring data
Can Excel's speech be made to read cell contents instead of macro placed text?
duplicate a range a specified number of times
Problem writing numbers and dates to spreadsheet using ADO
Create Flow Chart using Excel VBA
Source Control For Excel VBA?
Paste no borders and values
Copy worksheet without code behind
export a form
ComboBOx
Help with creating a Macro
Data to new Workbook
UDF with Sumproduct
Creating formulas in Excel
Macro activated when a value in a cell changes
VBA For All My Spreadsheets
Count # of Days in a Month
hh:mm:ss.ss Number format
Count
Automatic Formatting Code
SQL vs. VBA
opposite of Merging data in multiple columns into one
Defining Variable Type for Items and Keys in Dictionary
Pivot Conditional Formatting
Suppress error message with saveas
Program/Macro to remove Hide/Unhide with password?
Search button in a speadsheet
Userform Error
Programatically Add a Button to the QAT?
For-each syntax problem
BeforePrint event
How Do You Programatically Select a Tab on The Ribbon?
Need help getting macro to run
Recording a macro
Check for orphan functions
Using Wrap Text after setting Row Height
Can I use a between clause or in clause on an IF statement
Paste Range to a new workbook
Name of Work Sheet to be placed in any cell
Copy information from all sheets and store on final sheet.
Error when WB already open
Macro
parent/child ranges
Quick Inverted Comma Question
Excel Macro to enter same text in comment box file's property box of 132 different files
TRANSPORT SETTINGS TO ANOTHER COMPUTER
Simple Macro problem. How do I test the entire range
Printing an embedded Word Object
Date format changes from 'yyyy-mm-dd hh:mm:ss' to 'mm/dd/yyyy'
return .caption text of worksheet control
Set "Print entire Workbook" property from interop code
Opening Excel in PowerPoint
Altered Column Width
need to automate
Save Sheets as Separate Wksheets
Fill ROW with alpha (a-z)
Update number formatting automatically
Calculation order
Rounding in VBA
Changing code and formulas in Excel Program
Insert a table into word
Changing filename causes major slowdown, any help appreciated
VBA: Force wait until recalculate
InvalidateControl in a ribbon
Maximising IE via excel based VBA
advanced search or filter
set macro security to low does not save the setting
Help file Wont display
OnTime Function Call
Debra Dalgleish - Pivot Tables (Change Multiple Page Fields)
Stock Quotes from Web
Assigning Macro to Toolbar
Select first field whilst autofilter is on
How can i compare particular columns of two worksheets and get a return
Entering quote marks in SUMIF function
Creating a 'Submit' button with in an excel form that will email f
sorting by groups of rows
shade every other line with condition
pasting problems
Converting an invalid negative number to recognizable format?
Finding records that have 12 consecutive values.
Posting data from worksheet to webquery ??
Type Mismatch error when number is negative
Copy Excel Sheet to another sheet and preserve formatting?
Toolbar troubles
getting data from a Microsoft Access table
copy worksheet without code behind
VB Code Question - Input Box
finding a file in excel
Export from Excel using alternative delimiters
Merge the contents of three non-adjacent columns
Pivot Tables need a dynamic range
Unable to set the visible property of the PivotItem class
VB refresh of query
Sort Order with Dates & Text
Help with Send e-mail
help with Unmerged cells that need linking back - populate rows
PriorSheet Function
Change a cell based on current content.
Accessing Arrays stored as a Name
opening a file in closing
if condition on a hot button
Updating a .XLA sheet referenced by a Client Sheet
Summing Similar Columns of Data
Conditional Formatting Range
Consolidate external data -- proofread #2
Switch between two states
I need help with a simple formula
FORMULA IN EXCEL
auto text
VB MsgBox Icons similar to Data / Validation / Error Alert's
VB Code Question
Could not load file or assembly HELL!
XL2002 - Resetting Checkbox values on Multipage Form
VB - Relative Refs
Naming conventions for variables
need a little help with some basic scripting
Specify network printer in Open for Output method?
Connecting to a DB without using the local machines ODBC
vlookup using range with catenated first and second column values
default pivottable page filter when parameter not present
SelectionChange
Conditional Recalc
Headers
Object doesn't support this property or method
compact Access DB from Excel
Grouped Tab Alert
Data Validation
ActiveX Control Button moving around
Trouble with copy to newly created sheet
Restore Userform
FUNCTION IF
time between two days
Interruption?
Newbie Shapes Question
Goto a specific Cell
Excessive Defined Names Causing Book Properties not to work properly
Cell Referencing/Calculations
Custom Message in Status bar
Copy data without opening file and without using ADO
Help - Search for set dates then average other cells values
Function parameters: trying to pass a control
format text as number
Error on Object variable or with block variable not set
Printing Next Row
Reading data from excel
row source
passing range to function: type of argument is byref incompatible
find matching cell in spread over two worksheets
Store information
Fill Array not working
how to enter a string value into a cell?
protecting range with macro
Delete rows if value from cell is not in list Options
xl2007 problem, points(i).datalabel.top gives overflow
Error 1004 -Application-defined or object-defined error
Whats wrong with my code?
SetFocus not working as I would expect
text does not update in rectangle box
how to set current cell (variable row) to sum values of all cells above
update second workbook
check for empty cell
Found out why my User Defined Functions were giving the #NAME erro
SumProduct in an User Defined Function
VB coding
Thisworkbook.path empty or starts with backslash
How to start an RDP seesion by clicking link.
variable as criteria in COUNTIF
Unwanted combining of Conditional Formats
restoring toolbars
ADO vs ODBC question
Retaining Values in Userform when called a second time
Password protect hidden sheet
Pivot table page filtter default value
API to MSGBOX in Excel all running applications in Windows?
Unload A Form based on a Variable in my Module
Loop through pages in multipage control
VB Code Question
Setting up headers & footers in Word from Excel
make two range exclusive
Need VBA for embedded object?????????????
Filtering tabs.
VBA Codes to combine PDF files
symbols in VBA
Excel, VBA, & C++ DLL's
Wild card in filepath
How do I change date to FirstDateOfTheWeek?
User Defined Function - Using Cell Range
How do I use VBA to modify a pivot table formula
Tricky Problem with Sequential Fill Macro
Tricky Problem with Sequential Fill Macro
VBA Do Until
Tricky Problem with Sequential Fill Macro
Passing multiselections from listbox to sub
How do I calculate a due date in excel
run macro on all closed workbooks in folder and subfolders
disable menu items
need help w-populate calendar every-other-day
Hide Show Command Buttons
Initializing a radio button on worksheet open event
Excel Import by Webquery
How to include a 'down' key in a macro
Add Charaters to the beginning of a column of numbers.
Interop Chart Series Error
disable macro during save-as
ControlTipText
Fields show in one column problem
Fields show in one column problem
Modifying For Loop
Simple Excel Formatting
SUM for columns of variable length
Offset by x
Skip ... Selection_Change Event
using sheet code name
Handling multiple SQL queries
Deactivate individual listbox lines
Focus Event
Dynamically Change a Pivot Table's Data Range
Cell Insertion
Group and Create New Sheets
Advanced Filter
Re-calculate
count if?
Nested if's in vba
Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003
Getting .NET form to respond to Excel window events
Error, when autofilter does not return visible rows
macro help please
Help with nested for loops
Seach all WS
"Object Required" error when calling .Net DLL
Eliminate Duplicates
personal.xls
Countdown timer
Check for valid national insurance number
Help with regular expression
Enable/Disable SAVE AS button from code
Can you improve the performance on my user defined function?
Print a selection based on checked checkboxes
find works very oddly
Copying data from one sheet to another on a specific date
Protect individual worksheets from deletion
Edit text of shape without selecting it
Removing Blank spaces?
One text box for multiple cells
Check if a File Exists
Shortcut Macro for Database Add-In
Shortcut Macro for Database Add-In
Pivot Conditional formatting
VBA: Worksheet_Calculate() Not being called
VBAProject Browser showing the same file multiple times
User forms "Clear"
Copy/Paste
Merging Data from Two Different Workbooks on a Common Key
Saving Excel Document as a Web Page
Code Improvement
weeknum function
VBA training source
Am back at last plus a question on calculation
if statement with sql
COM add-in form show question
ADO Scaling Connection Parameter?
Pulling Data from one spreadsheet to another
Auditing function dehanced?
counting characters in a cell
Find Method in For Loop
ColorIndex
setting print ranges to print based on option
Suppress Error Dialog: "Data may exist in the sheet(s) selected for deleting...."
Determine in VBA if a cell has conditional formatting applied
Array Properties in a Class
ADO Access Query bombs when data has apostrophe
VBA Image transfer.
change range names on a particular sheet
OLEDB rounding percents incorrectly?
How to iterate through results of SQL Query
disable shortcuts
Ping Alan Beban: ResizeArray
How to Parse a string; Delimiter is any Operator
VBA code to convert *.XLS file to an *.IIF file
about using a function for more objects
Thank You
examine value, leave it or increment it
Filtering with criteria in an remote cell
Locking Data Cells
DIR and Arrays
Macro Window - Prevent 'Run'
SaveAs worksheets
Create multiple rows
Re: Selecting ranges with Cells()
Excel 2007 "Error loading DLL"
publish excel sheet through API
Selecting ranges with Cells()
How to Repeat Formated Row
How to change weight of line in XY chart
Third-Party Add-in, Names
Pull Down Menu - Code not working
Insert Row
Trouble sorting a list and getting subtotals + totals
Hyperlink Link Field to link to file on website
help with cell reference...
Command button no displaying
Activate vs Select a sheet
Invoice Template Help #2
text characters
Button Control Moving
Excel Camera Tool Automated Placement
Invoice Template Help
SUM() cells by variables
Macro Help
Cell has focus but no indication that it does.
convert percentage to text
ADO SQL syntax for extracting specific columns from Excel to Excel
Change row height based on content of merged cell
Worksheet Change Events
Auto date & time
Get routine/function name
using CountIf in VB
Excel and Word crash when I try to add a UserForm
Excel Macro Security
Macro to highlight rows and...
Data Validation
XL2002 - Setting same MaxValue on 2 axes...
Testing if Userform loaded
TreeView Control help pretty please.
Memory limitations with VBA
Workspace / Transactions
Delete rows if value from cell is not in list
requirement for creating a sub menu in c# excel addin
pasting data in different columns
Different regional date settings in reports
Executing Macro Help
Macro for rearranges cells
Running a macro with hidden sheets
excel 2007 problem, activewindow.visible = false does not work
Unable to prevent copy/paste of protected worksheet into new docum
Create new sheets based off Data sheet, and template sheet
Formula Modification
forcing entry in input box
Replace a character by it's place in a string
Linking multiple scrollbars based on value
Looping, but with Live Data
Relative cells in previous sheet
Drop-Down List Value populates adjacent cells
Resizing a merged range
Accessing external DB, and making query
Drop Down List Value populates adjacent cells
COUNTIF Formula
left of symbol
Writing a user-defined worksheet function
Saving date created with =Today()?
Macro to copy previous row and insert two blank rows
Re: VBA Assistance needed to test for open file in a different direct
Is there a way to keep calculation mode in automatic.
Number generating an error
Macro Compatibility
help plz in sorting out the error in problem
Grouping
Inscrutable error
DSUM vs. SUMPRODUCT
Click-Sort Button: Dealing With Now-Irrelevant Subtotals?
Controling Word from Excel
Order the TabIndex
dbf Database 5 file access problem with Excel
XML Maps and SpreadsheetML
Compile error in hidden module: [user form name] Excel/VBA
default value of a control
"That name is not valid"
End If without Block If Error Help
Evaluating if a Shape is a line or a shape
Open Workbooks present in the same directory
Run Time Error"13".. Mismatch..help plz
myCell.Row?
How Do I Copy Cells From One Sheet To Another
print Cahrt created by OWC
vlookup grabbing same data for each row
By selecting a cell - change color in a range
"Unable to get Pivot Tables Property of Worksheet Class "Error
Copying and Pasting between Two workbooks
Selecting a Range based on an IF condition
Best Way to Get File Names into UserForm
VB for multiple filters
copying numerous formats from a VLOOKUP
Counting/Changing multiple buttons?
Need help copying data from one column to specific columns
Rename a Module
Many users adding to one workbook?
Printing to Dot Matrix
Application Error
signing macros
"after update" type macro
A Simple Block Diagram UserInterface
1004 - Move Method of Worksheet Class Failed
Using Weekday function with no add-ins
Help w/ modifying code... pull down menu
Using Script to download from secure site
Substituting substrings
Preventing Invalid Characters using data Validation
"Error 1004 Unable to set the ColorIndex property of the Interior.
Need help with Error 'object variable or with block variable not set'
Close 2007 add-in from code
Select Half a Worksheet
Using Icons wthin an Excel spreadsheet
Help with Simple Excel Loop
VBa code for index(linest)
App_WorkBookBeforeClose()
insert a row for every 20,000 th row?
for each doc in dir, copy data to excel
problems with hidden sheets in for each
Incorrectly getting "Subscript out of range" Error.
Macros in Excel
here is my code...it's running a bit slow though..any ideas to make it more efficient? thanks
Help!!
Spin Button to Change Label between Normal and BOLD
Automatically extending a range
Changing Font Name in Function Sub
Formulae trouble
Using Hebrew in a Macro
Using an excel built in function in a Macro
XlTable format with Unicode
Parsing a string into an array?
Formatting date in footer
using functions
add to a cell with a button
Worksheet with its own toolbar
If text found in Row, delete Column
Creating Intermediate Date Values - New Problem
Automatic Filesave using Loginname
USe VB to Get Pivot Data
Help with a Regex Pattern
Crash if two programs run at the same time?
Form Show
Find the last used Row on a Worksheet
Object Serialisation
Creating intermediate date values
Get list of files in a folder in Excel
Range - Delete question
VB style drop down menu on an excel user form?? help
Copy and pasting dynamically
Another quick question regarding moving data
If Then to delete sheet if B1 blank
Worksheet Comparison
Clear Content except for Formulas
Text File Comparison
Condition based copy/paste of range
print-out time
Compare text formatting
Deleting rows based on data NOT meeting criteria --working macro here, just need help with tweaking
ODBC Excel add-in does not work/is not supported in Office 2007?
Multiple Userforms/Listbox in VBA window
Calling macros
plz help me
Macro for index/match function
Custom Data Validation via Code Q
Selecting Cells Dynamically in Different Rows
lock cells after entry
cell refs in formula
Automatically create new sheets...
displaying input data on user form as currency
DHTMLEdit
How to search a cell for multiple keywords?
Background Color
Macro to find a word and copy all rows with this word to diff ws
Problem managing Enter Key behavior in a userform
OLEAUT32.dll
Re: Find all non-blank cells
looking for a problem solving model in an office application
Re: Find all non blank cells
FindControls ID
.Xla Password forgot....!
Left Right Mid
.Xla Password forgot....!
.Xls Password forgot....!
clearcontents problem
Add-in Error "Application-defined or Object-Defined Error"
Fun with SubTotals
Best way to learn to programm with Excel
File name trauma.
Macro which can create multiple files out of one Options
Macro to split up Excel files that are larger then 65,000 rows Options
Using Do Loops to copy data
A button Control
vlookup combo box
how do I get a macro to update dates in multiple worksheets?
Presetting options when opening Excel
Help with vlookup
creating a table from twenty worksheets
Vlookup help
highlight font by date
Loop?
VBA advanced filter
Array formula?
Go To Column A
Counting Various repeating entries
Copying Range Names to another open workbook
Referring to two different open worksheets in code
Go to Column A
Range selection for macro
Delete sheet
hideing columns
Graphs and Text Box
Parameter Query Format Issues
Saving Text File
Copy worksheet by date
hyperlinking to excel program with userform
Excel VBA using Sendmail to Send to Distribution List
Regex techniques
Concatenate Text Strings over Array
Paste in alternate rows
vbNewLine not working?
Fill combobox from data in different sheet
Protecting whole workbook
Code modification please
Proofread my code
Adding custom property to Range object
colour macro
Incrementing a variable by 1
Rows in group of Ribbon
CopyFolder Permission Denied, but who by?
Checking a workbook when it is opened
Start up macro
How do I make a button to print data from a row?
Condition based copy/paste of range
Printing Copies based on Label Caption WONT Work, WHY is it Soo?
Condition based copy/paste of range
Search for duplicates in a column
How do I scroll a the content of a MultiPage control?
Windows Scripting
Excel acting strangely
import value from outlook mail to excel spreadsheet
Really Stuck, Please Help
Macro to Audit Two Columns of Data for Errors
Print using PDF995 and cell value as filename
Printing in Black and White
Concatenate Text Formating
DropButtonclick event and list showing
Thanks to Corey and Norman
connect to outlook
HELP --- 1004 Application-defined or object-defined erro
loop each with each string
Date question
Store the format of a cell in a variable
cannot get ListObject using C++
.PDF to .XLS
Creating macros in Excel
Remove Leading Comma
public variables losing state after sheet deletion
adding hyperlinks
Copy and Paste Problems
disable a button
"Available Resources" Error
Pass a range object as a parameter
Open a file for every month
Paste to a new workbook
Adding spaces to report title
HELP! How do you add another column to this code?
variable not defined
Excel suddenly closes when a DSN-Less connection to SQLServer fails
Userforms and editing current records
Refer to controls by group name.
Range.copyPicture behaves differently??
AutoShape .. tooltip?
Referencing adjoining cells and counting in an IF statement
Referencing adjoining cells and counting in an IF statement
Retrieve date from a list in another worksheet
SQL-EXCEL VBA TUTORIAL
On.Time problem
Reference a VBA Query from Access
verify state of option button
stoping duplication in drop down list
sporadic conditional formatting problem
Last used row problem
How to Offset to get past merged cells ?
Insert Pic Which User Chooses into Comment
Reset my object variable myRng1 with each loop
VLOOKUPS
Open File based on filename in cell
UserForm, a Multipage and printing...
sheet number
Split rows into multiple sheet if.....
D
Preventing users from breaking code with ESC
Help transfering code.
public variable question
Need slight modification on macro below
Macro elapsed time bar (same as download time elapsed bar)
File searh *.cab
How to freeze non consecutive rows independantly
Find String within Cell
Help: 1004 Method 'Charts' of Object '_Global' failed
How do I draw a floating cluster Gantt Chart with VBA.
Help: 1004 Method 'Charts' of Object '_Global' failed
Copying Range based on condition from workbook 1 to workbook2
e-mail single sheet using a macro
WithEvents problem
Concatination error in macro
Help needed with copying from one worksheet to another
Help needed with copying from one worksheet to another
Chagning the font size of an added menu item
Dats in If statement
Make Workbook ReadOnly
Missing Right and Format function in Excel 97
call another macro
Update link answer = no
User form grid - resize / font size
Stock Macro Loop
Macro Loop
Usage of serial port in VBA ( exel )
Split, sort and mail
assigning text box input to a sheet
date format help needed
help needed in converting date format
Loading data into an array
Autosize bug in Excel 2007, textboxes, work arounds
Check for a value before importing a row
File comparison
Opening a Single Excel File in Different Custom Views Via Hyperlinks
Opening a Single Excel File in Different Custom Views Via Hyperlinks
Write to Word Document from Excel VBA Help Needed
Populate ListBox with Filtered Records
Using Excel as a Database
Macro fails in different WB
Type Mismatch?
Need help with an Excel Scenario
Object required error
Naming worksheets based on a cell value
Change code with code?
Extracting data from Access Database password protected
Command button code
Get SheetName from cell
BIFF8 reader
dfb Database 5 file import/query
VERGÄ° HESAP GRAFÄ°YÄ° Ä°STÄ°YROM
Why type mismatch?
Why type mismatch?
Row height
Excel VBA locate nearest point
Open Access, Paste data to table, and close all from Excel Macro
Pivot table - "...too many rows... error
Random generator question
Referencing Fields in MS Project
Regex Capture problem
Automatic saving and closing
Extract data from jpg
Using Excel Add ins with visual basic
Excel Automated Mailmerge with an Embedded OLE Word Object
Handling Worksheet Events of a Worksheet Created During Runtime.
Selecting/Copying Variable Areas
ReadOnly = NO
Conditional Formatting
Find Method Used within Values in an Array of Ranges
Std XL icons on my Forms
Office web services toolkit search problem
Cause of SheetChange Event
Formatting Macro Issue
Unique Item List still contains duplicates
Numbers treated as text
test
please help with get pivotdata formula
Unique item list still returns duplicates
Reference Numeric Variable in Macro
Using cmdlg xlDialogOpen
darn these quotes.. please help
Referencing Worksheet code name in the following code
UNDO and REDO buttons are inactive
Triggering Change_Events after Form Initialization
Data analysis: Detection and removal of outliers
How to create menu/toolbar item with picture?
e-mails not recorded in Sent messages
Help - can't understand why this doesn't work
Need help to convert date from dd/mm/yyyy to mm/dd/yyyy
GetOpenFilename
inputting American dates into an English workbook
running Excel VBA macro from SQL Server
Worksheet macro to copy formats and formula from discrete ranges
QUERY FOR TODAY RECORDS
Difficult Question about averages... Possibly Nested loops...
RE: Excel instance won't unload from memory
Macro that moves data "From Akash"
How to Debug User Defined Functions
Error in Code
Autosize bug workarounds in Excel 2007 shape textframes
Match numerical data using excel VBA
Statement not to update the file while opening through Macro
Advice on including Help files for UDFs in a Add-In
Excel VBA Reference to Forms Object Library (to be unchecked)
REname Pivot table columns
Autosize bug in Excel 2007 shape textframes
Double Space in Text Box or Excel Cell
Excel 2007: deleting macro from personal.xlsb
Excel data numeric type read problem
Specify which rows to NOT hide, and have excel hide the rest
Excel data numeric type read problem
Multi select with doubleclick event
shading cells trouble
Using a macro to hide columns
Copy/Paste problem in Excel 2007
Active X combo box help
Excel Format Cells Numeric Currency VBA
Excel Format Cells Numeric Currency VBA
Printing Excel Sheet
Access Excel Solver from a C# Add-in
VBA code to read formular from another cell
Populating cells based on a combobox OnChange Event
ComboBox Problems
"Stair-Stepped" Commissions Question.
How to enumerate controls on a worksheet in Excel 2003
Calling an Object using variables (What am I doing wrong????)
Active X combo box help
setting a variable equal to a value from a pivot table
What's wrong with my code? Thanks
MACROS 2
Populate A Userform ComboBox
QueryTable Lookup
another array approach question
Alternatives to Excel VBA (Query Tables returning more than a million rows)
MACROS
Sumproduct
Using Excel as a scheduling program.
Chartspace
find and update
IE Integration
what does target.offset(0,-1).select mean here?
Compare 2 series of columns (Combinations)
beforedoubleclick and selectionchange
Clear Office Clipboard from VBA?
array from range question
Problem with Auto Filter and Macro
Delete all files except...
Executing a VBA macro from within Excel 97 script
IE integration
PrintPreview in 2007 (for what it's worth...)
getpivoitdata and assign to a variable
Command Button to email worksheets
Consolidate Rows?
pulling data from a pivot table and assigning it to a vairable
Better looking command buttons on a worksheet
Macro to select a list of values greater than or equal to a value
If Conditional formatting
conditional formatting to print
Adding a Custom menu / sub menu
Save as filename
hide column
Pivot Tables and percentages
How would one merge this into 1 cell
Excel VBA - Sending email
Custom Button and End Users
hidden character in string
Digital certificate in outlook
Sorting chart by name
Macro cannot be found in Read only modus
crash on close
VLOOKUP Trouble
password recovery
Calendar Control - Years
Stopping copying and emailing of a Excel File
Break Links Macro help...
Using OE to post and read newsgroups
E - Mail when sheet updates - hyperlinking !
Sorting by chart name
Moving a worksheet to a new workbook when you do not know the name of worksheet
List of pivotitem visible
Extracting Specific dimensions/values from multidimensional array
Control box/Command buttons
Select Range Name Q
Pivot Query
Setting Variables
Using COUNTIF with an AND? Or is it something different?
Object Required Error
how to autofill a consecutive cells in a column?
command which returns the position of cell
How do I get this to look at a date and loop down all the info?
ranging the filter cells when doing auto filter
Excel2007 to DBASE4
help! Why my code can't work in excel 97
AutoFilter Criteria in VBA
2B or not 2B? - Go to cell Bx, depending on what row is selected
Cell format reverts to a custom date after change to General
Alert 'Micosoft Forms' when Closing application
User Date Picker rather than Input Box
Show worksheet from cmd button on userform
How do I assign a value cell in a column that has a dynamic row va
How to capitilize automatically?
relating 2 sheets
Create email from cells in Excel?
Excel web querying stock and mutual fund info?
running some VBA code in response to data entered in a cell
VBA to Fix Dates
Macro security bypass for one application
Is there a code?
auto set time(now) if criteria=true with no later change
Setting RGB colors for a set of cells.
High Security setting
Excel Prints the Page as a Tiny Little Square
Insert a comment on ComboBox double click
Macro step wasn't recorded
Copy from Word into Excel pastes wrong picture
MS query criteria - referencing a cell on a spreadsheet
Locking a TextBox in a userform
Test for Disable / Enable Macros
SELECTING TABLES & PATHS
not calling
Autofilling INPUTBOX
put inputbox input into a cell
Multiple column find
Help with userform labels
How to programmatically create range for solver?
My 3rd Msgbox is popping up in wrong position
PrintPreview problem
Use A Command Button more than one time
Prompting user to enter number of cells to be used
Size Matters - minimizing file size
email forms
Odd macro behavior
BeforeSave, Cancel and ReadOnly
Find data in other worksheet
Comparing two dates using between.
Selecting an array of worksheets for printing
Totalling Formulas