Excel Help [Archive] - Page 48

Creating buttons is very slow
Creating Addin that will work regardles saved folder location
UserFrom if can edit
Solved: Excel Add-IN
how to optimise sumproduct function
Broken macro - can't transfer from excel to access!
Compare, Copy and Paste using VBA
Solved: LOOKUP function not Functioning!
Solved: Check if data exists, then copy
delay between codes
Solved: Updating Excel Chart
How to replace Access data from EXCEL instead of adding to it?
How can I create a Vlookup to certain columns in a closed workbook?
Applying Template to Power Slides via Excel
VBA: If Date (range) Then (do this)
Enter Formula in Cell Based on Heading in Another Cell
Solved: hiding columns
beforeclose, saving the workbook
UDF Returns circular reference...?
Please help me to write the code for this Excel-VBA problem?
A Userform to enter data on a new line
Produce charts with range containing formula
Solved: Referencing UDF from another workbook; Evaluate?
Getting Error Message in Excel 2007
making a "Formula like" userform
Solved: x dimensions array, combobox and loop...
Increment upper bound of loop
Solved: function match : error in vba
Delete Sheets
Delete Rows if Value in Column A
import large CSV file(more then 80k records) to MS Access table
Solved: Change font characteristics depending on value
Solved: Function/Sub with Parameters assigned to a Button
Receiving variables from a batch file
Split range of cells into individual numbers?
Need Help
Solved: Uhh... Corresponding number detection and copying
Solved: Counting different values
Use Find Across multiple workbooks/ multiple worksheet
Solved: Chose last of identical data from a column
[SOLVED:] UserForm help, assigning variable from option button selection
Solved: Redim Preserve
ComboBox can't typing the value ?
Solved: Delete if matching colour
Solved: Match function in Vba
[SLEEPER:] Display DownTimer in the UserForm & at the same time User should work with UserForm ?
[SLEEPER:] Even or odd week?
Creating fields
VBA help
Solved: Insert blank row below set value
[SOLVED:] Choose data for use in control limits
[SOLVED:] VB code for greater than 1 or less than -1
Using Excel type formulae in VBA Forms
Solved: Update buggy workbook links with .Activate
[SLEEPER:] Ftp Folder
advanced find and replace loop
How to Retrieve the Last Search Term from Find()
Disable comments on mouse hover
Solved: Run macro in another workbook without its name
For...Each Loop Backwards?
Solved: Conditional formatting not working unless I step into a cell
Folder referance ?
[SOLVED:] Compile error in hidden module: distMon
Using form to editing
Generate file name with date from cell (not current date)
Solved: Copy Paste in arranged manner
Solved: To check if to versions are identical
How to copy contents of text file to tab sheet of another excelsheet
Solved: Userform Commandbuttons query
Button to unhide sheets
Solved: Backing Up in a Macro
Solved: Sort multi-dim array by one value?
Automatically Insert Hyperlink When Text Is Typed In Column
Solved: Return DAY of Week based on Date
A Loop in a Loop
Numbers Directory
Search a range of columns for values?
Combo box
Excel 2007 Buttons in Print Preview Disabled
Macro code to generate Email..help
Environmental variables to get to ?My Docs? or "My Documents" location.
Dropdowns and Zoom??
pivot table and MS Queries
Solved: pivot table: sum column is incorrect
Sending mails
Solved: Creating Dynamic Validation Lists Based on A Selection from Another List
Solved: Validating Excel data entry
Solved: Need Macro to pull data from Web
Solved: Compressing files
Select or msgbox last cell edited by code?
VBA if..then comparison not working ???
Solved: Copy rows selectively
Solved: Form-Filling GUI: ComboBox problem
Solved: Trying to uninstall addin when closing file
Update Checkbox across workbooks
Create a consecutive character array?
Excel - Email Groupwise HTML
Image as Multipage Caption
Solved: sum values based upon 2 or 3 conditions
Refreshing data from multiple large workbooks
Solved: Save specific cells in Excel with a Macro
[SOLVED:] How to find the first and last row of merge Cells???
Need help to get rid of unwanted " in text output file from an excel macro
User Forms behaving strangely
Print ranges on worksheet
Macros Paste Special to another Workbook
How to write a formula with a bunch of 'IF' statements
Copy row from workbook if...
VBA Code for mail merger & Printing
Autofill not working
Charting an array as a series
Why does .address put $ in value
Why my program gets slow down after running for a while
Solved: Using IsInPlace
Solved: sort without worksheet?
Excel Chart Lists
BO reports (rep files) need to be refreshed from Excel Module
auto filter
Solved: Image to Excel
Copy Paste toggle not working
Why is this chunk of code freezing
Alpha Testers Wanted
Solved: Multiple 'On Error' commands in function doesn't work?
Solved: Worksheet freezes up
[SLEEPER:] How to automatically trigger a VBA code to respond to expected msgbox
Putting variable values in a second sheet
Solved: swicthing between formulas
vba if statement
ERROr while running a macro
problem with combobox
Solved: pb: if condition = true then go to next iteration
Solved: Excel Charts again
[SOLVED:] Help Alter Code
Enable paste
vlookup in Vba + preventing tabulations in a form field
Linked Picture; Add to Comment
Solved: Preventing N/A# in Vlookup?
Solved: vlookup non-contiguous ranges
Using VBA to copy and paste the content of multiple worksheets to a new files
Solved: Returning an array from a function
Excel File Sharing Communication Tool
getting a Macro not to call another macro ??
Copying values
Solved: Combine H and V lookup or better idea?
Solved: Run-time error '53': File Not Found
Use text from embedded object
Excel 2007 template - issue with vba macros (emailing)
Adding multiple entries to Time Sheet
Convert to PDF on Legal Size Paper
Solved: Returning data based on multiple criteria
Dynamic Form CheckBoxes Controlls
Date format
Solved: copy contents of one workbook into another
[SOLVED:] Subtotal count
Help! Excel User prompt for data input
Solved: Writing to a word file from within excel
Fix data position
Solved: 2D Arrays
Conditional Formatting with command button
Solved: Insert blank row, NOT "insert copied cells"
Solved: Check cells in an AutoFiltered Range
Solved: Copy and Paste - File to File (All files are Password Protected)
Running a User Defined Function in VBA
Solved: sumif feature needed for multiple criteria using wildcards
A reminder please, copying range from one ws to another
Shared Workbook Woes
Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell
[SLEEPER:] UserForm: Initialize a ListBox
Number of Objects Limitation in Sheet
Solved: Creating A Shortcut Key
Solved: UDF to convert long date to "mmmyy" String
Solved: VBA hide columns or rows based on certain criteria
Solved: Sub to Open workbooks, and update named ranges
Solved: PLEASE: Chart Help
Solved: Extracting only part which is within brackats
[SOLVED:] What is escape character for quotation marks?
Checkboxes and Sheet Protection
Multi Tracker Entry Help
Extracting information after B/C
Solved: sort ascending leaves blanks at the top
Row & Column Indicators
Solved: Days Difference between text box
Solved: I want to go to "File Save As" as soon as openned
How to write a VBA-Excel code to find geometric mean?
Dynamic Range over extending issue
auto print
Appends the contents to the respective columns
add extra step to macro
Solved: insert code to show progress
Problems with FileCopy and Wb(name).close
How do I keep a Custom Menu attached to a sheet?
auto fill
Solved: How do I get excel to change the colour of cells dependant on values in other cells?
speed macro using array
Solved: get the name of the selected file.
Iterating through an array, and omitting results
Help with wierd way of doing things
Solved: Combobox - Dynamic Named Range
User function to solve Polynomal equation
Solved: Trouble with Inserting Rows
Polynomal trend line
Solved: Insert a new row after finding text "total" in a cell
WorkBook Log-in Access
Look up and sum across sheets?
Change line color for new series programatically
easy vb help
Solved: Easiest way to check/uncheck all checkboxes?
Page Header: Always 1st Row of ColB of that particular page should appear
Cut Paste macro
Solved: Stop user accessing worksheet "Administartor"
Solved: clear data in data based upon a condition
Color column A if another column equals 2
Solved: Consolodating totals for duplicate rows
Check for a particular value and formatting the cell in another sheet
Help - Range Values Selection
Solved: Two arrays and one set of code
Compile Error
Solved: Double Click, Insert Character
Solved: Matching Multiple Cells
Useing a variable to control a combobox
VBA Script to open macro dialog box
Help With - For Next Loop & Possible Inclusion of If Statement
VBA script to download data from a url
Solved: How to detect multiple cell selection
Solved: Filtering issue
Solved: Function to Return Offsetted Values
Simple Question, Hopefully
Solved: Sort by two criteria
Solved: Dates Screwing up!
[SOLVED:] VBA script to copy workbook contents
Formatting issues: copy/paste & Ctr-F
Help with Find program
Solved: Check if cell begins with number
Tricky worksheet Problem....
Sub or Function not defined - switch off
Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts
Copy range in new sheet by criteria
Assign Macro Shortcut
[SLEEPER:] How to make a range reaonly or locked or non editable???
help with a message box on error
Solved: Msg box - if password is wrong
Solved: Trim the fat
Parse .txt file
Concatenate From within formula
Dynamic Scatterplot
Solved: Trim formula needed in condiational formatting
Solved: Sort specific workbook
Modify a macros
Solved: Error in Workbook Code
Store ordered list in string.