Excel Programming [Archive] - Page 13

Multiple IF functions in one?
Assigning "Counter" for Groups
Transpose Data Macro - Question #2
sheet calculation
Loop Macro
VBA: Collapse Column Groupings
renaming excel data lists
Help locating Object Libraries
stop calculation on a sheet
Using IsError
How do I set a macro to unhide a worksheet and stay on it?
Help on macro that reads a layout and opens a fixedwidth text file
absolute reference r1c1 code
Excel Add-In
Printing userform in landscape on one page only
Selective Range extraction depends on the cell outcome
VBA r1c1 absolute previous row in formula
Clearing Merged Cells
Auto Member List in Excel 2004
Set Multiple Variables
change font using conditional formatting
Web Query, not capturing data
running the same macro for different Excel workbooks
selecting data from a column with multiple conditions
ADOBO control of Access Make Table query
Filter by Colour - conditional formating
shapes "linked" to cells?
Export access table to notepad
Office 2007 Excel Macro to save Active Worksheet to HTML by name
Clean up code
Unintialized activex control
sum column with variable range in loop
2007 lost "application.filesearch"
Slow loading workbook
For Each srs in cht.seriescollection not working
Set CurrentRegion
find/delete data on different tabs
ToolBox keeps popping up whenever UserForm shows
Excel and Html linked?
Looking at this problem a bit differently
Open password protected file with macros
get ActiveCell.Address when a chart is selected
Changing Cell Color based upon value on another worksheet
Is there a FormatReverse Function?
Creating excel file, adding code to it from code, VBE window stays
VBA code adds unwanted characters
Set solver constraint not working in VB
HELP JOEL: auto populate certain userform fields from access datab
Set Range with Long Variable
ScreenUpdating
Displaying Line Number In VBA Code
Button in Spreadsheet to change text back and forth in a Cell.
Copy code that partly works
Toolbars for 2007
Hide the Name Box
MDX Statement to an SQL Server Analysis Services with ADO
Hide column if it contains text
Show Fridays date on monday
HELP: get a block of data to access by clicking a button in excel
empty buffer for new iteration
Possible? Dynamic copy/paste source AND destination?
Write data CD using Excel Macro
parameter format
Recent File List
Removing pasword-protected macro
Copy rows from other Excel-file
Macro autofills formula when a cell value is changed
Macro Test for Value
Best way to get data from Access 2003 to Excel 2003
using an Outlook template (oft) as the body
Detect String Frequency on dynamic entries
Distribution of production to different production sites
Stop code if cell C8 is selected.
Save a file on a particular location Forcefully.
Deprecated [...]
How to locate a cell with dynamic column value
Line Draw VERY Slow (lots of lines)
Unloading all open and hidden UserForms
How to detect which menu item user click on
get no pages in pdf using excel
can a questionnaire be used to produce a formed letter
excel not working
excel to word header
easy script for deleting blank columns
Simon : Another Hoax from Konterera
Defining a Range with Cells(r,c)
If then else problem
Web page Login Process:
Web page Login Process:
when hyperlink pressed can I copy and past the followed cell coten
Call Subroutine in Excel
change the command button backcolor in Excel 2007?
IF?
Workbook_Open
Use variable for a range in WITH block
Wierd Date listbox behaviour
Showing the Differences
Range to find matches to copy values
getting data from web app
Range to find matches to copy values
Countif with Named Range
VBA code to ungroup multiple groupings
Macro to hide colums with value of zero or blank
Excel - Creating Tabbed Delimited Text File - Need help with blankcell output
VBA or formulas?
CurrentArray broken in xl2003? xl2007?
formatting a variable with vba
VBA Macro to retrieve information from xml file
HELP PLEASE: Populate multiple excel rows in access at the same ti
Copy Data from Sheet 1 to Empty Cell in Sheet 2
Reformat dates
Macro to delete sheets
Excel forms - hiding a group of controls
Hide rows using VBA based on cell value
Error 1004 - Cannot change part of a merged cell.
page break automatic macro
Searching across multiple workbooks in Excel 2003
Copy code failing
I want to use the solver in a macro. Can this be done?
HELP PLEASE: getting multiple rows into access database in a new r
HELP PLEASE: getting multiple rows into access database in a new r
Copy sheet and rename
a string to an integer
Posted to wrong list
Running Macros
Help prompt
Text to date
Macro help
Excel Userform??
Array VLOOKUPs take 6 times longer than worksheet range VLOOKUPs
Special sort add-in for excel???
Array takes 6x longer to process VLOOKUP than worksheet table does
Detecting selection before click
Passing a variable from a macro in a separate workbook to the call
Reference Command Button
Macro Portability Problem
Reference Cmd Button
Re: How do I compare two excel worksheets to generate an exception re.
macro to find a value and return another value on another workbook
autocopy workbook
Query Table Performance
VBA - making an exception for certain cells
a better way to query?
RE: two cell accumulator
Autofilter of List box Rowsource
Developer Tab - Insert button
Formula to get number of days within a period excluding Fridays
macro to select a range of cells following an offset?
why does cell.replace work with byrows and not with bycolumns
RE: Search thru sheets to match cell contents then pick up data Ph
Populate sheet names in a listbox
Shape.TextEffect.HorizontalAlignment throws error
RE: Load Userform from Array using a Loop
Add-In Menu Handling
Executing English-based macros on other language versions of Excel
Help with backwards compatibility
help with workbook
With with replacing part of a string with another string
Rename file within a directory using creating date
List box: Hide Certain colums
Static Web Query
Speeding up a delete rows Macro
Pivot table automation
Cant seem to get this to work
add-in / dll import function
trying to learn... cannot figure this out, please help!
split cell on 2th and 3th space
Function tooltip helptext
personal macro won't open
Replacing "error msg" in VBa
Form Unload?
Excel 2007 changes graphic size in print preview
Hiding rows based on cell content
CommandText with string variable
User enters data in one cell, want to block entry into another cel
Row Hieght/Coulmn Width
How to use active X Control
Change paste to paste special
Formatting a cell
Excel 2003 AddIn in 2007
Simple custom function
Multipage forms
bmp from scratch
Export image from excel file to a given directory
Multipage (wizard)
split cell in number-cell and letter-cell
Lotus noter email alert
adjust zoom according to sheet
Upload Excel Workbook On SharePoint
Upload Excel Workbook On SharePoint
Multipage??
Formatting text
Macro Stops without reason
combobox.ListFillRangeTrouble in VBA
multiple qualifiers for If statements
Help replace string within another string
Sorting rows by time-zone
MsgBox in Userfrom?
email via userfrom?
Pasting formula in every nth row
Kindly Requesting Help with Excel VBA
copyfile method path not found
different formulas based on different inputs
Transpose data macro
Re: Assigning macro to a Command button
Assigning macro to a Command button
Re: Display BOLD and Colored text in outlook body
Email to include a saved signature from outlook.
Certificate gets removed from shared workbook
Display BOLD and Colored text in outlook body
Display File path as hyperlink in outlook
Lookup data in multiple tables
Copy VBA MODULE from ACCESS to EXCEL
Radio Buttons on Sheets
remove text after character
Problem in Vista
Macro to save file
conditional formatting?
Calculating time without using military time
using Excel vba to open Access query in DesignView
Marcro to copy and paste a formula
Display missing numbers from a sequence
add Rounding function to this formula
HELP: email file path as a hyperlink in outlook body
VBA mid() function
Windows Script Host in Excel VBA
Using 32 bit VBA in Excel 2007
Code Difference from 2003 to 2007
Copying data from Sheet1 which is on multiple rows for each customerto Sheet2 on single row.
Cant find VLookup property
Showing Spreadsheet creation date from a template.
Conditional Disable ActiveX button on Userform
Formula incorrecting showing 0 as result
Find a variable cell within a worksheet using a macro.
conditional formatting for wrongly entered 9 digit numbers
How to access/open address book
Can i set the subtotal by myself?
Bubblesort
Reference / Binding Addin.xlam
RE: Workbooks.Open fails in scheduled job
Counting Duplicates on two sheets
Need Help with Print Out of Userform
Compile Error?
Column, Row and Sheet tab are gone
correl covar for two dimensional table
code problem not working HELP
Conditional format
Matching with respect to another column?
Browse for folder (but with shortcuts)
Macro on a timer
disable "save" and "save as" when macros are disabled
Alternative to Application.Caller in array functions to avoid wrong results?
New PC and my code doesn't run...
Re: Workbooks.Open fails in scheduled job
Mileage Calculator by post code / zip code
clear contents of cell
VB.NET Inserted Picture Ends Up in Wrong Cell
Array code ?
Lost view of Application
Sort by header
Web page Log in Page
How to select all unlocked cells on a sheet?
code for vba excel
export value-copy to Mac excel
highlight consecutive series of four numbers vba
Searching for empty cells and changing values
error message on populating combobox
How to create a dialog box to input information to worksheet?
Additional Code for Mr. Pearsons MergeDistinct Code
protect macro
Join two functions to one column
currentregion property not working properly
VLOOKUP not working in VBA
Formula for CF
Copied Pivot Tables with same data source
Option Explicit is ignored
Speed up macro
Item Count vs Item Cost
how to verify a sheet.visible = true?
Creating Loops and counters
Converting a students grade & credit hours to current GPA
One column determins what formula to use
add ranges
HOW TO PRODUCE LIGHT {Noor(Divine Energy)} IN YOUR HEART.
Finding Smallest Date in Non Contiguous Range
Copied Pivot Tables Take Up Too Much Memory
Macro - text box - conditions
Moving data to another sheet
Error msg
How do I reset all variables without doing it one at a time?
Send mail with data & picture (Graph's)
Loading UserForm Controls (with a twist!)
Force "Enable" Macros on Userform
Macro - dialog boxes - conditions
Excel formula to convert decimals to time
MsgBox Displays Twice
Lock different ranges after inserting data
Page set up for all worksheets
TIP: persisting cell data - ie keep track
send command line to the RUN BOX
Choose box, put cell contents, update
Text within a Cell
Trouble with ActiveX Control - Combo Box
Help with Traping (I believe) a no-Find() error throuh the us of a seemingly unrelated functiom
Iteration Level
How to print numbers invariably using dots as decimal symbol?
How to print numbers with dots, regardless of locale
Conditional enabling of menu items
Numberformat
Web Demo/Trial Application
How to program print preferences
Help with Excel VBA QUOTIENT
Who clear the MS Macro sheet content?
Need help interpreting a code line
Error 1004 when cell set to a value
Sheet Row Heights
Adding spaces between ranges with save as macro
Drill Down to a Data Entry Web Form
Send Email: Once priority is changed
HELP: saving a file with specific name
works on XP but not on vista
count subfolders
Opening Notepad from Excel
previous.copy
is there a formula/macro/script that recognizes formatting?
Tweaking a Lookup Formula
Macro and Pivot tables using a CUBE as data source
Can VBA hook onto function keys???
Twips syntax to place a report date line on a graph ?
How dark is a color
Spaces in folder name and file name
Changing PivotTable Source programmatically
Follow Hyperlink strange behaviour
Macro for Auto Fill
Excel values to Website, HTML extraction back to Excel. PLEASEHelp!!!
not able to see any sheets!
Need to have a dot used as decimal symbol, regardless of locale
Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine
Loop Copy
HELP: Application.Visible issue - only hide workbook that has user
full screen
Get calling workbook path?
ADO MS Access Fields Error
R/T error 1004 - But WHY?
Sorting the sheets in a workbook ?
Code based on opening Read Only or not
VBA code to replace Past Special
Range within a Range
Excel > Outlook Calendar code works.... 1 question
Insert Word field code using VBA from Excel
Change toolbar icon in VBA
Matrix manipulation in VBA without printing out the worksheet
Special modeless "Userform" object....
Sorting Data
Take picture out from excel comment
Email a range xls files in a folder to recipients listed in worksheet
Horizontally challenged...
Hyperlink from HTML to a specific Excel Worksheet
Best way to create Excel 2007 document
Ribbon Tab
Protection occurring automatically after first cell entry
Macro to sum columns in all sheets in a workbook
populating monthly costs in excel sheets...
String variables
Fixing Excel 2003 VBA that appears broken in Excel 2007
Prompt saveas location in Word from Excel
Call Public constants from other project
Code Problem
Spreadsheet cleanup help
grouping and outliining
How to re-enable events after a VB error in Excel?
Range PasteSpecial error
Read-only, write-on-demand access to an XLA?
Custom function to find ranked subtotals
Operations on union of ranges
Find a cell that contains ?? - Log Creation and Updating
Reformat data from rows to columns
Filter dates in a listbox
Identify which List Box was used
Problem using CONTROLSOURCE... only works when sheet5 is active
Column Match function to replace
Select upto last available Row
Unexpected issue with VBA code received
Extract Name from Text
macro error when formatting columns
3 option boxes to linked cell-linked cell to be 1,2,3.
Text box not working
Importing from Web
match sheet names
HELP copy non-continous range
Change link-source on file after copy the sheet into new a newworkbook
Macro for Page Setup - Fit to one page
LIST WITH FACILITY TO ADD TO THIS
Text boxes which can float outside the Excel application!
Excel, StrConv, and an HTML Form
Arguments problem repost
question regarding unzipping a file
Log in userform
Printing Userform Part2?
Arguments problem
VBA to move WS from 1workbook to another based on critieria
Macro apply on all the file in same directory
How to detect the cell's value change?
Format as Table
Trying to use Vlookup but it wont work
Calling routines from different sheets
Application.FileDialog .Filters.Add method not working as expected
Re: Difficulty analysing Journey Planner result
PasteSpecial Values
Macro coding
Save Spreadsheet As 2 or 3 cell values
Not sure what to call this
pause vba code until user pastes values in spreadsheet
Worksheet CLOSE related macros
Show emails in listbox?!!
How to utilize "COUNTIFS" to return a count of unique values
Haw to count ";" in a string
Excel sheet names with spaces
Macro/function that keeps in a cell a given number of characters
Macro for value matching the cell
Auto-populate other cells based on dates
Auto-populate other cells based on dates
Auto-populate other cells based on dates
Sorting a list according to other list
Procedure Call
Auto-populate cells based on dates
replace last character in string
range problem
Set ws = ActiveSheet Compile error Can't find project or Library
Find distance between two postcodes
Comment Box Size = 125% Fill Picture Size
single colour system for textboxes
IS it possible to add Hyperlink to a commandbutton on a Userform
Olap SSAS Cube SQL Server2005/2008 single data point by UDF to exc
ShowWindow problem
Can I stop the change event being triggered?
Changing references in a batch of files?
How to return an array to a macro sheet
inputbox date format
Function Last Row()
template
Username generator function
row insertion before/after
Macro Debug on Pivot Table
CheckBox to tick other CheckBoxes
Copy the value in the Inputbox
Programming "Shape" objects
Color pallet
button labelling
button labelling
Switching between two charts based on check / control box
Filter data based on Cell Value - ">" Syntax required
SetFocus Issue
Active X Message on UserForm
variable declaration for more than one worsheet
Userform and Text Box Date
IS there a fix for DLL not referencing from VBA.. IF not get one p
Referencing dll from VBA ,... JPG photo metadata edit.. Picasa
Calling Subroutines from sub-routine
"Object not set"?
erasing empty spaces
Conditional Formatting in 2007
Is it possible to hide a workbook while pulling data from it
open file with macros disable
Programm Auto filter for overdue time
Help: Error when opening a password protected workbook
Possible scoping problem
Name Conflict using Ron De Bruin's RDB_Merge_Data_Browse
HELP PLEASE: Populate certain userform fields from access database
open file macros inactive
Save failing
Referencing
Organize the worksheets in numerical order
Copying a macro to use in another workbook
Conditional formating Run-time error '5'
save file using information from a cell
Page Setup on all sheets very slow
Excel IP lookup
problem building Function with worksheet name and range
Copying one work sheet to another
sorting one column, move some duplicates to bottom of sort
General approach/platform question
Query SELECT
Refresh an Access Query using VBA code in Excel
CODE in Access running excel will NOT set PrintTitleRows correctly
Sum based on value between two cells
Emailing multi messages from one excel file
Macro - Find Function not working
Command works from debug but not normally
Finding comments
Find the first non 0 cell in a column
Emailing multi messages from one excel file
Run time error 1004 file not found
How To Determine Length Of Variable-Font Text?
Copy and Save in specific way
compile error
Windows7 Default path problem
trigger outlook macro from excell.
How to access table in text box?
Find & copy values below dates
Lookup second duplicate value location.
Floating, unprintable objects in Excel???
VBA macros files mixed up
Validata a variable
ACCESS/EXCEL Cell Update Help
ACCESS/EXCEL CELL ADDRESS AUTOUPDATE
open file validation
Calculating Textboxes
Popup Calendar?
Make a Sub/Function global to ALL WorkBooks?
Assign a cell value (from another file) to a varieble
getting back a cell adress into a range variable
Parsing a text field to retrieve numeric values
How do I stop a message from appearing when deleting using VB?
Font Color in Pull Down Menu
Userform without title or border...
Macro that splits content from cell if given character is found
Dynamic Input Timer
Using Solver Thru VBA
How Do I
How to only show modules in VBE project explorer?
Mail Merge source Access Database using Excel VBA... Pls Anyone
Can "print area" cover entire page???
How to enable "Links" when copy a worksheet (with buttons on it) to anew book
Function for Date setting in specific format
looping required
Parsing a text string in Col. A to extract 2 values and return theirproduct in Col. B
Application.ScreenUpdating
Formatte issue
Need someone to look at this code line for me
How to modigy the reference in a named range?
Help with selecting all cells in a sheet -- Error 1004
Macro that delets empty cells between cells with text
download & extract information
Mail Merge source Access Database using Excel VBA
finding duplicates and deleting based on another column
countblank sintax
Append worksheet to another inside a directory
MSCOMM Control in Excel 2003 / 2007
Macro to delete "unpinned" recent files
Macro of exact cell value
comment copy
Printing a long spreadsheet on 1 page only??
Excel Macro Question
How to set PrintSetup?
Check cell value exactly
another Vlookup question
Run-time error '1004'???
My VBA Help is in Japanese!
chart series: displaying the source range
hyperlink copy paste
Trying to Learn Code to Copy Charts
Text Box Dates in Userform?
Pivot table refresh problem
ActiveChart location
MsgBox to display [hh]:mm
2 problems with copying cells to sheets in same workbook
Excel.Application is not defined error in asp.net application
Server Connection Error
Web Query Update
HELP: Populate form fields (intranet) from a workbook(network driv
vb code to clearcontents of a merged cell
Static Vlookup
autofill down until reach variable range
Simple Concatenation
AutoFilter Slow problem
Learning VBA for Excel
Drop down list using macros in a personal macros workbook
will countif work for this?
macro on share files
Re: Palindromes and repeats
GoTo problem.
Evaluate Dates then fill in slots for scheduling
ModifyCellText
Excel 2003 - Button moves along with the cell selection
get_End question
extracting chars from strings (Visual Basic)
Automatic replace of VBA code for multiple files
set cursor position after cell is populated??
Save Embedded Files
Automatic replace of VBE code for multiple files
Locking cells
Problem while copying JTable contents into Excel with line breaksincluded
Date on UserForm?
"For each w in workbooks "can't find ".dat" open excel sheets,
Windows api code pack DLL
Ribbon and toolbar, program control
assign variable to a range
Re: Palindromes and repeats
Separate Macro from Workbook
How to get Col and Row returned in an hLookup?
Combo box multi-select
Select Case syntax for multiple conditions ("and")?
Linking Formats (color) Between Cells in Diff Wsheets
How can I fill a cell with "+" based on a percent value?
Shell command ignores variable
Displaying data in a VBA User Form
Finding cells using a style
Drop downs and look up
Filter Access query results based on selected information
Macro not to check compatibility when saving this workbook
Frame captions aren't printing when the userform is printed
Web Service in Excel 2000
Copy (“A2:A26”) paste, offset one cell, do it again. Loop 256 tim
VBA Big Brother Style Procedure
Refresh Queries in Order
Help to hyperlink cells
Listbox to change value in cell
Print from multiple closed files in a folder
Taking lines from multiple files into one sheet
Dates
Trying to Hide Rows with :30
User defined functions that are array functions
Code to see if mapped drive exists
Macro not to check compatibility when saving this workbook
matching cells
RE: Forcing Macros to Run
Macro "not to check compatibility when saving this workbook"
excel 2007 add-ins -Help
Emailing rows to each different address listed.
Completion status
Make the same titles repeated in multiple sheets of a workbook
Make the changes to the Parent applicable to all copied files
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
Copying just the summarized data
Macro Help
VBA - Importing Sheets
Frequency distribution and descriptive statististics
Macro with a memory
VBA time calculation
Excle 2003 working with mainframe
sumproduct problem
Macro Help
Creative graphics
Cells not refreshing...
Chart DataLabel Placement Error
Code For Copy Copies Twice
move from column f and g to column b, if filled
Selectively Moving Data to a Summary Sheet
returning comments propery of a closed file
Code Snippet - Forms from Control Box toolbar
Combine 2 columns using VBA
How to create a logic statement that changes the formatting of a c
Excel 2003 Macros and Variables
Hiding an item in the taskbar
Compare 2 sheets
VBA function to check if a string has valid spelling
Accurately reading the contents of another spreadsheet
Setting Bar Width in a Bar Chart
MVP ngs
Title of PowerPoint linked to a 'name' in an Excel file
Name range down one cell
screen capture
How to deteremine the number of trendline in chart?
Change Regional Language setting with Code?
How do I copy Chart shee to other workbook without external refere
Make VBA Enter Formula into cell rather than calculation
Selecting Latest Invoice from a Group of Invoices
Help with selection(?)
Returning the average of two ranges with a macro
Taking the 51st Line and Multiplying by 2
Help Required
Userform, Calender, Problems with Todays Date
Split a text using VBA
Used to work now it doesnt
Insert macro in a toolbar menu
RE: insert a row in a work book A if a row is inserted in Workbook B
Userform question
Test for text boxes
Splash screen properties
Restrict AddIn to limited users
Copy work sheet to another work book, pros and cons
What is the best way to distribute the logo's for an Excel house style?
Representing numbers with K, M, G sufix using a macro
Loop through VBA Compenents in Excel via VB.Net
Macro to copy sheets to another workbook fails after about 45 copi
How can I delete all named ranges in a workbook or worksheet?
Can't pass VBComponent to Sub Procedure in VB.Net
Macro for fast deletion of rows that conatin certain data.
Form works once only
Concantenate All cells in Row left of current active cell--
Code only works in Debug mode. Why?
Creating a stand alone program
Date Stamp in Last Column in active row if any data changes in row
Name Range, Variable # of Rows, Compare data, then Keep or delete
trouble with countif
Application EnableEvents
Format even cells to the right.
select different workbook in vba?
Why Am I getting 2 different outcomes
Recurring Day
Hyperlink from webpage to specific Worksheet
Close file
Excel 2007: Copy from recordset not working properly
Copy Code and a sort problem
Counting Work Days
Copy Worksheets to New Book
Universal Code?
Sums from a cell on multiple worksheets
run multiple macros from a drop down menu
Advanced Excel--Want to click on Cell & Move to Other Tab
=AVERAGE(b7:b20) is counting fiels that are zero
Unwanted characters in a TextBox
VBA Coding Using VLookup
Exit two loops at once
How can I let a user insert a company logo without distributing the logo file?
How to send emails to recipients in EXCEL list & content in WORD
Check box counting
Help to DEBUG this line of code. Type mismatch error
HELP: display status bar on excel userforms
Macro to delete Recent Files list (except those "pinned") - Excel
macro to select option button in option group
Method ‘CurrentPage’ of object ‘Pivot ‘Failed “
HELP: insert data in new row
Applying a function to a range
Range of cells from variable number of work sheets.
MsgBox Format(3.767, "[hh]:mm")
saving cell value for use later
XML Spreadsheet and Calculation Mode
.GetOpenFilename - Filter on File Name
Enable groups on a protected sheet
Numerical Analysis
write values to WorksheetFunction.Linest
VBA v1040 - miss of CopyPicture
Range in Macro to change after rows inserted
SAVE AS
Create cell reference color coded border with square corners
Can I call an Excel VBA function from within a WebBrowser control?
Create Function based on cell value
Coding Histogram add in tool
Access Macro in a Module
How to copyConditional Formats
Pivot Tables - using .AutoShow
Excel 2007 macro recorder weirdness
Create List for ComboBoxes
Visibility of newsgroup postings
Run-time error 9 - Subscript out of range (again)
Disabling help functions with macro
Macro to Query SharePoint Site for Existing Pages Content Type
Tweaking Existing Macro That Edits Long Formula with WORKDAY?
VBA Code for bacground colors
"ColumnOverflow" Function?
Earnings based on gross commission with split levels
Quickest way to find a row number a value
Excel Interop: DateTime
variant criteria name to filter
Grouping & Outlining
Type Mismatch with 2 Variables
Finding a date
Help with counting the number of destinct items in a column
Using Excel mail-merge without Word
Create a PivotTable from a VBA array - help!
User-defined Type Issue
Calling open workbook from another workbook
Continuous page numbering when printing whole book
Chart selection changed event
Screen Updating
disable from deleting rows; folders not to delete; sheets to inser
Excel 2007 is slow when you hide columns on .xls
Single clck ---> double click
convert range of years to series
Throw Exception if Clipboard is Empty
run macro from anoter Excel session
VBA Help
Condition BLUE
Unique Value Formula
Search faster using array - But it slows down
unknown column length
[Click the star to watch this topic] BUY CHEAP TEXTBOOKS | CollegeTextbooks | Used Textbooks | Online books
Formula Problem
Validate userform textbox entry with Sheet range.
Warning of duplicates
delete cell if part of cell contains
subtotals
Code to copy data
SendKeys not sending to Cmd.exe
How to retain Userform Radio Button Memory after unload
run macro from onoter Excel session
make workbook visible
Drag and drop from a Windows Form To Excel Worksheet
Find First Emoty Celin Column
lock formulas in certain cells
3 most significant digits
Simple question?? Nested ifs on one line
How you can save fuel and the environment
lock cells with values
Macro for active cell
Re: Why the error message?
Bubble Chart
LOOKUP iterations in VBA 2007
Modify Vlookup
Eport Excel data to closed Excel Workbook
Toggle Button
Print with sevral different print area's
to speed up excel
Removing spaces is driving me nuts
Add missing numbers in a sequence
Copy a sheet and rename it
Delete Custom Document Properties?
Delete CustomDocumentPreoperties
offset rows
Multiple Criteria for worksheet
Copy Sheet Into New Workbook
write to CSV
I would like to concatenate it, or use a macro, to a line of text
Macro analyses Cell.Serches for given word,the puts text in cell a
need help concatenating, or maybe a macro would be better.
Impossible with formula BUT
How to check if the cell contains number 1 by moving down thecolumns?
Help with macro used to open files - unpredictable results!
Worksheet_FollowHyperlink does not fire if Hyperlink is invalid
Calculate totals
How to size Excel's window to fit spreadsheet data
split worksheet after empty row into separate workbooks
How to size window to fit cells (not Zoom)
matching Multiple columns in Excel.
how to set last/latest value of a line chart to a static cell?
REMOVE EMPTY LINES IN EXCEL CELL
slow macto
Administration Form with Radio Controls
writing the column names in first row, based on the sheet name
paste transpose array of variables
Problems with WorksheetFunction.Match
Tracking contribution to Excel forums and newsgroups.
Combine 2 worksheet event change codes
Starting a For Loop from the last Row and going upwards.
Code won't fill to last row in table
xlsm.zip files do not show as folders in Explorer
for next loop question
Help with file search / Dir()
Combo Box with vertical scroll bar
Macro to remove zerro
Runtime Error 13 with Worksheet.Delete
Help: Export specific data in a sheet in a new row
InputTitle and InputMessage for a column in combo box drop down
Insert column headers in Excel using C#
how to limit row input to only 1 cell
concatenate an "actionable" formula
Vista vs. XP for excel programming
vlookup on different sheet/tab based on stored variable
copy from a specific character and paste
Exporting multiple rows from access to excel, each in a new row
macro skips a command
Find and delete offset loop
Insert image from paint
Text Changes Case Automatically
Transpose macro
Dim an array from a filtered Range
GetSaveAsFilename - Filefilter Limit
Run Time Error 1004 Application-defined or object-defined error forsimple loop? Need help with what's wrong?
Constant as network drive
Insert Data into Access database from excel userform
XMLHTTP
Drag and drop from a Windows Form To Excel Workshhet
Pfd file open using shell command
Open a pdf file code modification
Filtering in a Data Table
Subtotal for same range of multiple worksheets
Turning column count into a Column Letter
Routing slip in Excel 2007
Count Rows Bug???
Losing data when saving to 2003 format
Looping Code
web urgent
Conditional Formatting
CPU usage if excel is not in the Active Window
GetDirectory
EXCEL LIST
Cutting down code
Shell still running?
button(with vb modult) appear if required only , in work sheets
excel on another computer cannot connect to DDE Server
urgent!!!!!!
workbook beforesave event
Web
Range formula copy
HELP: Application-defined or object-defined error
HELP: display specific data on seperate sheets
Send workbook using Outlook
HELP: Match values from different sheets and populate a column
variable rows to be copied
Slow PageSetup macro
Multiple Regex Patterns
Deleting duplicate rows based on 3 column match
delete random rows
Copy and paste in all closed files in a folder
15 numbers in a cell
Copy Section of One Worksheet to Multiple Worksheets
Macro to unhide a sheet Excel 2007
2 issues really
Import file to excel
Using CommandBars with Insert Menu
Joel, Need your help
xy scatter chart, macro to fill shapes
Replacing a cell value with the value from an adjacent cell.
Please Help: Whats wrong with my For loop?
Help with Averaging Numbers within Standard Deviation
Prompt for a saveas location in Word from Excel
Getting data into an array
Form shows but input not processed
Pivot Table Refresh
text box to tell form how many lines to unhide
VBA Code to highlight or bold subtotals if not a certain value
Org Chart In Excel ?
HELP: What is wrong with my For loop
Splitting a file into multiple workbooks
Help on following topic.
Range reference is not valid
send mail based on date
code to allow for daylight settings
Code to Lock and Unlock a sheet
Copying from Multiple Worksheets
macro to delete rows below the first row with duplicate data
E-Mail generation when cell value equals x
Disable Menu Items
Streaming Data
Re: Displaying a single character.
Doubleclick
Copy Range, Paste Value in New Workbook
Code Only Works on Certain Sheets Within a Workbook
referencing Sheet from UserForm code
Inserting "-" dashes into number
Application.undo runtime error '1004'
Regex exception
randomizer as study aide
Colour Picker
Formatting variable problem
problem formatting a variable
formatting a variable problem
Count of rows - discontiguous selection
Routing Slip Error in Excel 2007
AutoFilter
Help with Option Buttons and Frame
Reference is not valid
Multiply a range by -1
Split Text in a Cell (4 columns)
Before_Double_Click Event
Pivot Table dynamic range code needed
Cell Address & VLOOKUP in VBA
UserForm checkbox input to lastrow
Excel Org Chart??
Help: Autopopulate/Edit disabled fields based on data in Sheet2
HELP: autopopulate certain form fields but make them editable late
Extract ID3 Tags from Multiple MP3 Files
Org Chart tool bar greyed out??
Macro Help
Problems with switch to 2007
Macro to create report
Macro to create report
Macro to lookup information and create report
change InputTitle and InputMessage in columns from row 2 thru 1000
Macro to create report
Macro to create report
Macro to create report
Saving .xls or .csv with text qualifiers (which Access and Oracleprovide)
Evaluate Equation in VBA
Help with Columns
excel - access
Why does no one use the [A1] notation
Access
trouble with selecting ActiveSheet.Shapes.Range
Function to perform on closing an Excel Workbook
Compile Error:Expected Array
conditional formatting help
Excel macro to remind me a project is due
Question regarding what should be a simple operation.
Create labels on one sheet from active row on another sheet
Can Anyone Explain This - Worksheets Copying Issue
Select Case problem when hitting the Delete key
White space removal
automatically highlight a row when a cell in that row is selected
Copy the formatting of one cell to other cell
excel 2007 problem deleting an onsheet scrollbar
Desire ChangeEvent not triggered if ChangeEvent was column (field) insertion
Sorting alpha-numerically?
Data entry for fixed cell ranges
Concatenating two spreadsheets by a column
Excel file with macro hosting
Error in VBA code
custom validation off workbooksheet_change
Save text file as Excel 2007 with cell as filename
Powerpoint 2007 hyperlink issues
Update Autoshape's Hyperlink
Vba Code
Fetch data from multiple .csv file paste into single sheet
Option Button versus Check Box
setting up a page numbering format
Next statement to open the .xls
If Statement? Update text in one cell based on another
Problems with WorksheetFunction.Index and WorksheetFunction.Match
Restrict Pivot Tables
merge sections of multiple word docs by running a macro from excel
Syntax to pull from data *open*Word instance? (XL2007)
VBA Module Not Viewable
Autofilter by combobox selection
Cell Movement
display gridlines
Page break code - hpagebreak before value
Different Date formats in text to be recognised as date value
Clear Spreadsheet Field