Excel Programming [Archive] - Page 33

recordset question
Convert macro that runs against entire column to run in current row
want to change tab color based on the info in a cell.
Button Problem
Need Help
How do I set an environment variable to a string
How to delete a "return" character (a "box") in cell of imported d
IIf Function
cell value syntax
Assigning values from source cells
how to check if sheet has graphs?
Check hour format
mod error in VBA
Identify cells based on format
Center result on screen
Really Help with existing VBA code...
For...Each loop not working
List Box Columns
determine dropdown value
Zoom window to selection (further clarification)
PivotTable: How to reset the CurrentPage to (All)
Need assistance with Excel 2007
Zoom window to selection
Pictures in comments Sub MyPix modification ??
How do you document a function (like built in functions) in VBA?
write to column A depending on which Radio button is selected.
Watch not working for action on other cells
Paste Special, Values only
Loop Macro??
calling a routine to declare variables at start of macro
Eliminating commas if they are first characters in a string
Whats the difference between usign Named Range and Cells.Find
delimited text export
Math and action via VBA
How do i use Xlstat for clustering data into segments
Find out what windows are open
Run Code Line by Line
Display Alerts
Moving text from a line to a new line based on a condition
Sumproduct troubleshooting (new to me)
REPOST: Need help with XL2007 FormatConditions, please?
Input validation using VBA
how to create a bookmark automatically in Excel?
Disable Auto Calculate w/.enablecalculation?
Third party .xla interferes with Worksheet_Change
Position a Window
Horizontal to vertical ( 1 row to 1 column )
WebBrowser Control Question
Accessing Data from an oracle database on a different server using
AdvanceFilter Problem
creating a function with a for loop
Concatenate
code to navigate IE7 runs on XP but not on Vista
Universal open
Delete row 2 cell criteria
Using Option buttons with vlookup
Can't figure out formula error
Add comment to command button
Locking Excel Sheet with Control Toolbox controls
Controls on Excel Sheets from Control Toolbox
Need help inserting formula with macro
VBA process to run in intervals in Excel
Import XPS file into Excel
Calculate the result of an array in vba
Fill a cell with abbreviated text from a list
Macro
Find SearchOrder?
Msgbox button captions
Listbox problems
repost Split fullname into First Middle and Last
Sorting rows
Concantenating Text with | and ' (vertical slash and single qoute)
vba pivot table sorting
VBA: Using a range in a formula
Modify each cell in selection
Subtract day and time w/o weekends or holidays
VBA in a webpage
macro running on timer fails to select proper sheet
help needed with Countif....
Macro to add a new row if text length is over 30
Formatting cell base on free form or standard inputs.
Call the property of a class using a variable
pass parm to another userform
Identifying last filled area ('row') of an array via VBA?
A macro locates files on one PC but not another - why?
Cell text color change event
Can this be done with VBA ?
editing .xla files
2003 Excel Windows XP to 2007 Excel Windows Vista
Changing cursor outline color of active cell
Random Range with no duplicates
Pivot Table Refresh
Disconnected Module in VB
Mouse Click to Run Macro
VBA store location as variable
Range("E8:E53").FillRight how can I make this .Value?
insert multiple cells every ### rows
change custom view when leaving a sheet
Interop over Portable excel
macro web
Two parts of the same thing
Named Ranged, help please
Calendar Issue - Out of Memery
Creating list of duplicates
How to check Operating System?
Copying with .Value
range.copy not working as expected
Programmatically copying array formulas
Label Click to open Word Document
How can I simply the following, must I keep .Select?
How do I cut/copy paste without using the clipboard?
Array declared with the Static keyword clears itself between calls
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest"). Copy.Offset(0,
character.delete doesn't work
How to replace single cell references with row names?
Re: Missing Zero
Missing Zero
Protecting & Unportecting the sheet.
Find cells containing multiple values in random order
how to run macro in double click on a particular cell
Excel shape changes in printing
import table access to excel
Listbox how to get to appear left of cell?
Tips to speed up VBA with several workbooks open.
Tiered Pricing Calculations
toolbars - button
How to disable all controls in form?
Split fullname into First Middle and Last
How to open workbooks in different Excel?
running a macro in Microsoft Project
first non blank cell
picture Format in excel
Multiple pivot tables on same sheet with common report filter
error 9 'subscript out of range' using workshhets function
Loop through expanding range
OnError - what generated the error?
pop up during calculation
Sum the first character in a range
A search tool to the wishlist
I need help again
Print time
Code error to mirror data from one table to another
Formula = problem
want to change cell background using RGB data in a worksheet
Help in printing a sorted list of customers purchases
if and help
If function in Macro
VBA Library
UserForm Prob
ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
How long to open xls ?
Excel Checkbox Help
Displaying the value of a string
automatic counting
List all macro shortcuts in Excel
Can Alt-TAB taskbar icon be changed for a Bullen FormChanger?
DOS output
Copy files to dbf files
Vlookup macro
creating pages with 1 click..
min and max in a text box
Compile Error: variable not defined
Export multiple sheets to XML
Map XML Element
Open a userform of one spread sheet with another spread sheet
change named range
Pause between sheets
Delete string if string has only one item
Subject: Grid view/spreadsheet on userform. Q for the MVP's
Running an excel sheet which uses RTD calls as a service?
Name error trying to use add-in
OLEDBConnection Properties
Is there an object property that will return the file type?
Importing Files into Excel using VBA
Setting up a formula
Vlookup
Pass workbook name to ActiveX DLL
Text box in a userform to equal a cell
How to force an application to be visible?
Userform - Return Control Clicked
Startup code and keys to break execution
Multiple versions of Excel same Computer
Sheet Add/Delete and Build Pivot Table on the Fly
annoying pop up windows
Can't get this to work
Inserting some sort of sorting tag that doesn't display as text
Sorting by Date when some dates span over several days
Creating a range that indexes in a For loop
ByRef Argument Type Mismatch
Unable to unhide hidden columns
Combo boxes go all funny!
SaveAs CSV - Pipe Delimited
Selecting all cells in a column between two cells
Copy rows based on specific criteria
Custom Range Method
Function macro
Delete VB code
IF statement Question
Sorting an indeterminable range of data
Eliminate Variant Array Elements
find multiple or by different words
Ever wondered how to work with large text imports >256 columns?
Passing values to a string
record a macro
How to appy range names to formulas which use single cells in rang
VBA ErrorBar method does not allow custom minusvalues
Macro
Request help with Arithmentic UDF
Click Anywhere Do Something - WinAPI?
How to activate InputBox Cancel Function
Need a formula: If TIME is > or < than a cell enter TEXT
Open Web page from a button on a form
Worksheet Object Protection
Problem referencing a cell using 2 variables
Same function in add-in and workbook module
Form buttons and Control Command Buttons
Insert number of rows based on cell value, and fill
Program to record where you've been?
Excel is forced to close when run a marco???
Run-time error '1004': PasteSpecial method of Range class failed
VBA: Attach a variable to a range after executing Find command
Different Results running the same macro??
Recording a macro
Count charts on Worksheet
Get outlook to start a userform in excel.
.all
Macro to password protect and allow autofilter
Changing color of a shape
how to sort a row instead of a column?
formula
Set print area for all worksheet except first two worksheets
search BuiltinDocumentProperties routine
vba: attach a variable name to a selected range
Splitting Paragraph into two columns w/limit of 256 characters
Loop thru sheets copy and then paste in other sheet
Grid view/spreadsheet on userform. Q for the MVP's
Change event for multiple rows
Macro lagging when copying columns to other sheet
Hide VB Scripts & macro from user
Export to XML when closing workbook.
Column width & Row Height changing using macro/vb
Update Excel Objects
Is there a way to make the VBA code invisible to end user?
How do you show UDF parameters while typing in formula in Excel?
OPEN EXCEL FILE ACCORDING TO CELL VALUE
MessageBox
Close almost all workbooks
Please help with simple function
Turn "spell check before sending" off in Outlook from Excel VBA
Import Data - from Excel
comparing rows
Scope of range names
Retrieving custom document properties - Excel 2007
How to name many rows by values in a column on the same sheet at o
Displaying a Graph
Generic Macro that can rows of zeroes
Embedded Word Doc not printing completely
Run Macro from a list
Sorting a table of data into one column in ascending order
How to write macro to set the chart scale min/max property?
Macro to insert formula using cell reference/text - Urgent
Put Value in a cell next to the active cell
two criteria to match
VBA question create Excel Object and run XLSTART startup excel
Vlookup funtion in Userform
Help with Application.InputBox(,,,,,8)
Language Settings Issue
Making Frames Visible (or not)
A new Semantic Power Tool for working with Multiple Excel Spreadsh
change font color by groups with VBA
Option Button Code (Highlighting Rows)
Button on a sheet
Referencing Database Fields
Subtotal data of various lengths without entering Sum(...) manuall
VSTO BeforeDoubleClick edit mode
Macro that uses a value as the range
Way to print every worksheet in a workbook except the first two
424 Error whem trying to change Visible property
UDF ...VBA Formula built ...please help
Run time error 91 when trying to add controls to a collection
message box
Error 80010108 when using FolioExportOCX from Excel 2007
4-5 digit numbers to display leading zeros totalling 6 digits
Conditionally enable/disable a custom menu
Excel 16 bit limitation
Percentile on filtered range
Watch not working
Formatting An Existing Open Spreadsheet With A COM Add-In
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004
Macros created in earlier EXCEL version, do they work in 2007?
Copy, Paste and Print Cells from a Named Range
VBA URL
Copy Tab Names from Several Sheets and Copy Last Row from Same She
separating cell values deliminated by a "/"
Recorded Macro Works, Code Doesn't
UDF help
Enable Copy and Paste Functions in a protected worksheet
Creating a graph - Screen sizes
OR statement on macro
IsEmpty function in VSTO
CAN ANY BODY PLEASE HELP
Insert Rows
sort by grand total in pivot table
Questions about opening a workbook in code
Export from VBA form to Access
Automation C++ code works for Excel 2003, not for Excel 2007
Add-in load up
Can I set Insert Options programmatically?
Remove Pivot Table Borders with Macro
Redimming 2D array to 1D while preserving the data?
compare rows
VBA & SQL
How do I Designate a number with letters?
Pop Up Message before printing
Message box to prompt for file name upon save
How to write binary data to a file
macro help
top 10
Running a For function in a For function
Macro to create PDF
lost macros
Converting Excel SS to a Web Form
Add pdf attachment to new mail
locking cells
How to alter the code to copy to the same exact cell destination?
Error 1004, pasting merged cells
Citrix and FullName
Coding to choose the previous completed cell in a column
Database Workbook
Excel formula
Copying sheets to new workbook, merged cell issue?
blank data when using macros
Identifying a uniques entity composed of two columns
OPENING SEVERAL HYPERLINKS
Control a Table in Word From Excel
different password protect for different worksheets
PROTECT MACRO IN NEW WORKBOOK
MsgBox FOR SELECTING WRONG FORMAT FILE
Compare two sheets, identify values, calculate delta - Pls help
Get values from 15 sheets in a Wbook
how to setup web service reference in excel 2007 vba?
Corrupt XIRR formula
Error filtering for unique values
How to find that Excel work book contain ActiceX control through c
copy and paste challenge
paste to word
Excel 2007 VBA and Text Boxes
How to Format the entered Numeric Values of a Excel sheet's column as Text
Re: Merging Two Sheets - VLookup?
Open other applications using code
simulate clicking OK in msgbox
InputBox - finding the input in a range
Pivot tables wont work in protected sheet?
CommandBar image remains in Clipboard after PasteFace
Explain code
VBA Project not close after file closed
Can't call a subroutine
Copy and Paste in Macro
Need help copying certain cells from current row
Issues when opening excel through access
Setting PW Before Saving?
Font size on ActiveX controls
Culture problem with Excel english version
Publishing a Range
Set default date on calendar control
Copy chart to new location
Passing a string to excel from a C app
Automate Pasting Charts from Excel to Word
Format a sorted character string
Password Protecting Sheets
Message Boxes
RE: macro
Determining what menu item called a macro
Macro Limitations
Auto Filter
selection.cells(1).value
Converting LOTS of xls to xlsm
RE: Check Boxes
how to skip printing pages in exel by cell value
Re: Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the new workbook
Insert/Embed PDF File automatically via VBA
Delete any Lables with "0%" value in pie chart
simple print loop crashes
Re: help needed. what kind of formula I need to use that I would..
how to dynamically get sheet name
Help! Excel 2007 and Excel 2003 are not compatible?
How to zoom in VBA
outlook vba
RE: Check Boxes
Help! What might happen if Excel spends a lot of time pasting?
Pasting Selected Excel Cells into a Word Doc
Multiple labels on userform 2 update
Autofill 1 column with changing data and changing range
Print area problem
Breaking a Reference Error
Slightly Urgent: Problem Resetting Chart Value Ranges
proper case using Microsoft Office Professional 2003
Using .Row help please
Need macro to drag values down to blank cells
macro to open file
copy/paste to new blank sheet according to criteria
remove blank cell from a range
UDF behaving oddly
Printing to PDF question
Copying records to another worksheet
How do I run code on startup before Excel re-calculates formulas?
Create unique 'number'
Survey Software
vlookup function in VBA code
autoupdate macro
run macro on pivot refresh
Count non-zero values in a Array
Disable or lock page field
Dcounta
Closed File Still "Working"
merging tables/columns from several of workbook into one workbook
Need Help on populating a newly inserted row
Onclick button actions
Error: "The specified module could not be found" but DLL is in place!
Where have my macro links gone?
Using HiPortfolio 3 via VBA
Delete values colored cells
random numbers but normal distribution
Pubslishing excel 2007 to MOSS with c#
mirror table depending on cell value
Enhance sub to copy cols of variable length into 1 col to snake results into other cols
redim
Immediate textbox validation question
Date sheet first used
If formula help
date list in excell with e-mail notification
Allow Edit Objects in protected sheets
Excel 2007 Pivot Table Filter/Check Box
What is wrong with this code? Screen capture and export as image?
Macro does not delete all the required rows
Runtime Type mismatch Error 13 when object not found
Try Catch errors locking Excel
Error on password protected sheet.
TextBox Color Red if Less than 50
Variable inside function range
Ron de Bruin's Copy to Worksheets
The difference between the enter key and .Calculate (perhaps Evaluate?)
removing extra spaces in excel
Automatically hide rows with 0 value....faster?
Reference to Microsoft Outlook VBA
Worksheet Event Problems
Dynamic Range for a Chart & Trendline
Sum part of range passed to UDF
macro
Want to add a user defined selection
find out if its a folder or file
Random generator using a range with range frequency
What's wrong here?
If Begins With - Not Working - Please Help
TextBox Value
stacking data
Page orientation - Upsidedown?
Placing TextBox text in cell
Copy data automatically from another workbook
Using a UDF within SUMPRODUCT
Assign xml map programmatically
Add Border to the right side (xlEdgeRight) of a large number of co
help! subscript out of range error when trying to return multiple values from function (as variant array)
saveAsPDF powerpoint from excel (Office 2007)
selecting more than one cell
PDF basics
tab indexing
Userform Combobox Excel 2003
Countif array
Initializing values in a Listbox on a Form
Library Not Registered
Cell A1 to sheet name
How to read settings from xlDialogPrint
Code help - search / copy-paste
Colors Palette ActiveX
Delete Consecutive Rows if counta(row #) is =
Sort breaks when columns are move around
Cell Selection in Macro
Filter - Just like Access
assign filter inside macro
Help with calling an Excel program in a Excel cell
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please
SUM does report correctly
Content.MSO error
CopyPicture on a Shapes range
use macro to copy formula with value and not formula without value
Clear Row
Excel Charting with Pivote Table Data
Function procedure too long
Excel 2007 Transposing Multiple Columns
Pie Chart
Sub to compile data from col A in many identical sheets
Default ID and passord using macro
protecting multiple sheets
UserForm_Initialize is not recognized??
How do I change the row/column format in a macro to beyond letters?
plotting data in separate window
Need help with a formula
COPY/PASTE to body of email the format of Excell cell
Color Cell
Collection of Ranges and Arrays
resetting a listbox after a macro
LOG FILE RECORDING USERS TIME
Vlookup and Type Mismatch
Calendar Object in Visual Basic
find a "." then
How use AutoFilter function to query the right range of excel data
Select Non Contigouos Ranges
Delete range of Worksheets
Input from ComboBox
Repeating the same routine
HELP=>VB 'File Already Open' ERROR (run-time 55)
inputbox
How can I reduce repetative code
.ShortCutText in menus in 2007
Managing list using dates!
vlookup to a table on a website
timer
Repeat
Rowsource from another workbook
Calendar question
tab colors in 2003
Getting Data from Web - where the URL is the value of the active c
find files and open db
List help
Excel2007; workbooks.count is not counting all open workbooks
Pop up
Find Macro
Error Copying File or Folder message when copying file to CD
VBA code for Chart with x and y axis
VBA Project to the Specific Computer
refresh a folder
number of lines and characters in a text file
Extract top 5 elements from table
How to followhyperlink to a folder with a minus sign in the name
last used row.
save as macro for same file name
Workbook code to Module Code
Multipage error
Data Entry for 50 Rows only
Hiding / locking access to VBA code
Formula to reference another sheet using a string in a cell
Object Variable error
RE: Example Formulas
Return to active cell after sort
Function to read text file; find string; delete same before import
Setting Cursor Active in Cell via VB Script
VLOOKUP - when source empty, get "0". Change to complete emtpy?
compile error with Mid() function
Accessing Remote registry in Excel
Locking Macros
MatchLast function
Saving data in pull down lists?
Help with this marco
One item in alt+Tab dialog per Excel Instance
Adding a counter to a variable name
Creation and property manipulation of Control Checkbox using VB
Sequential numbering for forms
Scenario Manager question
Advice needed on autocalculation
Pivot Table Drill-down click opens another Excel Doc
Extend values of a chart series
API for a user to select a folder?
with, end with
Application.ScreenUpdating
Create Named Ranges (Headers) - then using range name in formula
ADODB Problem with transferring data from Excel to Access
detect empty rows or columns
How to check sheet text for UNICODE?
Close Shell
Print Non-Contiguous Ranges From User Input on All Worksheets
Select only columns
HELP!
Multiple Criteria for CountIF
stuck at a loop
Inserting Bold text into a cell
Signing Code
Help with excel 2003 formula
Assign and clear value to unlocked cells in a protected sheet
Solver -Macro
Macro to put data below data in a and b from columns c and d
Print Macro Function
Why am I getting run-time error '3265
Copy & Paste Named Range Contents
Macro for Removing Characters
VBA and Excell – really need you help
Copy rows where cells contain red and black font.
Save As
Convert text to number
Last improvement in my project
ComboBox
multiple rows need distinct value and adjacent row
webbrowser object causes crash on sheet change
Adjustment to count cells (in range code)
Proper way to create new macro
Dynamic range generator
Problem when Combo box has linked cell as a number
Copy selected macro(s) to a different workbook
string and numeric
SetFocus back to textbox after exiting
how to open visio file by Excel VBA
Conditional Cell Lock
Creating further drop down lists after a selection from a list
compile error
How to Cancel the Protect of Excel with VB and save it with a new password again
Developing Macros
Stopping Outlook alerts from Excel when emailing
Hide non-contiguous cells
Which is more efficient?
Streamlining my code
Extracting Data out of a string
How to Expose SeriesCollection?
Can you set up an automated counter in excel...
how to test if an object is dimensioned
Macro to hide empty worksheets
Excel 2007 ActiveChart formatting erases graph
Excel4v API behaving differently in Excel2007 vs. previous version
Trying to get a macro to run when cell selection changes.
Getting text string into userform
Excel 2003 crash after install XP SP3
Transposing data into new format
Check for unnecessary Public variable declarations and duplicate Set statements
Can Hyperlinked Images Be Converted?
Really need some help - Creating a table without manually typing in1000's of cells
macro comparing two different lists
Need to know syntax of SQL.REQUEST Excel statement for SQL Server
All macros have stopped working
Command Button Caption - VBA
Chart Dynamic Range within a Set Range
Make all variable values in a Array equal to 0
LOGIN ID AND PASSWORD
Named Range Collection
In cell drop down type ahead
selection_change adding text to target
Merged Cells Question
Hiding/Unhiding Rows in a worksheet based on the value of a checkbox.
SumProduct with options
macro to make current date remain fixed
Select multiple ranges of data
Marco for printing to file/saving to file
Using combo box
Complie error: Wrong number of arguments or invalid property assi
Help with writing macro
Show all data
How do you do a range selection dialog like those many in Excel?
Remove SubTotals Confirmation
User Form Text Box - auto delete prompt text
Run time error
Expand a range
Search & Replace macro
Using - Private Sub Workbook_Open()"
Macro to copy current worksheet to pre-defined wookbook
Modules to be used for several different spreadsheets
Looking for a way to export to tilde (~) delimted text format.
Autofilter show all
Edit entry in one cell dependant on another cell
Application.Run, doesn't return to calling procedure
Assigning cell value to range variable
Saving Problem
Looping and saving pdf
Variable as subject of SET
Permission denied when adding script object (seems Excel bug)
Print Screen
Returning values from OnAction
Find & Replace
Find "386", but not "386c"
Run-time error '9' - doesn't occur when unallocated array is Watch
VLookup problem
Setting range using vlookup
Add pages to a multipage
Is there a way to auto convert a time stamps to Eastern Standard T
Saving changes to Excel file when using VSTO
slideshow
addin menu button xl2007
Macro Workbook Copy Query
copying data from one worksheet to several based on criteria
SCROLL ON CELL CHANGE
Open a .csv file, parse text and display on more than one sheet
Automatically Accept Replace Values in Text-to-Columns macro
Toggle Button
Create multiple worksheets
Is there a auto-graph generator functionality in EXCEL/VBA? Hi all,I am not sure if this could be done, but in my mind, I want the folllowing
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to
Excel 2007 - When running macros
Personal workbook
help writing a macro please!
Error Copying Range/Cell with long Text String
Populate Cells With Range Via ComboBox
update column
Frustrated with learning add command code...
Please refine this to use lowercase instead of Proper
Using Find over entire workbook
Excel macro - personal folder
Listbox Initial Values
Filters - I want to delete single addresses and leave all the dupl
filter in a filter
Assemble monthly periods between dates into a string
Copy Without Code
userform incorporates string data
VBA chart formatting
Days in a month?
Update master spreadsheet from various single spreasheets
Data sorting problem
Application.Run "[TemplateName].[ModuleName].[MacroName]
Help Needed
Apply same filter to all sheets in a workbook
VBA - Child process - Redirect STDIN handle
Update validation list based on end date
Find a Cell Value
Assign Cell "B5" Value to Macro (activation function)
Test for Folder Path. if it doesn't exist, Create it
Page X of Y in Worksheet
using Addin in C# To Change a Range of Cells
Odds need period, evens need semicolon
Open files which contains given keyword
Access Key
code to attach a macro to a newly created worksheet
Cancel an exit
launch internet explorer from excel
Finding a string of 7 numbers in cell contents
Loop throught closed workbooks and break a specifc Link in each.
How to Stop a Macro if a 'Call' macro was used
data structure help
My first year trading
Dim cells in a sheet as a range
stopping a print macro
Re: Web Query
Excell 2007 performance issue
linked worksheets
Copy problems
formula for high lighting rows
If cell in column C = "insert" then OFFSET+CONCATENATE
How to delete QueryTable in VSTO?
outlook email body formatting issues from excel vba
Sort Worksheet Records By Column
Console.Writeline output in VSTO
vacation formula
Reorder the columns in Excel
Insert New Sheet De-activates Current Sheet VBA Workaround?
Help with a nested IF statement
Can I increase the limit of of nesting levels allowed in a file?
'Run' return value
Mirror value to another cell.
Accessing VSTO Workbook Methods
Multiple selection in listbox
Go to a particular Cell -Date
Clear listbox
Listbox Scrolling
Disabling Pop Up Menu Options
formatting issue
Need VB help
current IE window using VBA
Wont keep changes
Adding row data from one Excel file, to another, when not existing
Populating IF Formula while looping - trouble with index interpret
DTPicker Date format
find and copy from a list
HELP replacing cell references in equations with $X$Y format
Help with syntax in line of code
New worksheet position
Excel VBA toggle Outlook '03 Word email editor on/off
late binding - creating worksheet object
Multiple Macros at once different output
ActiveChart, Data!R code
stuck with my code !!
Date variables and empty cells?
Mapping the macro path
Where do you learn this stuff
Lookup and copy paste
Help with Cut-Delete-Paste to other sheet
SYSDATE in Sql vba Recordset error
how to copy as I type and then lock?
Delete Row based on 2 duplicates
Clearing Variable Values in Array using For...Next
Bold Last Row
Using ADO to get data from Worksheet in Same Workbook
Using ADO to get data from Worksheet in Same Workbook
Using ADO to get data from Worksheet in Same Workbook
Linking a ComboBox
C# Form exposed to Excel does not like CalculateAll (F9)
SaveAs xltm programmatically
lookup a number based on multiple criteria
How do you copy a pivot table into a new file and have it work?
Am I missing something?
Direct data tracking
Color Count Macro discrepency
2008 East Coast US Excel User Conference
Mailmerge with excal as datasource
Move Row if cell is not null
Limit worksheet for 50 rows only
Checking for conflicts in schedule
Input Validation using VBA
Summing a dynamic range between two points
Format number to fixed decimal place
maintaining cell references
Formula error
Direction of looping through objects
Sorry off topic but what is Ctrl R in Excel?
Loan Schedule - Specific Requirements
how do i create hyperlink from range of filename
Run time Error for VBA Project,
Re : Excel Code to Reset a Shape
Can't get the If and Else statement correct
Record Macro in Excel, run macro untill last column
How to insert subform in main form in excel 2003
Re: How to inhibit save, allow save-as?
How to inhibit save, allow save-as?
Date from DTPicker
Re: Data Validation List Hide Unhide Rows
Sumif Macro
Fast record searching in array
event procedure
Maximum number of variables allowed in Excel VBA
Overflow error when using FOR loop
A simple question for anyone but me
Automation of COM objects in Excel
Replace a word with hard return code
Pivot table row labels
grouping rows
Create input box with 3 fields
Access a VBA global variable/constant from a worksheet cell
How can I verify if "Trust access to visual basic project" is chec
Multiple text in range into single column
Nag screen pop up
navigate to different link
display columns
selecting cells dynamically (range/cells...)
Determining the nth Column
launching Excel with a macro to operate on CSV data?
Opening PowerPoint shape in excel
Opening PowerPoint object in Excel
range(cells(...))-question
Offset & Select
how do i keep sort settings?
Copying set of cells with a condition
Count a column "unique value only"
Loking Cells by Date
Custom Form: Copy from one list box to another
changing a macro so it's not cell specific
Make all variable in Array = Empty each click of a Button on Userf
Macro to open up two maximized windows side-by-side?
Avoiding nested if statements?
MACRO TO GET COMPUTER ID IN CELL
a solver problem
do while, do until?
DTpicker number format
User Form
Help, can you have two arrays?
Proper way to call/pass excel.shape as a parameter?
The Developer Ribbon Tab - buttons inactive
Run Time Error 424
Update text box in real time
Pivot table filter fields
Active cell chart
Emailing multiple excel files to multiple recipients
Code to loop through the Workbook Links
"Object Library Invalid" Error occurring...why?
checking if a combiantion of values exists on a different row
Change based on date
How to include Excel charts in Outlook email *body* with VB
Creating an "F" Statement
R/T Error - Why?
A1:B(xlDown)?
sorting multiple-area selection
Eliminating non-matching cells
VBA Code return value in Excel
Sheet Protection & Password
Weighted Linear Regression
copy only value and not formula
ComboBox problem - Excel 2003
How can i set the following variant to be a Tuesday on an Excel calendar
In VBA, how do you format selected code all at once?
Problem creating a named range
email vba help with attachments
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu
how to highlight changes in my data from one block of cells toanother block of cells?
Function going wrong
Saving workbook to a website
Do Until using date
Displaying a flash screen image on start-up
handling #Div/0! errors
Running macro on a protected sheet
If Pivot Table Exists, Delete on Close
1004 Error with Range/Array
Listbox refreshing
Open Word file by Macro
Pasting stuff into new workbook
How to Export all Macros & Forms from vba project.
Excel summing question
'Uncheck button'
'Uncheck button'
error message
Formula
add new rows
Nissan Website
controlling sheet number not sheet name
Save text file with value from Excel Cell stamped with date and time
Inputbox when cancelled
Pop-up photo in worksheet
mail different files to different persons .to .cc
combo box or list box? How to do this
Re: Move Cursor Up
Function Access Keys
Command buttons visiblle if data is correct
Adding a formula to a macro
Move or copy sheet without including the code?
Auto message
HELP NEEDED: Class Modules Vs Focus/Enter Event on Combobox
VBA Code - Excel & Access
Count of email messages
xlChart returning wrong value
VBA clueless - conditional colors and shapes
Dynamic placement of multple MS Queries into 1 spreadsheet
Application defined or object defined error
Delete certain rows to "merge" pages
VSTO Excel 2003 - Action Pane
Transpose addresses to columns
Make 1 UserForm macro target different predefined cells
Split HyperLink
Select all Data on Active Sheet
Form / Field Arrays...
Date Stamp when info is updated
Super Easy - adding a button to print
e-mail range and controlling font size and style
Progress Bar in Excel using UserForm created at Run-Time
Option Button with VB code, not working
Saving Custom Menus
Getting data from Word forms into Excel
Reading/Disassembling a String of information
Can I create pivot table with just one label column?
Textbox labels at runtime
Can't select range
capturing date for a change in a row of data
Textbox labels at runtime
Macro for Formatting
Sort of range leaves range "selected"
RE: Check cells for validation list
Maximize and Protect Worksheet
autosort left to right
How to program a macro that moves my chart as I scroll through myspreadsheet.
Change all label controltiptexts in userform
Insert Row After Series
Check for NumberFormat = DateFormat
Input the filename into Excel Sheet
find
Referencing Checkbox Name
#NAME? in cell when opening a Workbook
importing another file
Set Pivot-Table Visible Items
Create range names with names in column heading
use only numbers and '/'
RE: Check cells for validation list
Find entries in one column in another
Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade?
Formula bar is hidden, how do I unhide it?
Median of all combinations
Textbox value
Get reference to a file opened in another instance of XL
compare oldvalue and new value of a cell
Slow procedure
Problem setting each parameter in an Array = Nothing
OldCell colour
Mutually Exclusive Option Boxes
Why doesn't this work?
Printing style
PLEASE HELP WITH AN SPECIAL AUTOFILL
can same data in different cells be replaced by any formula
Copy From HTML prgramme figures
Detecting the change of a certain cell
If one range changes, update the other
Excel crashes
Email with Notes
Compile Error: Procedure too large
If, then, for a long time
Sheet sub to fire after DV selection is changed
Enquiries about calculation formula
Subscript out of range error
Frame without background color (invisible)?
I hope to get many responses on this.
Comparing worksheets with non-identical rows of information
SQL ORDER BY issue
Moving Columns Macro
Data sorting to a new sheet
Macro not ending?
delete alternate column
Control button display issue
AutoIncrementing a Column like a database in Excel 2007
VBA - Modify data in selection
Creating a working program / application from an Excel sheet
radio button with VB code
excel macro to open Sharepoint list in excel and save in my folde
macro to compare few columns data of two spreadsheet
Find End of Range,
Help to code Macro to Copy fron one sheet and paste in other sheet
count formula problem
Transparent .XLA?
Cycle through all worksheets in a workbook
time box
Search for cell color, copy values in other columns
Top Property in Excel 2007 Not Working Properly