Excel Programming [Archive] - Page 29

Combining several workbooks into one file
Help/Advice Required
Excel vlookup function with complex copy and paste
where is download sql.request
Disable update links prompt
Change paste to only paste values
QueryTables.Add() not returning text from SQL Express table
EXCEL IN WEBPAGE
Run DOS command
BeforePrint
Sorting
Creating a macro for date range.
check box sort
Function to Check Borders
Find a single "0" (zero) in find command
Delete a filtered set
Finding document title
Complex copy and paste in excel
Protection Malfunction?
Two Saves for one event (sheet1.xls)
Add-in Question (common code)
VB 2005 User Defined Function (via Automation Add-in) Generates #V
Referencing year portion of date
Help with creating a time sampling loop
Combining cells
Web Query Results to an Array
Count Uniques in Column G Until Change in Column C, then Restart C
Changes made in first tab-automatically update through subsequent
save sheet as pdf and email it
Unique Filter Macro not working correctly
Application.InputBox usage
XL2007 - Shapes - Adjust 'Smiley Face'
if data is "A", then paste it to another cell
Deleting cells if there is an alphabetical character in it
Suppressing footnotes on alternate pages
Error selecting range from userform
Making a "ding" sound in the macro process
what is the ^ used for in Excel formulas?
Populating List box with tab/worksheet names
List box to create array
Barb How do I get back to you...
ignoring a sub routine
Extracting House Numbers from Street Addresses
change event for cells within a range
Minimize IE window
Excel programming of formulas and globalization problem
HTML Span
How to open monthly workbook ( different file name ) automatically
Thru VBA, how do I e_mail with ONLY ONE CLICK ?
Multiple Activex TextBox on sheet auto size and move
Macro to find a charts data source
macros for linking multiple workbooks to one workbook
looking to pay for the solution
Help - Create Context Menu for Text Boxes
Dynamic Array
range naming not working in VBA
Saving File with the VB Modules protected giving me an error. Than
Barb...Don't know how to get back to you
Clearing Rules from worksheests
A mailing list in Excel
replace vlookup
Excel VBA programming assistance 2 PART CHALLENGE
Show text in the Funtion Bar
Yes/No Msgbx doesn't follow directions
Excel 2007 & Vista OS
Userform to increment line item numbers with textboxes-spinbuttons
Excel Named Ranges In VB.net
print specific pdf page from excel
saving 3 worksheets in a workbook to a separte workbook
Case Sensitive Input Box
Out of Memory Error when calling Userform
some more explanation
Why does code run evry time any xls file is opened
Barb...you helped & said come back
enabling macros from command line
List all code in workbook?
formula to value
Toggle Button
Return a Range from Function
Combine, sort, & then create worksheet
Sort help please
Need Help Writing VB Code on a Template
Changing the Date/Time Stamp
Maximum value as well as Sum
multiple criteria
Set tabindex automatically
Word art in excel '07
PLEASE help with difficult problem
Activating a tab within a window
Calculate according to Drop Down control list value
Add-In Loading Error
Check if the value of one cell can be found in a number of other c
days calculation
Can this Macro be modified?
SaveAs - - provide option to Save As .xlsm or .xls
Assistance needed with Macro Modification
Code to Copy a Formula to Multiple Sheets Q
Add-In Problem
VALIDATION IN MACRO
VBA code does not work
Universal VBA code for opening MS (Office ) programs from excel
Create a new Sheet Q
Macros security
migration of excel 2003 macros to excel 2007
Highlighting special characters in a string
Hide "All" in pivot table
how do you change the rotation center of a shape(vb)
excel 2007 sorting leaving blanks where they are left to rigth
Remember file name selected
Macro - message when there is nothing to filter
File name in macro
Type mismatch error
Split 9 weeks of data on a worksheet into 9 separate worksheets
Error controlling Word from Excel
Leading Apostrophe appears in the formula bar but not in the cells
Input to Save As Macro
Code to get data from Yahoo Finance
IF Then Statements
Relational techniques
IF Then Statements
Fill an Array or Collection without knowing the UBound
Type date in first cell of row, 13 columns over - auto extractsmonth for each row
Open Excel workbook from Access
Horizontal Scrollbar on listbox
Split a worksheet into multiple worksheets of the same Excel file
Lost macros- How to get them back
Skip Worksheets With Looping Coding
Selecting an existing worksheet
Find first value != to something in Excel 2003
Need Minimum excluding blank cells
Search specific column for a variable date
How many keystrokes can I send per second?
Find first and last instance of value
Comparing data on 2 worksheets
match/Offset help
ComboBox.Value cannot be called in VBA?
Copy contents to a selected sheet in another workbook
Wordart in '07
Do Until Macro
Code
Programmatically call the Find and Replace window?
Just for the “Cool” factor (gage).
Web Query
Loop slows down
Macro Continuous Execution
Format PivotTable from VBA out of MS Access
Update Formula Loop
Select Range
Microsoft Excel can't display Help
Multiselect with Combo / List boxes
Listing / comparing macros
World map embedded in userform.
Save data without code...
Unique numbers in array
"CommonDialog" is not working
Macro running through selected fields only
Mystery Apostrophe
calender days in excel
C++ Excel Automation
Compare worksheets to copy and paste data based on matching criter
excel 2007 sorting
is a multiline possible
Registry path for links startup prompt
Autofill Destination range open
keyboard press indication
problems running macros in excel 2007
Extract specific data from multiple workbooks to a master file
Excel losing hyperlinks when I sort the worksheet
Referencing a Origin Cell from Data Validation
Test loop required
copying & Pasting Multiple Ranges within a workbook
Web Query (Java Page)
How to overcome Inputbox 255-char limit?
IF ISERROR with index match
Linked File Names and Path
Fill Color
Images in UserForm?
Convert now (current date and time) to a string ddmmyyyyhhnn.
How to maintain dynamic data range for Excel PivotTable
Place value from list into specific cells
UDF to set cell number style
Change cell references
Creating an xsd to export xls to xml
Using VBA functions in MS Excel
Excel going haywire!
Change Cell Event
Worksheet tab macro
Macro Functionality
Calculation issue
Splash Screen Behavior
Macro code
Filldown code
Problem Populating a ComboBox
Last modified by
Hide Activesheet
Mail Merge to create new spreadsheets
Using Sendkeys with conditional statements
Follow Hyperlink in Excel 2007
How create an Outlook task from Excel
Online Resource
close excel with no selection
Trouble figuring out how to Loop through a huge repetitive macro
I would like to copy a date from one cell to another cell
XL2007 Pivot Table causes code to run slow?
email spreadsheet with text in subject & body to multple recipient
Method not run if code after Application.Run
Excel VBA Macro handbook
Line of code causing a beeping sound
Different way to sort?
different color text in the same cell
Source info deleted but chart still shows
Macros and field names
Array formula to code
Time Ticket ...Im Lost
counting spaces
Insert Row and Copy Down From Above
Dropping A DROPDOWN on set focus
Slow response from excel
Merge Data with Query Option
Is it possible to remove the page watermark AND maintain page brea
Copy & Paste & Clipboard in Vista Excel
Refer to first cell in range
array help needed
Calculating the number of unique values within a large range.
concatenation query
Userform input to control two diferent workbooks
Automate anonymysing of data in charts
CD Tray?
how to put mydate into activecell as dd/mm/yyyy excel 2007 vb
Put a picture in a text box without selecting it?
Sorting a column
Sending email when a cell equals certain value
How do I pass a variable cell reference to a Range Object?
Advanced Filter - Get the unique rows
problem with DLL Library
Print two different areas on a worksheet
add toggle button in excel
OleObjects add monthview
Delete Duplicates
Check to see if user is connected to cube on a spreadsheet
Run a macro only for the selected fields(records)
VBA corruption
minutes aren't minutes?
Hiding rows based on character recognition
Where do I locate and install VBA CONVERTER for Excel 2007.
Sort Data in Specific way
Crashing Excel 2007
Hiding rows based on a date function
Returning a file name after checking for specific character
How to Delete rows with blank or specific value in a Macro ?
WorkSheet Change or select based on a cell value
string function 2
string function
sub inheritance
can not save spreadsheet from a windows service on windows server
Right click to change cell values
Sort dates
Sort Date
re: appending data
VB.NET 2005 to 2008 but still windows 2.0? Image object problem.
Max
Create a new workbook and add sheets
Need to write a file to a location.
importing text files into excel from a set directory on a montly b
Formatting for time
Code Runs when Excel Starts up
VB scripped works in Excel 2003 but fails in 2007
VB Code Based on Contents of a Shape
Match WorksheetFunction Question
VBA Code-listing page break
Need help in VBA
Deleting rows in multiple worksheets
Import data from query in Access
error 1004
Refernce sheet names in if statement
User Function.
Why am I getting a Compile error on my SQL statement?
Copying & resizing a range?
InputBox
Resizing a Range
Select Dynamic list for rowsource on a list box
Offsetting a Range
If Statement help
A Macro that gets data from an ASCII file
Sorting a Loop
Unibol program/macro
Excel Random Sampling
Insert 2 formatted rows at cursor location
VBA SQL Select for Column Name
boolean to control sort order
return random value from visible cells
boolean to control sort order
How to speed up code
get the day of week from a date
sheet selection from an input box - Thank you
run macro when drop down box equals
Drop-down box always visible in a workbook
Add ins not loading on existing workbooks
using namespaces in an excel macro.
Validating and amending numbers entered via formula
Change external source location of Pivot table in EXCEL2003 via VB
Macro suddenly stops mid process through an array
Arrange Data Matrix into List for Access
how to handle error in for.. next statement
How to create Style with Gradient
Scroll the Scoreboard
AutoFilter code to delete rows
NumberFormat
Need to know grouped count.
HELP: Excel Interop objects and checking for nulls?
Import images from a website
I need help....
Currency conditional formatting
Add macro to right click
MSSql query discussion forum
Categories
Auto-complete for multi-valued cells?
Can't use Autofill with a User Defined Function in VBA
Selectively Delete Defined Names
Date stamp in worksheets
Timestamp Macro
Macro to copy to any active sheet
Spell Checking
Prompt user to select a range
VBA code not working for my colleagues
Sorting row by date.
each new query result shifts output cells, sometimes...
SQL ORDER BY
Macro to use an refresh a worksheet using an excel addin
List box problem - from monitor resolution
Macros in Previous Version
Macros for some basic routines...
Trim help
Test for multiple rows
Can't Delete Add-In Reference Workbook off Server
What was I thinking?
Re: Cell Validation Help
match one column with dates to several colums with dates, copy pas
Checking for open workbooks Repeat/Loop VBA code
Unique Filter Code / Advanced Filter
Now for something a bit differtent ...
MS Query using Parameter in In() statement
What am i doing wrong here?
Browse Window
create a vlookup formula with VBA
Need help with a formula
Automate Printing of hyperlinked PDF's
Loop for check boxes
Calling Form Routine from Another Workbook
Removing Macro in ThisWorkbook
Multiple workbooks, one task
adding data to a list from another worksheet that updates automa
Sub to check files in folder and remove Module1
Ron DeBruin's "Enable_Keys" program
Selection of text from a string
Imported text file to begin from the first empty cell
Reading directory names
Hide rows within range if B? = X
Format Msgbox - time HH:mm
user form infinit loop
object Variable or With Block Variable not set
Help with slow Macro
Edit cells with user form open
How to run a function from a variable
Moce cells with some programming
Hiding cells in another worksheet
Macro to create next number in sequence to be used on 2 workbooks
Copy Cells Q
macro move cell with text one to right and one up!
copy values from range of columns
Change Text to Uppercase Excel 2003
Re: why does more than one cell highlite when one cell is selected
Convert array formula into VBA module
Excel worked OK on XP
Re: Built In Name Error
VB copy formula and auto fill a range
Combine worksheets into one workbook Just can't get it....
Delete Rows based on # of rows (no variable?)
Excel 2003 unable to detect SOAP 1.2 web service with wsHttpBindin
Excel 2003 unable to detect Web services with wsHttpBinding (SOAP
Re: Delete blank rows
is file available for editing ?
UserForm
Macro to add columns into worksheet
Help with an error in a csv file
Excel Chart Problem!!! (Bug I think)
Sort code fails
Loan Years no half years allowed?
mapping a macro to the keyboard for use in another program
My macro does some of what I want, but I'd like it to do more
Prevent Word Document_Open from running
Ping Otto Moehrbach
Single quote in filename causing problems
Assigning a formula to a range
I broke VBA
Find an empty cell across columns
switching between workbooks
Preparing an address book...
Sorting - Finding last row
date conversion....
ActiveX CommandButton graphic missing.
Why is Referenced Workbook Saved When ActiveWorkbook is Saved?
Selection.Font.Bold = True
Is active cell editable?
Unable to set Installed Property of AddIn
Insert colmn
Excel 2007 Charting macro
Help with copy entire row in a new workbook using a specific value
Code location
Finding a empty / blank column
Convert Row Data to Column Data
Macro for Copying Data
Hiding secret formulas
vlookup
Is it possible to put spaces in a string of data
Placing image in a cell?
concatenate problem
Compare variables in two excel workbooks
Does VBA have a garbage collector?
Please explain this AutoFilter procedure
INDEX and VLOOKUP not working
how do you set up an employee rotation in excel?
"Send Email" macro to multiple addresses
Saving File with name and date
How to cancel a macro once started?
Date Entry through input prompt
probably simple - type mimatch error 13
Excel Programming - Macro
do not show
Type Mismatch when trying to sum columns
Move data to column based on startdate
Search HTML Source code.
PAGE SETUP
Share global variable between workbooks
Best way to call a SQL Server Stored Procedure from within Excel
A Script to Create a Recordset and Import Data to a Spreadsheet
Capture a group of cells as an array
VBA Editor "flashing" while Excel is still NOT Visible to the user
Moving Shape
Procedure Activation
SeriesCollection Question
skip blank rows
Excel 2007 Application.ShowMenuFloaties Bug
Delete rows
descriptive/help texts for parameters in automation addin (vb.net)
Search HTML
set label text of controlformat
Adding a worksheet within the workbook at specific position
Select Case Statement - Help Font Color
std_
With statement help
Slow VBA (Vlookup)
Error on connection to recordset
Search web source code for specific string
Macro to tab down 2 cells
Cell data based on autoshape color
merging column values and transferring them to another worksheet
separate multiline address into separate columns
Lookin cell values, copy a range and paste it
print option
hiding rows or columns
UDF Last Save Date returning 3 different results
Clear All Fields Macro
Macro for save as
Find last blank row and use in a formula
How to create Style.Interior.Gradient property
PivotTable/Chart Filter on Click
Shortcut menu - submenus
BeforeRightClick event vs. Selection Change
Adding User Dialog to Macro
Find an Alphanumeric in across columns
VBA formula strings longer than 255 characters
moving treeview node
Time milliseconds format
MS Query and calculation
Closing Outlook VBE from Excel
Retreive part of the value from each cell - Macro and/or forumula
Error when opening Embedded Excel File in Word
Copy contents of variable into clipboard
Marco similar to a SAS program
Loop through all sheets, calculate Average in K1 of each sheet
copyFromRecordSet code in excel-vba
Copy Paste a file into a folder with the current dat
Macro to calculate hours per work order
Learning VB
Copy Paste a file into a folder with the current date
calculate percentages of 8 hour day
Save workbook without code
why does a Visual Basic Window pop up after a screensaver
Lookup in userform without erasing formula everytime
cut paste row to end of WB based on criteria
Shortcut menus in 2007
Count number of cells with data validation errors
variable print areas same worksheet
Filter list in same worksheet issue
If end sub
beforerightclick and selection change issue
Consolidated/filtered list issue
write to range object using vb.net
Open FileName For Input As #FileNum2 - - - File Already Open!
auto freeze panes procedure
Toggle ListBox display?
Detect file format (version) of Excel file
How Do I Run An Executable from Excel?
Test if workbook is not yet named
Data type issues adding data from vbscript
Hide rows with value of 0
Conditional hidden row
Only show currently active file icon
How do I save a single worksheet to a different file using VBA 03
UserForm Textbox.setfocus help
Looking up multiple values with in the same number
Set print range to last row and last column across different sheets
Convert Local Names to Global Names
copy specific data to another worksheet
Problem with size limit of function's argument declared in VBA
sum the first number in a range
Selecting Max 20 Numbers
How to remove warnings about rewriting cells?
How to remove warnings about rewriting cells?
For Next Loop and If..."Relative dose*"...Then
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls")
QueryTable import keeps appending instead of overwriting.
Indirect and matching formula isn't working
Wildcard for space text space pattern
Save in VBA?
scope of public variables
AutoFilter selected row not 'retained' across user unselect/select
Better way to apply a formula
How to read Office Product ID in VBA
Toolbox pops up
Use lookup results from closed workbook in page header.
Getting maximum number of fonts have been exceeded error
How to trap "Can't find project or library" error messages
Code to state if something if there or not?
Calculation on data from SQL database sing MS Quwry
Best way to call stored procedure, have results return in cell ran
Referring to a frame with a frame
Enable automatic popup when entering data
Database query and calculation
Max character for each column.
Error deleting worksheet (Excel 2003)
Macro, formula help needed,, please
EMail to an address in a cell
link to a cell in another page in vbe..
concatenate cell.value
Rename Excel file via VBA
Delete Rows of Data in multiple Excel Sheets upon importing to Access
Excel sheet with form - Path/File access error
Finding a name for a range pointing to "this"?
Setting up a Progress Bar
multiple title rows
Disable all shortcut menus in Office 2007?
Export specific cell values to an external workbook
Add item to combobox in sheet
Trapping errors
How to check IF new folder has any workbooks in it.
FormulaArray limits?
Writing VBA Code to compare lines of the same invoice.
Changing control Panel options
Copying specific data from Sheet 1 to Sheet 2
Copy a specific range of cell values into an external workbook
VBA Code For Pivot Table.
Error for a replace. It replace ALL instead of selected column
Adding a Chart with a macro in 2007
show/hide comments
method "range" of object "_worksheet" fails
Assigning a shortcut key with Alt Gr
Extracting for calculations
How to use ENTER in a TextBox in Excel 2007
sample vs. population proportion using a z-score in excel
Insert formula based on input box
Save Copies of Workbook with Before Save Event
Delete row if "Not" found for Multiple conditions
Macro to add text to cell
command buttons
Sheet Name Formula
read data from access table.
OnKey - usable to assign new shortcuts to existing Excel keyboardshortcuts?
Hover Messages
Copying charts to existing Worksheet
best way to..?
Pivot Table Criteria Missing Data
Filtering
Values in multiselect listbox
Block display during Macro
vba paginainstellingen meerdere bladen
students course
Testing for an empty worksheet
Writing a month name from its number
export method filter specific options
Another Days, Hours, Minutes, Question
on exit field
Chart update
Numbers are text and won't match using a formula
Need help with either a function or programming
Autofilter Criteria
Produce a workbook for each employees data in a worksheet
Matching formula - Can we have a variable field for the row number
Calculation Help and balances pleaseeeeee
Using vb.net collections in VBA through COMClass
Assign different keyboard shortcuts
Excel ribbon problem with Quick access toolbar
install graphical filters
Referencing another workbook in a VLookUp
Listbox controlsource runningtotal
Help with If Statement
import data from excel command button
Shapes Theme effect fill - Excel 2007
Using replace in VBA
Return to last position
how to encode statistical formula
Deleting blank cells w/o impacting other rows/columns
Toggle button - procedure works but elegance needed (xl2007)
How to use Implicit Intersection in a VBA Function
Programing
Backspace brings up an error
Data timesheet makeover
Excel-Printing to specific tray using macro
Delete first line line(s) of text-file?
Delete rows of data in multiple sheets
Changing macro security causes VBA code to fail
if then nested in a for next ??
Interactive Data Entry
Inputbox information sent to cell A2
Why, when I post a thread, can I not reply to a response using thereply button?
Checking number of characters in a TextBox
Paste Special - Values code
Why does code keep going to function?
countif
Separate first name and page numbers
VBA Code For Pivot Table.
ean128 barcode fonts
password protect multiple worksheets with macro and exceptions
Excel Pivot Table - Get data in Pivot Field
Find First Cell without a Certain Value
Programmatically close 'Source' worksheet and refresh Pivot Table?
Excel 2003 Match formula not working in Excel 2007
Value setting
Personal.xls and Macros
I want user to select the worksheet
Insert date & time when 5 condition are true
Hyperlink jpg files in Dir via VBA
Pivot Table - Grand Totals
How to activate command button on form by macro
Adding a set of numbers and inserting a blan row
Returning Part of a String
select entire row from a lookup
Changing absolute address to a relative address
Inquiry Error
Index Match error
I want to have my spreadsheet connect to SQL Server with variables...?
File and Folder Permissions
Problem saving file to My Documents
Copied sheet not to have links
Transfer Excel data into Word forms
NumberFormat = "@" syntax
Sorting list box
Code the Quick Access Toolbar?
Selection is too large - when pasting formats programmatically
List box sort
Code for next row
How to Stop to Group of Shapes to be deleted
Re : Excel In Search of a Certain Comment
An alternative for the edate function...
Has anyone got an efficient way to do this?
Run macro before closing Excel 2007
import data from website
Convert data entry to mins:secs
Capturing data only when a column "Value" changes
Cannot access Excel created w/ German version of Excel
Help with deletion of Data in Multiple Sheets
Help with deletion of Data in multiple
Calculating calendar days excluding holidays
Date from string
Automatically change autoshape color to that of another autoshape
Loop Skips Data - Why?
Copying nothing/everything when an autofilter returns no results? XL2003
Right Click Option Missing
Workbook with no code now ... will need macro functionality later
Resize Range & Fill Column with Formula - Help
Using form interactively or programmatically
Application.Run error
I've inharited a spreadsheet that I need to change the query to an external source...
Lookup cell address of listbox selection
PopUp w/ Save as XML Encrypted in 2007
Checkbox to Hide Column G
Pivot Table Excel 2003 & 2007
Expert Macro/VBA Help Needed
macros using excel
Private Sub Worksheet_change ... Procedures jamming up
How to extract "destination address" from Hyperlink - VBA
Problem with using VS2008 to develop vb.net Excel application
Adding a condition a Macro
Macro 2003 vs 2007
How to Assign Worksheet Module to a Shape
VBA Formula Help
Error handling for missing Outlook attachments
Copy formula down variable rows based on (lastrow) from another sh
DCOM Configuration: "The operation completed successfully"
Use Workbook BeforeSave Event to Save Copy to Different Location
changing a macro to do pivot tables
Need a text number converted to numeric & it has a formula in it
Tabs Jumping
Getting Application.GetOpenFilename to open correct folder
Excel VBA:Using the #const debug concept with ON/OFF switches
Question About a Shared Workbook
time and spinner
Importing Text file (Again)
Select same cell after sorting
Automating marrying PERSONAL.XLS and Excel11.xlb?
Diasabling Macro PopUp
error 1004 with a twist
Repeat fill on header
Run Exe file
Is this number validation possible?
TypeName:="Line - Stacked Column on 2 Axes" ???
Password to Lock out VBA from View
copy all but formula to next empty column
How do I assign a picture to a cell
combo box 'disappearing' font
Finding a column name
Syntax for a formulae in Visual Basic
VB script to change cell wdith/height in inches.
Finding top 5
ADODB Connection Column Limit?
Macro Copy/Paste error
Help - If statement in cell
xlb size and addin with custom toolbar
Custom Document Properties
Wildcard operators to use with LIKE
Problems Pulling Data from 2 Rows into a Report
Counting using multiple criteria
Improve the performance of Excel 2007.
Office Assistant went away w/2007 - Now What?
Macro for inserting lines with Text
Work With Object Using the Path String
ODBC - Excel 2007 - Cannot load DLL '?????L'
When Activating workbook always goes to left most sheet
Re: Pasting values on first blank row
Importing Text file
Selecting Filter Data
calculating values depending on columns in different wkbooks.
Populate Combo Box
How to add totals for specific descriptions on a table
Validation fields linked to pivot tables on separate worksheets
Get Filename without the extension
ComboBox RowSource Dynamic
Excel 2007 listbox width problem
listbox
Code to Accept only a 0 or this...
Excel 2000 Simple Shell Command Doesn't Work in Excel 2007
copy specific cells from a worksheet to another
Identify "parent rows" in a grouped structure
Import a CSV into an array?
Create Userform from Worksheet
VBA NumberFormat problem
Prevent Copy/Paste Q
Check for Folder
How to calculate unit cost
Check for file in folder, if not there, open folder to rename file
disable entry on listbox
Ontime function
Resize and position excel window
Creating drop down columns in CSV
Excel date displayed wrongly
Anyone made something in Excel to draw schematic of a network?
Excel2007 sheet returns workbook.name as temp file.
Deleting Empty Rows
transpose values
How to set up a weekly Pennant draw with list of players and not
Timing Multiple Events
Displaying data Horizontally
sum across cols using for/ next
Why EXCEL is going into Breakmode and open code window.
Naming/Renaming a Module
Copying part of a string to another cell
Printing updated sheets within a spreadsheet when files are upload
Convert Decimal Minutes to Hours-Minutes-Seconds
PERSONAL.XLSB
VBA Dictionary Trim to N smallest items
How do I convert a macro that was created in 2003 Excel to 2007
Test for numeric constant in a cell
Application.Quit
Billing Statement Help
Cannot run debuger properly
Problems with moving to next empty column
Need to add hyperlink using VBA code
.movefile
Determine which commandbar called a function
Read csv to 2D array
Personal.xls macros will not work in any other sheet
Programmatically Disable Taskbar
Return caption of unknown button into a cell
cell.Characters and Fonts
Help Deleting Rows
How to work on a new worksheet
comandbar controls
swapping out drop down box
Search for cells that DO NOT contain specific text
vlookup
Macro Help
ActiveWorkbook.UpdateLink. Not updating!
Add reference to Outlook library programmatically
complicated command button
Adding Sheet using Template creates link
simple copy paste multiple range macro ARGUMENT ERROR
Data Not Transferring From Source to Data Worksheet
Protect Macros
System.Runtime.InteropServices.COMException (0x800401A8)
Convert Letters to Numbers?
How to force column formatting (text, date, etc) when loading a fixed width text file into an array?
How to code tab order for Controls in Excel forms
How do I get the current Date to autofill in a column
Corrupt File Issues - Opening in 2003
SendKeys
Using a variable to select a CommandButton and setting the caption
File Search for Combo Box Usage - Excel 2007
preset range
Validation of text cells through Code
Const declarations and accessibility
unmatched data string
consolidating sheets - Ron de Bruin can you help me. Thank you
Issue about send email through lotus notes
Userform - On movement leaves a trail.
Macro's Pasting into continous rows
Macro Problem
Pasting values on first blank row
Test if a Workbook is Open
How to run sub menu items from VBA
Merging Rows
How to edit MyAddIn.xlam
Macro to select a variable range
Keep a record of entries in cells
User Form
SaveAs
auto run macro on cell change
Date Issue
To open an excel file.
How to create a standard Quick Launch menu in Excel 2007
Update A Url Image
Get an enum value assigned with *concatenated* string
Get an enum value assigned
Reset to full rows visible
Send email with Outlook
switching out drop down bars
Enter parameter in MS Query for updating Pivot Table
Validation List
Monthly Calendar Form
How do I trace link errors?
Script to Split up Worksheet into Multiple Sheets based on a Columnof Data
Moving data to another Sheet
Lock individual modules
sub for filling each cell of the grid
How to run an API
Scope of private function
Find an Alphanumeric in a column
Ending Procedure When Condition is Met Anywhere in Procedure
Scope of private function in VBA Module
VBA Macro - ranges & pivot tables
userform control value as constant
Changing the visibility of Textbox/Label Based on Two Checkboxes
3-character combinations?
Programming the VBA Editor Question
UserForm CheckBox Help
Subtotal method of Range class failed
FSO.MoveFile
Why does this COUNTIF code not work
EXCEL VBA RANGE Question
opening files in excel 2003 when 2007 is installed
Yahoo Quotes Macro stops functioning
filter part info
VBA Import Convert Data Type from Type 1 to Type 2
Linking the Regression equation of a line to a table
Use VBA to reset data validation (=list) value to first value in that list (list is a named range)
VBA to select rows based on selection
VB Form as Menu
email Word DOC along with XL sheet?
running 2003 and 2007 side by side
Print to PDF
Storing Rows.Value in a single variable
How Write for RGB palette?
Display charts on a userform
Set DTPickers Data to Todays Date by Default
XL2002 - I'm having a bad day!
Workbooks.Open not working from a service on Vista
Using a Variable to point out a listbox.
Test If Workbook is Open in Network and On Users Computer
Can't get combobox to display 2 columns.
inserting and naming a tab with vba - any help please thank you
How to control how much gets printed (prevent printing blank rows)
Personal.xls macros will not work in any other sheet
HIDE / UNHIDE sheets based on user answers
Starting a macro by changing autofilter criteria
open save as from list
Count If query within string
CountIf query within text string
CountIf query for words within string
ExecuteReader on empty Excel range hangs
To assign list of number
look up formula
To assign month for a certain range of date
Selactively read text file
Importing CSV - Avoiding conversion to 'dates', but totally different results when controlling manually
excel2003 trial still available?
excel 2007 security
scope of private function called from UserForm fails
Compatibility mode
Hidden worksheet problem
Modify to only work with nominated range instead of entire sheet
require cell completion before saving
FileSearch misbehaving
On Error action inconsistent
Convert numeric field from type 1 to type 2
Print Only Visible Rows Using AutoFilter
Select a range based on Fill Color
List box sort
Combo Box row Source
Opening the VB Editor via VB
getting Cell2.value=empty when their are values in the column
ActiveX error - multiple workbooks appearing in vbproject
Code for insert .jpg file
macro hangs if no data is found
VBA
adding rows to spreadsheet
tool bars
Using a typeconverter in Excel PIA assembly
looking up data and using a combobox user form
Can I use Select Case to do this?
branches /loops
VBA code
Strip first 5 characters from a cell.
Combo box should trigger another combo box
Vista, IE7 and Excel 2000
Event macro does not run a Private sub
How can I open an Excel workbook using a cell containing the path and filename
Change event
chart question
API run program
Run a program
RE: Assigning values to dates
collect data from sheet and put into one row of csv file
Macro email
Teacher Substite
block characters
Use of Split
combo boxes entering data
Trailing zero's
Reading the keyboard in VBA
Moving a form using a button
Why isn't this code to change the font colour working?
preset table
SENDING SERIAL INFORMATION TO A COMPORT
Write data back from form to rows
Write data from form to row in sheet
predisigned table
Disappearing Personal.xls
formula works when pasted, but not when typed
Workbook change event when tab color changed?
Selecting Radio Buttons by Using Macros
Number Format
Add multiple custom lists
Printing Sections of Worksheet Using AutoFilter and ListBox Values
macro to find data and filter it and copy to another worksheet
If Then using "Find" command
Open a text file in a template
automated cursor movement in Excel
VBA Workbooks.Open - Suppress File Currupt Message
comparing a column in two separate spreadsheets
Selecting a group of tabs regardless of name and amount
name of workbook...
Private Sub Workbook_SheetChange
inserting data in a column based on data in another
goto last cell with data
Userform - calendar control
Revision Control
Checkbox for list-totaling
need help
Lock colon in textbox
How do I insert a button in Excel 2007
Swap trailing minus to leading
CalculateUntilAsyncQueriesDone()
Calculate Change
Radio Buttons Created Dynamically
Listing Active Directory groups that have directory access rights
Iterating over a nested Dictionary object
Cant find a Control
BeforeSave macro
How can I email a spreadsheet as plain text using MailEnvelope oranother method...
Get Value of ComboBox in Menu
Opening workbook - get error message : unreadable content, lostvbproject
How to Print varied page numbers in a single print job without col
Reverse axis problem between 2002 & 2003
How to use excel vba to specify the path of a link table in access
Delete Rows on Set Criteria
How to let the formatting follow data during sorting?
Auto fill Sheets
Commenting out
Format VB command
CONCATENATE IF macro or function?