Excel Programming [Archive] - Page 40

Create mutiple mails w/ .xls attachments from one spreadsheet
updating totals to a list
Adding an input box to a custom toolbar
VBA Code and Summing Next Non-Blank Cell in Column
Links in a work book
Sort Problem!!!
SQL query
Strange problem when executing Worksheet Change code
Excel 2000 Duplicate Shortcut Keys
Help with PageSetup for printing, please?
Odd issue with an Excel worksheet using macros
Obtain Name of Function or Sub
Excel4v behaving differently in Excel2007...
Remove Shortcuts
Protect Number Format Only
Excel User Defined function calling RTD
PrintOut Problem
Qucik Access Toolbar help (Excel 2007)
Before Double Click Procedure
code fails if graph is selected
Looping a textbox
Copy and paste
Open Multiple Password Protected Workbooks with Macro
Prevent conversion to date format
Global search and replace in VBA
#Value! for a
Extract numbers from string
Formula in Chart Title via Macro
Macro To Change Column Headings
Reading a CSV file into an Excel w/b
Program to copy old weekly status sheet to new one
Loading Multiple HTML Files in same Workbook with C#
Populate Data Validation List
Variable Range, Control ToolBox ComboBox
Custom Toolbar Changes Not Portable
PowerPoint Chart Preview in VBA Userform
return item from second column from2 column combobox
How to sort buttons
LF: verify that proper file is being used.
Table already exists
Calculating Average using a Variable Range
Show all, but leave the cursor where it is
Filtered list question
General Programming question
Formula to sum non-adjacent cells
Turn +ve to -ve & vice versa.
VB compiler does not recognize VB functions.
Toggle Button in Ribbon to Hide/Show Built-in Tabs
Round in excel 97
Run-time error '1004' with ActiveWorkbook.Save
Problem with autofilters
On Error - Only executing once.
Counting data
Advance Filter
How to safe as draft email created by macro
Modify Data Validation Input Message
ChartObject.Copy very slow
ChartObject.Copy very slow
Double Click Event on Image
How to force user function to recalculate
How do I split one table in multiple tables base on condition?
How to distribute updated code of a addin to users?
copyToColumn
Pivot table calculated field in data area
Issue with Shape(text box)
The Best Property in The World....take look its.....
A tricky one... Bizarre!!!
How to make a query menu?
Find the login time of the current Windows user
String Array
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht
Can I examine an image file structure using VBA statements
Re-assigning CommandText to an existing PivotCache
program next column
Global Variables and Constants
search files for same cell
How to assign a hyperlink to a button on a form?
Not working... Why? ActiveSheet.QueryTables.Add(Connection:=ActiveCell .Offset(0,
Dependent dropdown query - hiding items selected in prior column
Saving Excel Add-In settings
Pasting Link problem
Check cell value on workbook open
reset last used row and cell
Counting number of Sundays
Tab Naming Macro problem - help needed
lastrow in formula
Combination Charts
Selecting a range relative to an active cell
unusual function needed, unusre how to/if possible
How to change font color on string/text values>
Running Excel 4.0 Macro in Excel 2007.
Date sensitive workbook.
How do I create a Macro to automatically update a graph daily?
Close Personal.xls after each macro
create shortcut but not for active workbook
Way to receive any keystrokes from COM Add-in?
WCTrendline equation
Copy VBA Module to new workbook
Any way to be notified if someone else is in the same sheet?
Copy conditional format colors to another cell
VBA code being corrupted
Copy Sheets to new Book
Delete all commandbuttons in workbook
Help to change code
User prompted date to open file
Shape Size based on Values
Loop thought contents
check box linked cell
Cell to Cell Data Transfer
CATCH-22 won't let me save the file
sheetchange date and time
Reading numbers as text
needing xla assistance
How do I force all functions within a cell or worksheet to bere-evaluated without doing it manually?
SaveAs - modify code?
Color a range with different colors
Input Box selection and file open
Automatically drop down the drop down menu
XL Charts to Word
autofilter criteria
Working with Cell Comments - VBA
Array Math in UDF
sorting merged cells
How many times this file edited
Excel sheet for ”multi emailing”???
worksheet codename direct use vs. use in a object variable
Access Add-ins
Last cell in range of formulas not equal to blank
ungroup columns in protected sheet
Colour row
Macro to prompt for password to unprotect worksheets
UNDO DELEING ROW AND POPUP WARNING MESSAGE
File won't Open
Vertical lookup conundrum
Event Macro help
Selection saved as CSV with string delimiter
Conditional Formatting and Interior.ColorIndex
Conditional Formatting and Interior.ColorIndex
Can I display a chart in a form?
How to disable "New" "open" menu items in Excel 2007
Hiding and displaying selected rows programatically
cell update doesn't run macro
Excel + Word + popup screen before entering data (mail merge)
Renaming newly added worksheets
Problem with decimals/percentages
need help passing parameters to OFFSET
Macro/VBA code help for moving data from 1 line to another thendeleting redundant lines
XlBuiltInDialog.xlDialogPatterns
Naming of wordart
Drop down selection inserts value in new cell
What can inhibit an event handler?
Sum in Pivot Table
Macro opens file and hangs in VB editor
erasing a character in the
Drop down list column width change
copy and paste
count variable in range
Create a hyperlink from data inserted into a feild
bypassing BeforeClose event?
hidden results
adding to cells
Eliminating repeats from a list
msg box to stop user if range is "" (tricky one)
Smart way to delete the first row of a huge file
Suppress File Selection Box
workbook close delay
getsaveasfilename loop... <> false and not already exists
parseing out City, State ??
log based on cell values
delete rows that don't contain text
WorkbookBeforeSave Event - check required fields before saving
Cannot select items in listbox
SUMPRODUCT ???
Lower right cell address in a selected range - Excel 2007
Using xlPaperUser
ListBoxes - Different Elements, different colours.
Number Precision
Problems passing parameters to OFFSET, probably a simple fix for theexperienced Excel programer
looping through range
Combination Charts
Making a Textbox Required Field
row number within a named range
String array to a comboBox
Delete value if found in cell.
Find latest file in folder & Open
autocomplete combo box from contextures.com
Pivot Table question.
Code seems limited by row number
HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ?
web query with Workbooks.Open("http:// .....
How to protect some specific module in VBA project?
Variable as percent
Save as web page
Need to conditionally duplicate rows
Check if Workbook Exists
ListBox
Disable UserForm 'X' Close Button
Expert help for alternative to slow workbook
Excel Calculation is faster when visible than when Visible=False?
Excel 2003 Macro to move data around worksheet
Return Value based on Day of Week
Count unique entries across multiple columns
Count unique values - Match and conditional IF
Workbook.Save that also updates XL version?
Copy data from data sheet
redim multiarray
Creating new sheet named one week newer that active sheet
Creating a list on a different worksheet/form
Column Charts
Does Excel register an IP address when it queries a website?
I need help to make a viewer files EXCEL
Does Excel register an IP address when it queries a website?
I need help to make a viewer files EXCEL
How to detect if workbook is running in Internet Explorer
copy and paste within macros
Need some syntax help, simple loop I think
OLE DB Query Using Cell Value as Variable
Using FaceId for CommandBar Icons in a commercial application
Copy/Paste values rounding problem.
Opening Excel files with VBA
Macro Issue
Help with macro. Import text file (fixed width)
VSTO Excel with Autoshapes, Connectors and Polylines on Worksheet?
SOS:why run error
Need Programming Help
pushing window to the front
Out of Memory Error 7 While assigning named range value
Select Checkbox on Web Page
Selection EntireRow Insert
Lookup data for a range of dates
Macro to Count Entries of Columns
Does Excel register an IP address when it queries a website?
401k Spreadsheets help
Change sheet name based on cell value from another sheet tab
Find & Replace Dash
Automated Process that Updates all Spreadsheets in a Folder
With all sheets?
Clearing Immediate window in VBA by code
Undo button in the context menu (right click menu)
Personal Macro Workbook
SeriesCollection Object Issue
Missing blanks
format calling cell
Hidden Userform
Autofilter tables Uniquelist
Open workbook "inactive"
For Next does not find dates?
Is there any way to collapse/expand codes in VBA editor?
Axes values changes autmatically / textbox formatting lost
in Me.lbx.MultiSelect = fmMultiSelectMulti
Information results on user form?
Interop Excel
Excel VBA Step into
html chm help file won't launch from VBA, sometimes
Count certain values in numeric array
Macro to copy a workbook and delete a specific worksheet
Excel columns: Converting numbers to letters and vice versa
Down Loading External Data From Web. VBA to Control it
Rounding
cell format text and data displayed like a number
CheckBox . . .
"For" help (I think?)
Update worksheet according to given user names.
checkBox & ListBox on ToolBar...
Installing an add in
Ensuring Selected Cell is Visible on Screen
Find reference to specific range in code
Formatting date
Screen Updating Problem
Sort Problem - dynamically set the upper bound
How to update a worksheet based on a defined named range using VB.
running exe file in web
Excel 2002 - Borders(xlInsideVertical).LineStyle=xlcontinuous notworking
Urgent help needed please
Nested grouping of hierarchical headings during/after import
HRESULT: 0x800A03EC
can i download corrective action plan for safety inspection?
Fills page number of all sheets in current workbook
copy latest price from sheet1 to sheet2 using VBA
Convert the date to day of the week.
Double Click Jump
Format Column to display leading zeros.
How can I install Excel 95 on a new Windows Vista machine ?
Formula into cells from VBA help please!
Formating problem
Simple Loop question
Datewise table view with unique count
Disable scrolling when macros disabled
Update worksheet - Based on user IDs list
Looking for a Month Name in a String
Looking for a Month Name in a String
Macro Button and Closing Excel
DisplayHeadings
Macro to populate a second column
Unable to mark the range in VB and get application error- WHY
Userform otomatic to perceive
Custom security
Can't pass a ListBox as a ListBox - must be a Variant??
ONE BIG THANK YOU TO MR. MARK IVEY
Remove the X button from a user form? Api?
useing a macro copied
2007 Excel / Powerpoint copy paste problem
IMPORT TEXT FILE WITH VB
Previously Functioning Date Interpreter Now Failing
Active X CAlender day colour
Change color of characters in a cell based of a cell reference
Including Solver Tool in a Macro
Solver to match set elements - does it work with big numbers?
Columns doesnt return expected results
A Better Way to Reorganize Data?
Programmatically check security of VB Project
Possible to pass a variable to Excel from command line/short cut?
upload control for attaching files
Save as with Default location
Check totals in range
sum every nth cell in a row
Setting Vertical Page Breaks
Auto load
Hardcode
Hidden Rows not working correctly
dll problem
How do you .DELETE a (sub-menu) Control that was clicked?
Adding date to file name when saving and over writing a existing f
Print to PDF then set Zoom.
Need to calculate the difference between different pairs of values!
Compare Col A and Col M, if Match, Copy Col N to Col E
Peak Detection Approach
Source data for pivot table to point to cell on worksheet?
Set page break criteria?
Cant get to fill using plus handle to fill serial number-WHY
VBA Open Wkbook Disabling Macros
Require specific cell entry before saving file
Copy Data from one sheet to many based on column A
Copy to designated sheet based on value in cell
Get a date to display in date format on a UserForm
Delete earlier 'Picture' version when new picture copied in
Replace "FIRSTNAME LASTNAME" with "LAST"
Declare array
Use a spreadsheet to calculate and email an alert?
Data Entry Outsourcing Services: Profitable and Reliable Advantage
ADO versus VBA
HOW TO FIND last cell from activecell?
Using VB to code sheet formulas
Data importing prob
ListBox repeat selection fails
construction estimating
VSTO install package-How to check for prerequisites and skip them
WHY EDIT-FILL-"SERIES" OPTION cannot be seen in one particular sh
Popup message when value changes
comman button on form to transfer items in listbox to a sheet
Using ActiveX combobox controls...
Cannot Select Items in ListBoxes
seriescollection(name) not working in excel 2007
Rules for element-by-element product in array multiplication
Auto-Insert
Help with a regex pattern please
Updating Worksheet Event Code Module via VBA
Formula for counting minute intervals
Limitation on .Pictures.Insert?
Save workbook problem
How do I count the number of times a particular word is used?
set color of textbox (shape) bullets
Lotus Notes Attachments
ADO Recordset Filter for alpha
Named data into macro
formatcondition,,, curious....
Deletion problem
Running Access Macro from Excel
Turning a schedule to millions
Re-entrant function
Val function with contents of a Hyperlinked cell
Counting problem
ADO
VBA Help...I need a lot
Help with Formula - Concatenate
HowDoI Convert Excel to Tab Delim txt (File to long to open in Exc
PLEASE ANY BODY CAN CORRECT MY MACRO
Help with code please
Macro Help
Cell address
VBA code to find specific data by name. Get average. Put in cell.
modify a form on the fly
Solver to match set elements - does it work with biiig numbers?
MACRO NEEDED TO MAKE SPREADSHEET PROFESSIONAL
how do I use r1c1 notation in excel? just doing "=r2c3" not work
exit cell automatically after entering data
Centering and warping text
Calling Forms by their Caption?
Object Required error on Weekly Summary sheet creation
Help on coding please
If not then
Sumproduct error
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
On Error, Message, Exit
Excel as a front end to an Access database
How to create button and associate a macro with it.
search without using sort (lookup function)
Email hyperlink that subject line will reference cell content
Copying worksheets
spreadsheet coming up read-only but only across network
worksheet?
Inserting a row
Search without sort in the sheet
RGB fill colors
Selecting Ranges using Variables
Find Data and Change A Different Column
Excel Worksheet saving of Ranges ...
Multipage for a Wizard
Last Cell
Excel 2007 and inserted images
multiple users saving to a workbook
how can I work with worksheet textboxes in VBA?
conditional merging of two columns?
ActiveX calender help
Excel 2003 vbs script problem
Inheritence in VBA?
Fill cells with pseudo-random values
Trapping making a selection from a dropdown validation list
Applicaion.Selection on Excel
Stereo - dual view
Determine instances of Excel open
ip address
Tournament tie breaker
Code for Inserting Sheet in Excel 2000 not working in 2003
For last one year trying to find out- pls help
Rearranging data
Sorting Random Data
Calender Activex Help
Code to OK DeleteSheet automatically
Why is Add-In path associated with save location
Extracting data from text file that changes daily
Determine width of entire visible area and width of labels
Unmatched Query
Application Close Event
How to loop through multi-selection listbox?
Need formula to calculate comission & bonuses
Referencing 2 cells in a macro
MsgBox or like it for with requiring user input
Need Help Modifying Code Please
Parse Data Sheet (anti-consolidate)
Excel seems to hang while running a UDF
Move to a specific column in whatever row the cursor is currently
Require specific cell entry before saving file
Help - selecting range
Macro
WordPerfect table converted into excel
Can't get correct Workbook Create date from VBA
Fill Down, Column E
Create a floating calender
Average Percentages Excluding Zero Percentages
Can I have the same variable names in multiple different "forms"inside my personal.xls?
Rund VB code on one tab while on another
combo box to be used in Macro
Error 1004 on VBA operation
CutePDF Writer and excel
BeforeClose Event
Referencing a Cell in Macro
Cursor placement within a form
Do File Open and default to the MyDocuments dialog box
Filter macro
Compile error in hidden module:frmwork
Business Days
Conditional Deleting of Subtotals
Programming personal macro workbook
Tracking lastest date of change in a row?
Copying worksheets or data to other spreadsheets
offset to column A current row
Problem with Macro Calculation
Concatenate
PIA and Frozen Panes
password to access a custom menu?
querytable connection fails in Excel 2007
Data query refresh problem with changing filenames
visual basic word scramble
Help With BeforeDoubleClick
Picking Region Data from State Information
Macro to setup Rows to Repeat at the Top
Centering picture in Excel 2007
Variable Initialization
Form variable duplication allowed in different forms in personal.xls?
Connect to intranet
Floating calender
Macro Help - Excel
Writing data to a new workbook
Automated Process that Updates Multiple Spreadsheets
Help me to change color (By VBA) of cell if value in the cellchange!!!
Help me to change color (By VBA) of cell if value in the cellchange!!!
Corrupt Excel files when saving to Win2k3 server
Sorting in Ascending Order
How to load an excel file through web link?
variable row on fill?
Excel VBA Sorting Error
File Open Dialogue Box to a Specified Location
Error with sorting
2007 Print Preview Issue when printing multiple sheets
Programmatically create button on Excel worksheet (vb.net)
Enableling a shape
How can I save charts as a jpg or gif automatically.
Export to excel via webpage: "Invalid Procedure Call or Argument"
Run-Time Error on Macro
Print Macro Problem
How to prevent overwriting of file ?
List & count unique records
Using OR and wildcard
send mail without outlook
Re: Hiding columns
PDFCreator code
Autofill variable range
Converting Numbers from a given cell to English Words (Currency)
Rename unknown sheet name in excel.
Need to print a Worksheet without selecting it
Processing arrays with the for each-next construct
Accessing individual elements of an array returned by a function
MACRO LINKING - DIFFERENT
Re: hide-unhide
Different chart sizes between Excel 2007 and previous versions
VBA Code Change
DDEInitiate locks up Excel
VBA Totaling
AutoFit Row Height with Merged Cells in the Row
insert formula
Variable not defined?
Request for design ideas moving from data entry in spreadsheet toUserForm
xlTextPrinter and Accounting format
file error
variable row...
MsgBox help
recreate a deleted LegendEntry
Macro to insert command buttons
NamedRange - Variable Sheet
RE: Macro Auto Change Cell References
Compile OverFlow Error
Re: Importing data from the web (script page)
Excel connect/import Access data using ADO and VBA?
command button to combo box
RE: A little Macro Help Please ...
Work-around for blocking of invalid certificates Excel 2007
Dynamic Print Area (ActiveSheet)
LeftHeaderPicture
Re: hide-unhide
RE: hide-unhide
Continual Executions
Pivot Chart from database and Excel sheet
Clear data and hide rows.
Using the functions "LARGE"and "SMALL" in an Excel program
which text be selects in VBA listboxs
Extracting from string
Have you ever had a file show up as having 0 bytes?
Importing data from the web (script page)
Pie Charts
Can a Macro Run Another Macro
Chinese problem with an application
Macro problem where workbook name is saved in another name and macro reference changes
Remove Forms Command Button
Filter on more than one field
Excel created in LotusScript slow
Linking worksheets
call VB code on refresh.
Finding all divisors of given number in a set
returning back to loop check condition without completing the loop
RE: One for every month
RE: One for every month
name of cell
Invalid Procedure call or Argument when Export to Excel via web pa
even
A problem with creating a workbook by VBA
Is workbook open on network drive
Error message when adding 2 columns with Macro
For Loop - If / Or
Problem opening Workbook files in Macro
Combobox question
Macro to refresh data from different files
Getting Names fron Outlook
VB Code to Convert Rows into Columns in Excel
Delete row macro
Macro code doesn't work with Button
Code to detect if add-in is available
Getting the filepath of a template
How to clear a row I have selected to copy to another worksheet
Avoid importing 65,536 rows
ODC named range question
selective copy data from table
Named Range as Chart Source
Clear Contents of all Sheets
variable available after userform
userform label.caption
How to copy data from different columns in an Excel to one column
A challenging One
can u insert several hyperlinks in the same cell?????
Activating ManualCalc for any workbook opened
Custom toolbars uninstall/re-install
Run macro in workbook from PERSONAL.XLS
Barcodes & stocktake
Select a particular cell
Recalculate formulas when active sheet switches
How do I search for a word and add text to a cell if found?
Autofilter problem
Excal, Variant and Range
Text is being added to the macro vb edior
Range of Object Worksheet failed
defining a range
Best practice for executing code
evaluate function only in Excel application
Filtering Columns
Listing properties
Run Time Error 91! What am I missing?
GetSaveAs Issue in Excel 97
Populate Bookmarkes in a Word Doc. with Excel
cant read memory crash when printing
find location of ActiveX control
Will anyone help a new user out there?
2 questions
Creating and Sharing a .xla VBA Macro
find the location of an activeX control
Textbox from 1st worksheet to textbox to other multiple sheets
Copying or deleting row based on value found in other ws
file error
Task option control
Project Time Template Needes
Marco to process data in many files
Data analysis toolPack
Create new workbook and move the Macro without reference to old wb
Unprotect Sheet with Password Included
MS Excel If statement containing AND within an OR
Rich Text box
Correlating rows on different sheets
Calculation With A Macro
dynamic range
Hiding Sheets
How do I solve the colbrooke equation by iteration in Excel?
What's wrong with this code?
VBA Pause to allow Print to start. sending fax via Outlook
Extracting the Nth element from a String
Copy text then Past Text into TextBox not working
Read Only Message for open workbook
Setting cursor location on opening
The Funky Stuff.
Move files by time/date
One for every month
How to import multiple csv files in single excel file automaticall
PivotTable - Clear all data fields
combobox value blank
Insert comment If cell content changes.
hexadecimal mathematics
Slow code
UDF expanding beyond its cell
Copy rows where entry in column A
file not found
Windows API Calls.
problem with undo and a user form
chnage pronounsaction in speech recongnition
help on windows login name, dear Chip Pearson
expiry date for passwords
Skip Read Only MsgBox with Save As
Special loop
Code to create worksheet names based on the values in the selectedrange
Capture Error 1004
macro to automatically sum a column based on another
Error in a "Kill" command
Copy Data From Excel Into a MSWord Document
How to process multiple Excel Files
if today is last day of month then, else
FORMULA OR VB
check if is last day of month then, else
Start MS Word?
Best format to export Excel Range to picture?? WMF??
Re: WrapText Property
WrapText Property
Read Only alert interference
Excel equivalent of a "this" pointer...
Application Event Question
Sort and Transpose
How to code macro with if condition?
Converting Dates
Getting Monthly Data using Split()
Macro Range Selection
Macro to change columns - monthly question
problems changing the size of my chart
Using PI in a macro
How to exit the loop?
Setting cell fill colour
SHdocVw event problem
Reportable Error in xla - Follow UP
HELP WITH FORMULA
sign a project in office 2000
How to use Index function in coding macro?
calculate time
@@@@@@@@@@@@@@@LAPTOP DATA RECOVERY@@@@@@@@@@@@@@@@@
shortening code by defining variables using an array?
JLG Copy Row
file conversion
GetOpenFilename Close
Two Open workbooks
Help Reviewing My Loop
How to use substitute function in macro?
Reportable Error in xla - Desperate
HOW TO OPEN APROTECT EXCEL FILE.
highlight duplicate rows comparing two cells
Display CountA Formula and Text String in a cell
Problem with Macro
Copying a cell value to a specific cells
Code runs to slow
problem moving columns around
Combining Fors and Ifs
Deleting a row that has a zero in column A
Updating from one list to anoter
IF sum help
If condition
Syntax problem with code
Does the folder exist?
Programatically click CommandButton
Excel Custom Box
COPY ROW
Macro to create new workbook
Manipulating Time
Screen Flashing
Curious about macro possibility
Pivot table
Selection based on partial input
What wrong with defined variable?
find name of a chart
Help on macro coding fo URL
Reference cells in a Hidden Worksheet for display in a UserForm
Merge Data From one Workbook to another
Range Objects + Names + Error 1004
Convert Time Column to Text
Limit open dialog to certain directory
Pass a variable to a different sub
Check Data Validation status via a macro
Is the array empty?
Copy from on eworkbook to another
Workbooks property
array dimensioning
Detecting a change in a cell
Do while loop
How to know if cell has name
Return cell(s) Conditional Formatting Status via a macro
Excel Macro Help
Pass a Variable from one sub to another sub
Drop Down Menu Options? Need a PRO
Close X button on Usser Form
Select First Row of Active Column
Sumif with multiple columns in sum_range
File URL Path
Filename macro and a little more?
function for looking up text
Programmatically Halt Macro and Open VB Editor
I am new to VBE. How can I create a for loop without typing it intothe code.
AutoFit Row Size with Merged Cells
creating a macro to find a cell value and return a statement in a
VBA Code needed to AUTOMATE VALIDATION selections and then PRINT EACHNAME dynamically
Userforms fill screen whatever resolution
Text with link
Include hyperlink in email message
Loop and append to different worksheets
charts source data series copying
Excel Macro works in 2000 but not in 2003 - HELP!
VBA Grouping Rectangle/Text Boxes
Offshore Data Entry Is The Only Way To Increase Your Business
How can I do this..
error in exel
EXCEL Statement help
Excel macros
#NAME? on correct formula
one combobox affecting another
Test a cell for a comment presence from within a macro form 2007
Does VBA shortcut "or" statements?
OUT OF STACK SPACE ERROR
Need formula to calculate the average number of consecutive cells
Loop to copy rows down
Splitting decimals
convert second word in range to Proper when first variable length -urgent please
select the range with the cell's position is a variable.
DECLARE VARIABLES PROBLEM
F11 Crashes Excel
Two Open Workbooks
Linked Cells and Sort Issues
RunTime error 462: Remote Server not avaliable???
Copy & Paste "Equal" Function: Adding Distance
Query SQL Server On Entry
Excel macro to open Notepad and save with Date/Time in filename
AutoFilter... not quite right
Sort blocks of data as if each block was a single record
comment or input message
Avoid saving file with code in
Printer
Seaching a Word Document from Excel Part ii
copy data from a list
how can a macro be paused for input and then resume executio
InputBox Help
Creating separate spreadsheets from a master spreadsheet
how do i set number in cell to add 1 upon opening sheet
Use count data in formula
Area Chart not refreshing/updating properly
Listbox Max Columns
Excel 2007 Oracle DB Help
Getting Picture Into Image In UserForm
Permanently enabling macros...
MACRO
sum cluster of cells based on values
Clickbox control help needed
Solver VBA - Defining Solver Options
Close Excel server after activating OLE object
insert, name and format new worksheet
Hide a Spreadsheet in an Add-in
Calender matrix in Excel
Microsoft Office 2003 Web Services Toolkit
using Excel's regression analysis to compare correlation of FX rat
receiving drag-n-drop from PivotTable field list
Border Problem
Textbox value copy from one worksheet to another worksheet
UserForm Labels not Showing Properly
sort and copy selection to other worksheet
deleting record with a range
Save as
Code to insert check mark
Hidden Cells
Works in 2000 not in 2003?
How to disable and hide ALL menu in Excel 2007?
Data checking- a better way!
Excel connectivity issue from .net application
Combox In Form
Macro Update Macro
how to allow insert hyperlink and grouping together under protecti
Application Crash Whie adding Code lines using VBA
Hiding rows only when a condition has been met
How do I invoke the "Reset" button in the VB Editior via code?
Copy from one workbook to another
Exclude Leading Blank Rows From Selection
ADO sql server password
how do i protect one cell for write but not for select?
Workbook_SheetChange event
How to Execute macro after importing external data ranges
Pivot Tables and Macros
Worksheet Tabs
Can I programmatically access the MS Office Clipboard?
How to enforce input and delete order of cells?
Dropdown list to populate sheet
Vlookup then subtotal
Delete rows if value matches
Array of Charts in Excel
Find Command
protect formulas only
Lotus Notes get all the recipients
to Ron de Bruin Please
Nested Search and Replace
combobox fraction
This is killing me
Need help adding If/Then/Else Statement
is there a "workbook.calculation" command ??
Model User Forms
Generate list of number
How to remove carriage return symbol before importing into excel
remove vba code before emailing as attachment
Textbox value - rename worksheet with
hiding pivot tables
updating macros
How to change process bar % when macro is running
Returning the IP results from a ping?
Converting pdf tables into Excel files
How to stop macro with cancel button
RemoveDuplicates not removing all duplicate entries
How do I disable "save as the new xml format for additional securi
Activate the cursor in a cell
Looping Listbox in Userform
return ADO record set from Add-In?
How do I direct a macro to a newly opened workbook
Print Selection
ActiveWorkbook.SendMail and IE - odd problem
Adding button to worksheet
Status Bar Freezing 2nd Try
Links broken when spreadsheet emailed
XML schema validation fails
Screen Updating For Status Bar
How to "step into" in the middle of a long piece of code
Macro additional information
search button on sheet (ctrl+f)
Buttons don't show
Changing a variable which is to be specified through a loop
Text Orientation in Published Worksheet
Listbox to Array
excel 2000 help
Open / Close Grouping through VBA
Loop to move #'s from one column to next
Macro - Search one book, replace with data from another
same sheet copy/paste special
Initiating Excel VBA Code From Access
use part of date in cell for save as name
help with part of my macro
Maintaining a list of unique entries in a list
Uppercase Check
replace . to / in dates
How to Pass a date from a calendar control to a field on a form
Most non built-in command bars invisible in Excel 2007...
Combo control to execute code BEFORE change - please help
Protect/hide VB code?
How to give combo box the focus
can I force formula to be applied automatically?
Excel Cell Comments
What keystrokes indents/outdents a block of code?
copy paste code not working(troubleshoot pls)
copy data in turqouise colour cells from n to a
Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables
Including ActiveX Controls in Names Range Selection
Can't perform requested operation in excel macro
Excel Footer
importing data from closed Excel workbook
Using ADO to query CSV with no unpredictable headings
Shname = Array("Sick Graph","Accident Graph")
Complicated replacement values in list issue
Please help on coding
Message box
Assigning array values to seriescollection
Custom AutoFilter to Compare Due Dates to Current Date
highlight duplicate rows comparing two cells
Extend a Range
importing data from closed workbook
How do I goto column B in the current row using VBA?
#VALUE! from Function()...Posted in Excel General Questions by mis
Issue with File Name changing in cell
How to read xml file using VBA macro
copy/paste special
vlookup STRANGE
Macro File path problem
Problem with ranges
Pause to select cell
Text Import Wizard
Adding sum to varying columns lengths
how to save *.xls in a DB in Acces
USEING IF FUNCTION TO COPY IN ANOTHER WORKBOOK
vba code on seperate excel file
Zero Division
macro to open an existing email message
Macro
Match , copy paste (using find?)
Enter NA() into All Blank Cells in Range
Range as a variable
How do I prevent an error from crashing my macro?
Printing Consecutive Number (One spreadsheet) on Each Sheet
One macro two versions
Dynamically select range
Force a File to Open in a New Excel Instance
Using ADO to insert values into CSV file
Loop thru folders
Combining sheets with variable layout
Mouse rollover pop-up message
convert multiple sheets into PDF
Execute VB code against certain open workbooks
keeping an object in view
Boolean Declaration
Copy a Cell with a macro
Tab Function for textboxes on Worksheet not UserForm
Rename Tab with Textbox on Worksheet
.find not finding formula result
Adding an alarm
Convert Input String Formula to Number
Dynamic Workbook in VBA
Identity Specification
Find empty cell and input data for other cells
Code to Follow Hyperlink to media player without a new window opening
Format particular words in a string
Macro to copy a certain a cell to a dynamic range
Automatic Sheet Naming
Automatic Sheet Naming
Saving Excel Workbook to a stream using Excel 2007 Plug-in
Error: Type mismatch
.Value 9999 not recognised
ADO Syntax proble
Excel Data to Powerpoint
Enhance sub to paste charts as well
Pivot Table from external CSV file using VBA
Help on coding?
Insert column and hide columns
Using Caller with sub-menu selection in 2007
Userform close
Excel addin - how to deploy?
VBA Continuation Lines, Best Practices Mar08
IMPORTANT!Conditionally formatting just 2 of many characters in a
Passing ranges to a subroutine
Using ADO to Excel with this Query will not work?
Rename first X number of worksheets predefined names
Stuck and need help
Opening a Workbook within VB
Error saying Control object does not have Enable property.
Macro to convert mmddyyyy format into mm/dd/yyyy format
ActiveSheet.QueryTables.Add
Disappearing Images
Display Math Equation in Userform
Help modify macro
'Composing' numbers
Paste special validation
Public Sub ProcessData()
FILE 2 SLOW
checkbox centered in cell
How to permanently activate Macros?
Copying Worksheets from one workbook to another
pick from list and automatically enter corresponding cell
extract data from Outlook
Hyperlink Underline