- Suppressing the save as message box
- problem with array function
- Save As: Overwrite exiting file w/out dialog
- VLOOKUP #N/A
- concatenating 250 cells
- Links and expired certificates
- Delete row after 120 days
- UserForm.
- Enable Marco Box
- convert text to number
- For JWS
- Excel & IE
- entering the date
- extend text
- How do I allow users to save changes to worksheet data store
- Reading Header information into a cell
- HELP!!!! I need to sum and get averages of data with varying
- can u format text in a form?
- Conditional Formatting
- Tweaking existing VBA code...
- shareing
- Creating a Pop Up Window on a worksheet
- Zipcode lookup?
- Finding the value in a cell using a userform
- Excel File Attribute Testing for
- Named Ranges
- macro prints too many copies
- Max/Min in VB using worksheet database
- Can't get correct result from two option buttons
- What is wrong with this VBA code?
- Macro
- Checking for values, then copying only cells with values to
- If - Then Statements
- Does anyone know how to use excel to calculate Cheksum
- Lock cells
- Running a macro
- create a control array
- "now" date/time
- On the Fly Formulas
- Generate form for directories?
- transfer/Copy data on a random basis with check box
- XIRR formula
- Return the Object that belongs to a CodePage
- Format Cells to Keystroke
- XY (Scatter) Chart - question regarding markerstyle/label
- filter problem ! automatically showing record count on autof
- Hours worked - Military Time - Expressed as a decimal...
- Problem file
- How to get an enter in a msgbox?
- Formatting Parts of a Sentence
- How can excel tell that 59 is 50 and 9 (I need to act on the
- Additional formulas..
- Search a database and copy content to another file
- Probably an easy one...
- one liner required
- Protect Cells
- Removing Color in Cells
- ambigous name
- Between Function?
- Is there a way to make the cursor move ...
- A macro to do this......
- Printing VBA-code
- high-lite the active cell's row when mouse cursor is in plac
- need help with VBA code
- Refer to function variable?
- Control Arrays in VBA... Anyone?
- using excel for Weekly Database Reports
- Conditional worksheet tab color????
- GOING CRAZY! - Count Functions
- IF function
- Countif
- Macros are disabled?? What Macros?
- Auto Open macro
- Application.ScreenUpdating = False
- Time Formulae
- Max characters limit in formula
- How do you update linked data to a workbook which is being v
- coloring rows based on column content
- Selecting multiple cells
- Data Update (From one workbook to another)
- Data Update (From one workbook to another)
- Formula for adding correct percentage.
- Formula for adding correct percentage.
- conditions highlight row
- Macro's for dummies
- How do I automatically run a macro every... Thanks DK!
- Before Save Event
- Disreguard this post
- Filter dates between dates
- Macro question
- analyzing data
- Probably very easy- but I'm learning excel
- VBA
- Linking Excel Cell Data With Access
- VBA and operator
- Hey VBA types. Thanks for all the Help, Sbirro Cornuto, Iva
- how to simulate mouse button press via VBA
- Subtotal function
- VERTICAL SEEK
- protect from being pirated
- Converting units
- Query
- Summing in VBA - Still Not Working!!!
- file size
- Deleting Rows
- insert vba userform into excel
- Combo Box Resetting
- How to make a line graph?
- Linear x-axis for line chart
- Extracting data from mutliple closed workbooks
- saving
- CountA Question
- Control button arrays
- Counta Followup
- Protecting
- Dates format when using "&"
- COUNTA() in VBA
- COUNTA()
- Edit Boxes added recrussively(repeat- cant be that difficult
- Communicating with other .... Thanks Dave!
- display message "opening file"
- Can I extend conditional fromatting?
- [userform troubles] can someone please help me out?
- Text String and Date Formula
- drop down boxes
- Edit excel macro programatically
- Message box or Inputbox or what?????
- Counting text and launching macro problems
- dont display errors
- Vlookup and Ip Addresses
- Using SpinControl to update date value in a form
- Data entry in two stages onto the same sheet
- Select Print area based on conditional formatting
- control arrays...
- network drives
- Pivot Table not Sorting Dates Correctly HELP!
- Scanning into Excel
- What is wrong with this VBA Function
- Possible to format Worksheet tabs?
- Using a row source for a listbox??
- DELETING NAMED CELLS IN A SELECTION
- need some help with access
- sumproduct
- Identify changes to spreadsheet since last save
- Lookup Table
- Web Query with Excel
- Change an ODBC connection on the fly?
- Quick ? on deleting rows
- Gannt & PERT charts
- Row and column labels
- vlookup
- A Gantt chart that spans 24 hrs
- Excel 97 service releases
- Go To Window pops up by itself in Excel 2000...help :-)
- DELETE FORMULES
- function updating
- Pop Up Message???
- Pasting to A1
- code seems to work differently when "call" is used!
- Identifying a cell with text using code?
- Dates not sorting Properly in Excel
- Problems with vb after running a macro
- Removing macro's once data is in place
- In-cell dropdown arrow not appearing
- Finding the auto filter button-
- Converting numbers to text
- combobox vs. listbox
- Quick macro to Name a cell
- Changing to Proper Text
- Sumproduct, unique records............. with a twist
- Trying, but to no avail
- SavAs
- Form Combobox Problem
- Calculating time
- What files required to run vba in excel?
- Restore/Disable Title Bar
- Outlook -- Compile Error
- MID Formula
- Combobox
- monthly/daily/weekly macro
- Simple formula
- API call to get List of ODBC DSNs
- vba start up
- Alter a percentage
- Amateur here, asking "How do I change this to a database for
- Detecting Printers
- hyperlinks and cells
- Alter a percentage follow up
- Array Grid Development
- Sorting Problems
- linking worksheets
- Getting System Time
- IF function for time
- Help with formula
- sum if across multiple sheets
- Excel Chart - Hover Text
- Nested IF and LOOKUP functions (edit 1)
- Do not shift focus when users click userform
- Turn off cell highlighting
- Hyper link problem in different sheets
- Printing Question?
- Ok guys - a challenge - summing from unknown worksheets
- Preventing Scientific Data Interpretation
- How can you change autofilter with VBA?
- VLOOKUP - DISPLAYS #N/A
- Concatenate with Date.
- Editing Formula daily problem
- Keeping track of the order things are entering and exiting a
- Formatting causes number loss
- Very Basic Help
- vba code to assign macros
- macro question
- editing formula
- Modifiy a very small macro.. HELP!!
- VBA to check if a worksheet exists
- Short Cut Key???
- Create a toolbar that only shows for a specific workbook.
- Conditional Format by date
- routine Formula editing
- how to stop the cursor scrolling
- Sum problem when insert new row
- selecting the entire row
- insert new row??
- VBA Help!!!
- Howdy all. How the hell do I do this!
- matching entries, a tricky one
- Calling Sub Routines
- Only recognizing when a cell value changes
- A little nuisance I'd like to do away with. Can you help?
- Another Question?
- Charts.add ???
- The ANTI-VLookup
- Multiple If Statement
- Time entry
- Stinker of a dilemma!
- Comparing two spread sheets?
- Percent question
- Simple (?) Alphabetic Listing
- Writing to a log file - Don't tell me I stumped all of you!!
- If condition...
- Copying to cell A1 - Invalid Compiler Error
- Need VBA equivalent for =FORMULA.GOTO?()
- Unhide all sheets
- Issues with Excel 2000/XP
- Remove apostrophe
- compile error
- Return Negative Value
- Referencing problem
- compare 2 spreadsheets and create 3rd unique
- Multiple IF Function