Excel Programming [Archive] - Page 30

Application.Quit
Excel Macro to auto fill a webpage (Automation Testing)
VB-How can I use a variable in a sheet reference?
Hide all autofilter dropdown arrows
Changing Cell Properties when sheet is protected
Change Zoom Value of Window with ComboBox in Custom Menu Control
Formatting a Cell or Merged Cells
Lock checkbox to cell?
Run VBA hyperlink module on open
macro to lookup value and open tab based on lookup value
goal seek is not accurate
Macro not working on different computer
Running Macros from Excel Saved as html file
How to distribute addin with a reference library checked?
OPtion Button
Office 2007 get ribbon name
Avoiding Invalid Inquery Message
using a conditional formula from a drop down list and If Statement
move data based on number of characters in a cell
resize range
Option Button Default
Convert Percent Entered as Text in Wksht to Number in VBA
Macro to fire button in external file
Like Operator Error
Fast code in 2003 = agonizingly slow code in 2007
copy conditional formatting across all cells in column
Testing under Office 07 and getting #DIV/0! and #VALUE!
Assigning number value to letters
Macro not running when a change occurs
Get info from first cell in row.
Automation of Keystrokes in Populated Cells.
Suppressing Input Box
How to Protect the sheet, if few of the columns / rows are grouped
Bypass Error Q
script to replace data in csv file
How can I filter a list with VBA?
Save Excel Workbook
How do you specify a sheet when using redirection from a webpage
Pls help on Excel 2007 SDK sample!
How to create sub-folder through specific cell value?
sorting / formula
OptionButton
ISBLANK or NOT
Sort data
Edit datasource in a query
MACROS - Copy row from sheet to sheet.
Shadow property
different formats on one sheet
Continual addition to Cell
VBA open workbook xlxs in 2003 that contains a password
changing parameter in SQL query from Excel
workbook to access
How to program a toggle control button
auto fill
Workbook numbering
protect xls workbook (Vista)
Using an array formula as a hyperlink cell reference
How to hide xls worksheet tabs (Vista)
Mapping Mulitple Elements to The Same Cell
Command buttons and Mac
double click macros
Columns Reference in VBA after inserting a new column
Macro to add row and past values on new worksheet. HLP
Inserting Row after data change
How do I reference a Range of cells in excel using variable names
Identify computer Login ID
Thousand/Decimal seperator
extracting data from a row
Converting code to function
Help needed with modifying this code
code works on some computers, but not on others
Finding a used / filled column
Finding a used / filled column
File Reference
Search Box and 13 sheets
If Then VB
Leave loop
"Sumif " across worksheets?
Selecting data with a specfic value only
Refreshing a SharePoint list in Excel
Wild card in formula
File exists, but code doesn't find it?
RE: Remove small square caused by vbCrLf
Toolbar position
Delete blank rows
Challenging - Can an existing SSIS package be run from Excel usingVBA ?!
Userform cancel problem
variant sheet name to filter
Declaring Command Bar Control
Add a ' in front of all highlighted code in VBA
Len(ZipCode)
Stop Procedure when an Error occurs in another procedure
Internet explorer
Copying data from a pivot table
Case Statements
Populate a multi-dimensional array from Ranges
Changing a value appearing in a pivot table
COM Exception when read Font.FontStyle property of Style object
import data
Uncheck AutoFormat (Pivot Tables)
Referring to last row with data in it
display userform a certain time of day?
Why activex calendar control 12 missing in Excel 2007 SP1?
Using Excel Hyperlinks to refer to a Subroutine rather than a Cell
Problem with Hiding Every Other Column - Still need Help
COPYING ONE ROW TO ANOTHER SHEET AFTER CELL INPUT
Insert row & copy formulas
If Then Else Pivot table
Print?
Return the Line Number where the Error Occured
UDF - How do I include help to the user like the built in function
Transferring date's from a calendar control to a text box on a use
copy then paste to multiple ranges
automatically get worksheet name
Hidden rows reappearinmg when macro deletes rows
Politics
Repeats Help installation
COPY DATA FROM 2 CELLS
Yes No box no working properly
Format input box
vlookup and if function
Excel NUmber format IN VC++
Macro is pulling wrong date format into Email
Date problem
PivotFilters in pivottable
Confirm SaveAs takes place.
Cosine function
Macro problem: Won't send messages
Escape Key Interrupts Code Execution in Add-In
Transpose problem
Extremely slow sheet copy
Prevent User from Changing Password
worksheet tabs
Checkbox limitations
Create formulas in conditional formatting
What are the common problems when app cannot connect to Excel?
Copy & paste formula down a column
Page setup problems in VBA
Creating custom toolbar
Duplicate Count
Customizing a toolbar icon
Remove empty rows from a range
disable workbook
Most efficient way to loop through a folder and find all the XLS f
Index/match between workbooks problem
Split an Excel file into separate files
Resetting Activex comboboxes to blank
Vlookup
Merging Files using Employe ID Number
Different colors for different sets duplicate cells
Macro or code to insert Shape (Say Smiley face) in XL?
current week, current month, current year
Userforms & worksheets
CheckBox Help
sendmail recipient
Creating a Macro that saves over a protected spreadsheet.
Adding Menus to the Ribbon
Vlookup function
assign a name to a cell using vb
find row to use
Text in a Rectangle Object
Removing unnecessary rows through macro
Minor Axis Numbers
Copy value only
Activate a workbook
If Process Exists then
Problem with Hiding Every Other Column
Checking my lottery numbers
date comparison
Advanced filter in VBA messing with my chart
XL2003: Toggling "Extend" Mode with VBA
Macro code
Automating Web Query import
Golbal Variable Failed
Do Loop or If Then
How many checkboxes can you have?
publish xl list with more than 64 columns to sharepoint
workbook name changes
Change Link in batch of workbooks
How to optimize column deletion in a large table of data
reference tab value on worksheet
Need help with a Formula
CheckBox VBA Issue
Convert number to date
Have code working but need to edit to use on multiple variable len
reference error
Print a Userform To Fit On One Page
Combobox Events to Shrink and Expand Width
How do I write a select case statement for range
Excel formula/macro integrating with font colors?
how delete old querytables?
Textbox Data IsNumeric
Search workbook for cells with white font
Protected Data>Lists - and no VBA?
Range.Delete Shift causing merged cells to unmerge
Formula to Find First Cell in a Row with Values
Any ideas?
Need help with respect to CDialog-based display of dialog in Excelthrough xll
Quick method to sort a list of strings?
Change Colors in Charts
Dsiable right click on objects
Programming to create a report from raw data
extract elements of strings
Userform Combo box to mimick Worksheet Cell validation list range.
XL2002 - SelectionChange Question...
Convert number to date
Analyst tool Pack
Setting the Colour of Individual Items within a Legend
Save this web page with value of the active cell in sheet2
Highlighting Rows and Cut to another worksheet
**Urgent help Needed** Run time error 9
Sending SMS from excel
Random Golf Foursome Generation
Random Number Generation
End If
Application trim or rtrim
multiple updates to database
Excel VBA xlcountrycode always returns 1 = US
How do I create my own functions in Microsoft Excell 2003
Referring to BeforeDoubleClick
Creating a variable of type Range
What am I doing wrong with this VBA range?
Variable not yet created in this context
Using a named range in the Worksheet_Change event
Please improve this simple implementation
Letting user have temporary scrolling authority
Need a date range
Lock from moving cells
range array
TypeName function
Pivot Chart Drill through / Hyperlink to detail report
problem with type mismatch error
Saving a spreadsheet from .Net Web Forms application under Vista
deleting characters from autofiltered cells.
RE: Pivot table - consolidation report
create mdb 2003 format by excel?
Pivot table - consolidation range
Rolling sum cell variable location input
formula
VBA Program
Any Guru can figure out how to diisplay C++ MFC CDialog-basedcontrol in Excel from Excel command?
Running a Macro
Disable Adobe save file prompt
How to sort a selection of rows?
Using datedif to format cell color
worksheet change based on target range
Deleting certain cells only
Timed Display Alert
Checking row for data
Macro: selecting ranges from list of names
Setting cell format based on format codes
Change criteria for worksheet change code.
calculated member analysis services
Reference relative to activecell
How do you Find with data in hidden columns
About Lisview control
Data from Combo Box
Change Excel hyperlinks from absolute to relative
Creating xla file to clear junk and sort reqd data
PivotTable - multiple sources
Use worksheet as database
How to find difference in cell contents visibaly looking same
Adding hours
Comparing a list of Records
Excel as a Game Design tool
Merging rows
backspace key
Microsoft Office Spell Checker
Error help
Custom Sort Routine
StructureMacro.xla PASSWORD?
Autosave
WorksheetFunction.EOMonth
Is there a way?
ActiveX component can't create object or return reference to thisobject (Error 429)
Insert a File, not a Comment, to a Cell
macro with drop doown box to to find name in 40 work books
Copy names to another sheet
Change links for batch of workbooks
Is there something wrong with this?
error trap/handler placement
LEFT and MID
VB script
unlock sim for mobile , universal unlock device, iphone 3G unlockdevice, call back device, multisim
I need to look for a number and return the column heading.
Input box
Find/Replace Specific Range Woes...
Line chart by day of week
Macro doesn't loop through sheets of books in specific folder
Get the name of current pivot field
finding date in range of dates
Format font of text in a message box
"Autofilter: Show All" causing an error
reading Comments in a closed file
Moving to other sheet basis on condition
Macro
Excel VB Editor output stack and/or intermediate window to file
Doing search in worksheet
Selection.EntireRow - Filtered
Prevent Escape on Nonmodal Userform with Progressbar
Macro to run when cell click
false VBA cues
sheets(N*).printout problem
trouble with onchange event
On save excel jumps to another worksheet. How to fix VBA code?
Log specific changes
Function to return two values
Error 400 when trying to enter reference in excel vba
Need help calculating time in VBA
Determine if a workboo has been saved
VBA for a complex If...Then Loop
Delete or adjust auto Pagebreaks
paste special macro
Finding a used / filled rows
Use reserved word to specify current worksheet name
Code for Deleting all but first row
Use reserved word to specify current worksheet name
cell formatting and format conversion
[VBA Excel 2003] How to do it in VBA?
sheet name change
Macro to run when cell changes
Macros - Automatically highlighting rows
Toggle Event - 2 Commands on 1 Button
Copy and Paste - Workbook to Workbook
Simulate click of AutoSum doesn't work in 2007
paste special
Printing Problem
"File Already Exists" MsgBox when opening Workbooks
type mismatch
paste value
Run/call a macro when value in cell A5 changes
how can I create wordart using vba/macros
Graphs not shwoing when data is grouped
Exclude date
Dates changing when opening a CSV
I don't like variants but...
Returning to same column on current line?
Calendar Function
Bug or feature?
Excelsheet as html
Replacing \r\n #13#10 to <br> in a string?
Creating and filling a word document from excel VBA
copy worksheet to array
Option buttons in two levels groups
Select one checkbox to Add a Purchase Order (PO) Number
Data Validation List
Row Count Error
Excel 11 Type library for VB.NET?
Copy / Link Textboxes between Files
Help with IF... Then... Else statement
VLOOKUP and INNER JOIN ?
Print of DataGridView on worksheet is always blank
Worksheet_Change(ByVal Target As Range) - Big Problems
varinat variables problem
Macro doesn't refresh
Required Data in cell
Test for range value
Save Cell address to activate it later in the procedure
delete rows if data is either
How to display count of records thorugh macro
Automation Error with BuiltinDocumentProperties
Pause a Macro
Re-word text
Trouble with charts in Excel 2007 - Access 2007/VBA
Convert text to all caps
Installing Addin Causes Serious Error in Excel 2002
Tanspose Error
Macro to loop through a list of items and print for each item
SQL Date as Filter
Copy worksheet from one workbook to another
Macro Find value & insert
Regular Expression Conditionals (?(if)then|else) in VBA?
Formula to Find Max in a Row and Return Column Title
Find and Replace
Select column in VB based on variable
Mulitple updates in database
Conditionally formatted ranges
code snippets
Add 10 minutes to a Date
Trouble using the Cells() function
help with error
Add names to blocks
problem to add reference in vb.net 2003
I am using OWC11 in my application. which is merging last cell
Not Sequencing
FormatCondition.Type Property in Excel 2003 vs Excel 2007
CopyFromRecordset with Filtered ADO recordset
Test for value then format!
Run time error - selecting range of cells.
Macro Modification help
Help with function
data validation list
RoundUp not working in VBA
Paste Method - Link: "" > 0
macro to eliminate format issues
Execution slow around PageBreak Code
Named ranges and pasting formulas with named references
Selecting the Current Column ?
Getting week number?
hyperlink on part of a text contained in a cell
Time stamp on cell entries
Dynamic file location macro
Command button continues to be visible!
adding formula to cell
Change Excel secuirty level
Finding empty rows
Creating text lists
VBA Form with Calendar Control - Excel 2002 to 2003 compatibility
User Defined Function not allowed in Excel Query of Access DB?
Missing Save As Add-in option
Search for multiple words
Finding empty rows
Pivot Tables: Alternative to PivotSelect?
Subtracting & counting rows
Create XML 'baseName' or 'nodeName'
Worksheets Macro
Excel Addin File Size
Recognizing Ctl or shift key in VBA
Uncheck child nodes if parent node is unchecked in treeview
comparing lists
Determining dates based on colored cells.
using formuals
Changing up to 2 of 3 vals and the 3rd val is automatically Calcul
hot get a cell value in varable
How to copy a range of cells from one sheet to another
Any luck using CopyModule?
IF Statement
returning a row number
Bar Graph in Excel 2007
Macro Security
Macros
Function to Check if Cell is Highlighted for Change in Shared Work
How do I set auto-sort for a column in a worksheet?
Conditional formatting limit to 3 Excel 2003
check format
Show checkbox checked on open
ClickMe
Application.VLookup
Excel 2007 and Named Ranges
Ribbon Button not Working with my Referenced Workbook
VLOOKUP FUNCTION
Excel 97
Copy Formula
Should an automated version of Excel close?
sum in range meeting criteria
Selective Ribbon miminise
Can VB execute VBA code?
lookup returning #N/A
Excel 2007 Adding Template Sheets and Invalid Name Error (#NAME?)
Disable right click with a difference
My Workbook is always hidden when I open it?
lookup two columns
Macro to print plus list options?
Disable selective events
Lookup not working
lookup returns zero or the wrong number
Error in loading DLL
Conditional Format Currency
Unable to populate a range with a formula
Excel vs Lotus [pop-up screen with directories]
Macro question
To change command button caption
ListBox multi select updating in database
ignoring blanks cells while importing data
How to Select Last Row of Sheet
Excel Select All Visible Merged cell then Spread Cell Data
Hide VBProject while copying Forms & Modules to another workbook
If then else if problem for DA
formatting backcolor on Forms Control Button
fill a cell with this..
Multiple (ByVal Target As Range) Cancel each other out, as written
Loging users who open a file
Microsoft Office Web Component issue
How do I do "Range(A1).text" in a XL forumla?
Problems importing data from a *.dat file
can I use an array formula to query a source data table?
Validation for Password protection?
Paste Special Macro Assistance needed
circular reference error for simple IF statement
Sum + countcolor
Custom menu created in an xla macro
I just installed Office 2007 and an Ad-In I have is not working.
Emailing Files
Copy Certain Values
Match function / returning closest value in VBA
Call Procedure with On Error Statement
Embed Mre Func
choose a range to copy paste based on data in the cells
Copy Textbox data to Textbox in Other File
Problem with selecting a column in a macro
Decreasing Validation List - Excel 2003
Using LIKE in case statement
How to accomplish?
Combo box does not respect font size
Listbox in form
Connect to iSeries
Email Voting Buttons
Range when selected goes to lowercase
Keep cell in sight as scrolling through worksheet
PASTE CLIPBOARD TO AN IMAGE FILE (.BMP,.GIF.. ect...) for excel 20
Entering data
Setting Excel cell format
Remove DateTimestamp from String
Delete Row when date in activecell doesn't meet the requierments
lookup vba
Refedit Paste
VBA to sort list automatically in alphabetical order
Macro: Finding Text Within Text
Read/Write variables to XML with VBA
Macro: Altering cells in a range
selecting current row plus the 2 above
Looping through ranges
Selecting Form buttons
Add rows via a button on a protected sheet
Indirect to a closed spreadsheet
Conditional Formatting of Cell
How I can save excel 2003 to excel 2007?
using the enter to skip colums
RE: Data transfer to/from workbooks - Excel 2003
Can VB determine location of last cell changed?
Newbie: Problem with re-using a combo-box in userform
formula ?
filling a table depending on header row name
Parsing Data
Best Way to Understand Extremely Dense Nested Ifs in Formulas
Edit a GETPIVOTDATA formula?
T^2
Day - Date problem
Marco - I need to trim/move the text from the beginning of each ce
Conditional Formatting of one cell based on another using vba
Linking an Active X Listbox to a worksheet list
qnbocqjiyg
How to change table's heads content with VBA?
Get External Data
Form Fields in Word have trailing spaces
Retain original invoice format
use vb to determine last cell changed
Barcode solution in VBA
Send email with 2 or more attachments
Deleting duplicates between sheets
Import External Data
Data form not triggering Worksheet_Change event
algorithm
filling a table based on header row name
Unprotect in a macro
filling a table based on header row name
I need a little sub routine
How to specify path when using SaveAs ?
Selecting columns to copy and paste
If data in Workbook1 and Workbook2, highlight in Workbook2
If data in Workbook1 and Workbook2 put in Workbook3
How to design?
Macro to place quotation marks before and after text in all cells
Bypass Auto_Open
Delete summary rows programmatically
Button on Userform to Stop a Macro
vba to get file extension from col A file names
Maintaing public array values in a user form
Recording Excel98 Macros
How to determine the logic of a complex task
Search ideas to by pass Bug "OnAction" with parameters XP/ XL2K SP3
Finding first value in named range referred to in data validation list
Moving files
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does
names.add limits
Indirect Accessing of Collection Items
writing strings > 255 characters to Text Box
using SQL against Excel tables
Copy row to different worksheet
Select problem
Check Box Help
If statement giving syntax error when run macro
VBA code for excel 2000 no longer works in excel 2007
Clueless about using cut and copy with offset
strSQL with CompletedDate
Data Mover
Call command for Excel Wizard
Create a pivottable from a recordset?
Compare cell value to items in string
VB coding
Unable to unassign macro from shape
Formatting columns for Lat-Long
Check active cell value without using macro
Updating a word count from a wrod file into excel
Deleting Comboboxes
Drop Down Won't Display Last Entries in List
check
Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1?
Delete rows with macro not working
Executing a macro from an add-in in Excel 2007
Copy Cell Formatting to activecell with VBA
Personal.xls macros only work in that sheet
Open second Excel file with VBA
Type Mismatch Error
Renaming sheets - Performance problem
Automating the Watch Window entries in VBA Editor
Can the Application.wait method create a pause less than a second?
Excel VBA to insert a break for 0.2 seconds then continue
Activating problem
Extract Values from PDF into Excel ?
school timetable
Nested With
Left Header in 2007
SETTING FOCUS TO A CELL IF SINGLE CLICKED
Automatic Activation of Macro when Tabbing into a cell
Deleting Cells with Duplicates
Available Printer names to be placed in a range on a sheet and Force selection based on part of Printer name
Delete cells below a certain rank
Seperate Repeating Info into One Line while deleting others
fails tospecify max Columns size in 2007, InteropServices.COMExcep
Problems with transferring data into different columns in a workbo
Macro to graph (or draw) a vertical line on the chart
Dynamic Named Cell
Discover the cell address of an attached comment?
Populate a list box with all active workbooks except the current one.
Last Cell
Pass a Function Value thru several Subs
CopyFromRecordset only returns first record
is there a way to?
Selecting Ranges to print
Solver Automation Problem
Scrollbar changing dollars
Password protect select sheets in a workbook
Conditional formatting - why doesn't this work?
Macro not finding last cell in range
Macro needed Appointment Scheduler
"&" symbol in header/footer
Copy / Paste / ESC Key ?
VBA: Adding contents of a cell to a chart as a textbox (or image,
10 seconds to open excel workbook w/macros
Macro-if condition met-copy and paste row to new sheet
HELP: Web Query Vs Need to Log in
Validate date in Excel as weekday
Updating a seperate workbook - Excel '97 VBA
Error on pastespecial
Lookup difficulties
Sorting, replacing data
Problem with working days
VBA macro to select a tab
SaveAs XLSM question
Open successive files in a directory
Close all inactive workbooks without saving
array sintax
Sorting block of rows with empty rows between it
Selective Ribbon load in 2007
How to enter a formula (cell reference) to a shape instead of text
Run Time error '1004': Application-defined or object-defined error
Excel Formulas Treated as Strings
Refers to active cell not working
sheet tab value/nav menu
Refers to active cells
Import Table / Field Code Data from Word
defined size lists
Active workbook folder name
code broken
Maximum length of SQL
Saving Workbook in a shared drive
Saving a collection to an external file
Sorting a Collection
Concatenating Loop
Select Merged Cells and Unmerge Spread Merge Data To All Cells
Removing a leading space in a numbered currency cell
copy worksheet to another workbook
sort routine puts in wrong order
How does this code know which sheet to act upon?
Date format in a listbox
NOOB: Can someone write me some code?
Use VBA to change &File Control in Worksheet Menu Bar
Assign "Get External Data" from a VSTO Add In
Automate finding every 15th record
directory structure in VBA form.
Excel cell by cell writing.
Programming Challenges!
Pivot Table Question
disable reference updating
Prevent Page Break across a Cell
Leading Zero for Long
Office 2007 SaveAs Issue
Diasable Fill function
Making a formula Work....
Remove the right most 3 characters from a string
Two Levels of Security in Database Tool. ASP Report Maker
Getting a Macro from Word to Work in Excel
What is the benifit to programming w/ Class Modules
Child pivot table's source breaking from parent pivot table
add items to a list box
Linking auto filters to pivot on another worksheet
Converting Time
Compare & align like items from 2 Roaster columns of Employees.
Excel 2007 conditional formatting - how to get cell color?
overriding the Workbook Unprotect-function
advanced filter
VBA Programming: Cut and Paste Loop between 2 sheets
Should it be Index or Offset ?
Should it be Index or Offset ?
Progam Pivot Table connection via OLE DB (vs ODBC)
CreateTextFile method - Pagebreaks in the Text file
selecting a cell
Create sheets from Autofilter output
next blank line
Open excel file error in an ASP.NET (EventID 2001)
change path to an add-in
Disappering CommandButton Doesn't
Copy Rows from master workbook & paste in other workbooks
Highlighting rows in a range where ID code does not exist in secondrange...
Workbooks.Open suppresses MsgBox Displays when Macro is run
Macro needed
Adding Input field from VBA form in an email
Automatic Cond Formatting of multiple columns based of values of 1
Excel worksheet shows reporting tool but code and underlying data notdisplayed
TEXTBOX CUT COPY PASTE
Excel 2007 Macro Programing
Recording Macros in 2007
Code to read file in reverse fast line by line
need help with a bit of proggraming
How to repeat a lookup; copy & paste from 1 worksheet to another.
Compare cell values in row for matches - support needed
Email with attachment from range
Pull Left & Right Text
Blanks in a pivot
locking cell
excel formula question
compare unsorted data across workbooks
Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")
Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")
Pivot Table in a macro only bringing in One Field
macro to compare and retrieve data
Re-size Comments Box
Macro to Clear Cells and Delete Rows
Window change event?
Filter Items from a Pivot Field
On Error Not Working...
Vista -vs- XP
Linking time values
File Save Question
Check existence of file if file name has a space in it.
Custom toolbar's name
Read Excel data from VB.net using range object - prob with 'undefi
Open Workbook Add In with 2007 & 2003, Which Changes Ribbon & Tool
Lookup
Increase date field by 1 day based on current time?
Dynamic Range & Offset code problem
copy cell a1 to 1 of 2 wrkshts depending on the value of other cel
customer tool bar
Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks
Loop error
List Filenames and Date Modified
Send xls file and enable macros
Macro or VBA Code to return Multiple Rows?
Forcing to load one file before another
Pivot table rename
I had this working a few days ago but now cannot get it to run
Extend row down by 1
Macro with column delete running very slowly
Date & Time Calculation
Using combo box to change color of tabs (xl 2003)
Emailing reports
Building the PageFields:=Array(
DDE links cause excel 2003 autosaving after each cell edit
Opening CSV File
Changing the CurrentPage items in a Pivot Table
Listbox
Grammar check
Trap a user to a cell.
How to do this with VBA
Excel Version Management
Object hyperlink
Multiple changed cells not detected
random?
Delete row if column A cell text length is not 11
Hyperlink downloads
use looping to update label
Excel Interops for 2007 & earlier versions
ColorIndex vs Color?
purifying data
Help with deleting Frames or checkboxes from a user form
Can I know what Folder I started from?
'Value_If_True' vs. 'Value_If_False'
Reusing code
macro file 'fShowTTODialog' cannot be found
Excel 2007: Print Form Control on a full page graph
Delay update of sheets
Change macro to copy variable amount of rows instead of just 1?
How to create a range in code
How to add this function to Personal Workbook
Importing multiple text files to 1 spreadsheet
Can you check a show modal property
Input Dialog Box
using a form for cut and paste
Getvalues Macro Help Needed
adding a string of data to an array
runtime error
Excel 'Arrow' Symbol - Coding Help
Help? Anyone see problem with this macro? Way to condense it?
filter two worksheets w/ the first as a controller
Infinite loop cancelling BeforeSave
Can you type macro instructions on an excel page?
Edit VBA to print Directory including file owner into Excel Spread
How can I put a "slider" onto a spreadsheet (as a way of enteringnumbers) ?
Additional Controls
How to force Excel wkbk to close
2 worksheets compare a range of data, create 3rd worksheet w/diffs
pivot table + fixed column fields
RE UDF
Can I find columns with #### in them?
Exclude hidden sheets from formatting
import multiple files larger than 65536
help with syntax for copy and pasting rows across sheets
Disable Error Checking in 2007
How can I make Excel run faster?
Analysis Toolpak - VBA add-in
Modification of the validation list when copying Worksheet
Run-time error '1004': Insert method of Range class failed
List Visible Controls in CommandBars("Worksheet Menu Bar")
Extending a selection
Enumerating SpecialCells
Replace quotes in notepad
decile function
Macros - Saving over protected worksheet using a macro.
Dialog Box
Sharing variables between the macros in 2 open excel workbooks.
populating a validation list
link filtered sheets
Macro to validate rows
Stripping down excel
Enable macros - security settings are at "enable all macros"
Automatic macro
Time limit
Running macro on Open
save excel 2007 worksheet as pdf in macro
VBA code/form missing in Excel 2007
Trying to NOT import some records in a large text file
Formatting non-contiguous cells
finding pure pageheader text???
Tick Box v Protection
Sub or Function not defined message on finding Length
UDF
display userform for 10 seconds
SAME NAME FOR ALL SHEETS
problem with offset -how to re-write line?
VBA Help Excel/Word
vlookup where sheet name=cell value
Importing from SQL as a Number instead of Text
Set Cell value form ListBox.
30 CHECK BOXES to be disabled
Hide Sheets when closing file
Compile Error sending pdf as attachment
debug keeps stopping
Help with macros to manage a list
Completly hide Quick Access Toolbar
Filter a pivot table with large number of unique items in the filterlist
Cancel Out of UserForm Return Focus
Remove All Tabs from Ribbon except Custom Tab
how do I auto number documents in excel
Replacing information from one doc to another if conditions apply
Using an input box for multiple choices has display limits
Excel Cell Formats
Disable "Cut&Paste" and "Drag&Drop"
Invalid Web Query Error
single web query without adding to defined names
Reading variable list of cells into array
Creating Forms
Update a word form from Excel - tips?
Get Name of Icon using Face ID
Rename worksheets
Complex Sum, Reqd. codes.
Assigning Macro to Form Button
i need help on a program i am writing
Use Selection.SpecialCells for cells with a particular value?
SetFocus question
If Cell2.Value = "#N/A" Then formula not working
HtmlTextWriter - export to Excel
Anyone up for what I see could be a challenge?
Programatically remove VBA Comments & Rename Functions & Routines
Stop after IF Then
Formatting problem
Text from word to be pasted in excel
Unexpected result
Accessing other applications
slightly confused - object reference
Modal or Modeless UserForm?
Re: Copy data from Closed Workbook
Phone numbers
time frame
Sendkeys
Set RowSource for ListBox
Excel - how to record a function's result despite future changes?
Applescript: get range of selection
Reformat phone to numbers
Time format
Macro - Deleting.
Excel 2007 PageBreaks Question
Question about For Each ws in Worksheets
Activate sheet in another workbook by its code name
VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS?
VBAProject (Personal.xls)
Getting #VALUE in cells with User Defined Functions
How to tell whether any cell within a Range has non-empty contents
Trying to call a macro on selection of a cell in a range
Macros failing when workbook is in shared mode
macro to delete a row based on criteria
employee scheduling
Pivot Table from Filtered Data
Line count in sheet determines paste range in another sheet
Line count in 1 sheet to determine paste range in 2nd sheet.
merging sheets to master without moving total lines
What is wrong with this code?
Loop Error Trap
before close event
Link Master Sheet/Child Sheets and updating info real-time both wa
Retrieve Center Header String
Joining data from 2 spreadsheets into 1 sheet
seeking the fastest workflow for converting bmp image into Excel orASCII table with numbers
Comparing 2 worksheets & creating a Diff worksheet. Formula not wo
Re: How change cell to another character, add comma, & continue next c
conditional formatting based on cell contents
Re: How change cell to another character, add comma, & continue nextc
All cells "occupied" during BeforeSave event
RE: VBA code to open 3D dialog window
Re: Add ROUND function to formulas
Watch folder, lookup in sheet, rename - How do I approach this inVBA.
Adding Hyperlink
Setting Range value using a single dimension array
How do I calcluate networkHOURS?
Drag and Drop in Excel 2003 with C# and VSTO
Launch MS Access DB from a button in Excel
write a macro to print to search a list and print certain workshee
navigate
Obviate need for reference to Extensibility?
validate url
PPTApp.Activate does not work consistently in PPT 2007 (with XL 20
Storing Formats of cells in Array and reapply later
Problem with text in cell
FileSystemObject does not work on SharePoint
Sorting a worksheet with weird conditions
For..Next Problem
Sorting data
ActiveX Contro
open workbook for sharing
Need a way-probably a macro for sending e-mails
Macro formula for counting rows
Application.Run and pass variables to Sub
ReferesTo
Counting numbers
Multiple XMLMaps export to single document
Turn off a filter before running a macro
Status bar showing sum and count
Excel template and default save name
constrain the no of sub procedure executions per second
Update - 4 - Re: Parsing, mid, left, trim or right to find specific word in string
Charts -- drawing arrows to points
Application.Inputbox question
What is the difference in declaring a Collection in these Procedur
is it the fault of the macros or what
conditional formatting 1004 errors
file owner properties
Macro to insert data behind a certain date.
feedback on charts advisor in excel 2007
Forms help
Data validation list drop-down values based on prior selections
permission denied error when automating explorer
Trying to insert rows in a Macro
Save Fail on Excel Close
pulling data and autofilling fields
japanises letters
combine two formula in one cell
Calculating Age (in days) with multiple date formats (including ti
turn multiple vlookups into one macro
how can i move a scanned document from word to excel
Is there anyway to find out which cell is being calculated?
Add body message to auto-email code in Outlook
Worksheet Activate event not firing
Missing Expand All
auto enable macros
macro to add row in same worksheet based on 2 fields not having a
Now Formula
Excel formula in VBA
Change cell after macro
Check box
Copy Excel chart to PPT that is already open
Excel Table of Contents
Copy and populate a worksheet when a new data line is added on ano
VB code to run a Query in Access and paste results onto an Excelworksheet
Printing Control
general formatting
function to re-calculate when cell format (colour) changes
set toggleButtons to "pressed" by default
Copy conditional format using formula to entire worksheet
Help with Filter and FilterOn
free text in combo box
Macro Protection
changing colours on chart series
Weird Macro Behavior
PasteSpecial fails
Listbox Time Formatting
Need Excel Macro
Setting all the Chart Colours in VBA and also font sizes
Macros...
Hide Rows based on value of a cell
system.Runtime.InteropServices.COMException (0x80020005): Typemism