View Full Version : Excel Help
- Solved: User form- Need grayed-out options (24 replies)
- Find "-n-t" in a string and skip it! (4 replies)
- Alter colour of cell text based on value of cell next to it? (5 replies)
- Solved: Selection of columns and clearing values (3 replies)
- Help programing an Excel Document (26 replies)
- prompt (2 replies)
- Data Extract from CSV File with date filter (3 replies)
- Solved: Is there a faster way to move these cells (5 replies)
- Solved: Split large data in various sheets (1 replies)
- Using option button properties (6 replies)
- Solved: Searching for multiple values within cell (9 replies)
- Accessing a macro in a locked project in another book. (1 replies)
- Delete Hidden Name Ranges (5 replies)
- Solved: Date Difference YY-MM-WW-DD-HH-MM-SS (4 replies)
- Solved: [Solved]Copying contents of textbox to clipboard (3 replies)
- Solved: Variant List (5 replies)
- Solved: Userform With Dropdown Selection (23 replies)
- Solved: Range Select from Found Cell (3 replies)
- Solved: Use Offset to return a value (6 replies)
- Solved: Force characters in text box (6 replies)
- macro - pivot table (0 replies)
- Solved: Extract Excel Files from Outlook (14 replies)
- Confusion about giving a chart a title (7 replies)
- Autofitting columns with a condition (2 replies)
- Defining constants (11 replies)
- Limiting the no of times a macro can run (3 replies)
- Cleaner VBA? - Building Array of Months (Fiscal Year) (1 replies)
- default sort behavior? (10 replies)
- Sleeper: Date Format (8 replies)
- list all excel files in a folder (1 replies)
- Solved: Re-use Automation Object Variables vs. release and re-Create (4 replies)
- Solved: Check Value of Array (20 replies)
- Creating a Master Spreadsheet (10 replies)
- Solved: Protect columnn widths (5 replies)
- CountIF (2 replies)
- Solved: Using Offset w/ rng variable (6 replies)
- code to copy the contents (8 replies)
- Using variable to define a range (8 replies)
- for....next (4 replies)
- wipe up MACRO code when WorkBooks Expire (5 replies)
- forms & multipage forms (3 replies)
- Solved: With-End With problem (9 replies)
- Solved: deleting rows again (3 replies)
- Auto SAve (2 replies)
- Copy & Paste ranges from multiple worksheets (3 replies)
- How to select & open latest time stamp workbook (1 replies)
- Formula from VBA doesn't work (8 replies)
- Option Buttons (2 replies)
- [SOLVED:] forms and modules (18 replies)
- Looping a macro to run at each change in variable (4 replies)
- Excel can't find path (2 replies)
- 2nd persistant messagebox occuring (4 replies)
- [SLEEPER:] Filldown a vlookup with no fixed start point (11 replies)
- Subscript out of range (4 replies)
- Solved: Class Modules?? (7 replies)
- Error Msg: vba code execution has been interrupted (1 replies)
- Solved: finding last row w/ (xldown) (6 replies)
- MsgBox (16 replies)
- Code in IE's Close event (5 replies)
- Pivot Table Group Months Year (1 replies)
- Solved: Extracting cell addresses from a formula (4 replies)
- Copy Data from Excel to Access, via Excel VBA (8 replies)
- formatting & updating a group textboxes (24 replies)
- Solved: Quickie- Explanation Properties/Objects (6 replies)
- Solved: Format(i, "00") works in 2003, bad in '07 (4 replies)
- Data Distribution (1 replies)
- Solved: Trigger a Macro with a hyperlink (2 replies)
- sum visible cells (10 replies)
- Solved: I can?t copy formula as text from one sheet to another. (9 replies)
- Percentages (3 replies)
- Solved: Copy column "A" to column "Q" (3 replies)
- Code Change (5 replies)
- Solved: What data type is this? (7 replies)
- Solved: Complicated calculations (9 replies)
- Solved: line continuation on formula? (11 replies)
- Row Delete (3 replies)
- formatting cell or using functions to remove text from cell A into cell B (7 replies)
- Show and Hide Label (2 replies)
- Learning VBA - is this a good starter project? (6 replies)
- Find last row, Offset (9 replies)
- Error Handler (4 replies)
- Solved: Delete same row from multiple sheets (7 replies)
- set range conditional on the numbers of rows (1 replies)
- Memory issues (#7) (27 replies)
- OptionButton madness... (5 replies)
- Solved: MisMatch error on joining two statements (2 replies)
- Problems using if-then in direct window (15 replies)
- Exit Sub w/out Error when Cancelling Routine (3 replies)
- Solved: Sum Function (6 replies)
- Solved: Calling subroutine (9 replies)
- Batch file (3 replies)
- VBA: Summing up a variable length row using ActiveCell.Formula (6 replies)
- Another one for the Experts (8 replies)
- Date Problem (2 replies)
- Solved: Importing data file into spreadsheet (1 replies)
- Open Multiple Files & Paste Data (4 replies)
- array (13 replies)
- VBA & Save File name HELP! (6 replies)
- Solved: INSERT CELL COMMENTS IN PROTECTED SHEET (6 replies)
- Function macro (2 replies)
- Non-contiguous ranges (different sheets!) (1 replies)
- Sheets Object problem (4 replies)
- Attention all Excel Experts (8 replies)
- Function to replace formulas (6 replies)
- Help appreciated (9 replies)
- inputbox help wanted (1 replies)
- Solved: IsBlank? Missing Library? (11 replies)
- Solved: Deleting Rows (11 replies)
- Solved: SumProduct vs. SUM ?? (22 replies)
- Solved: Activating a worksheet whose name is customized (3 replies)
- Left and Find Function Syntax (3 replies)
- How to copy two non-contiguous cells (11 replies)
- AD lastLogonTimestamp Is my code right? (1 replies)
- Postcode Macro - Amending (5 replies)
- Userform to change password in VBE (10 replies)
- Solved: Deleting Rows if a particular string doesnt exist in it (9 replies)
- conditonal formatting (1 replies)
- Disable Macro Security by VBA (3 replies)
- Hide Rows based several values (3 replies)
- How to skip the cell? (1 replies)
- Batch file execution (2 replies)
- Solved: Why do my URL's change after saving a workbook? (4 replies)
- Solved: UDF to emulate Weeknum() (15 replies)
- Shortcut to inserting rows (3 replies)
- How to remove everything but one sheet? (14 replies)
- unsort after sort (1 replies)
- How to search for phonetic similarities in Addresses (6 replies)
- Solved: Cell Arrangement (3 replies)
- question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)' (2 replies)
- Solved: VBA beginner exercise (9 replies)
- select case and looping problem (5 replies)
- Why does Object Browser Show Same Items Multiple Times? (13 replies)
- Solved: Shapes: Some Explanation Please (17 replies)
- Solved: Pass a workbook and worksheet name (14 replies)
- A Free ebook on Excel from MrExcel.com (2 replies)
- Solved: type mismatch on open (15 replies)
- Solved: Creating new worksheets (2 replies)
- Auto fill a form (3 replies)
- Solved: Non-Contiguous Copy PasteSpecial (10 replies)
- a list of all formula in activeworkbook (20 replies)
- Solved: Pass Variable Reference (2 replies)
- [SOLVED:] Stopwatch in Excel !!!! (2 replies)
- "Unable to get the Find property of the range class" Error (4 replies)
- Copying an entire sheet into another workbook (24 replies)
- Send Key function help (4 replies)
- Solved: Excel 2007 viewer (8 replies)
- Solved: Copy works, copy/paste doesn't... (bug?) (19 replies)
- VBA - conditional formatting on several sheets (6 replies)
- Solved: string problem (2 replies)
- Solved: Changing text in multiple cells (6 replies)
- WORKDAY function (3 replies)
- Count --> all worksheets (2 replies)
- convert a number into month (3 replies)
- Paste Special? (2 replies)
- Solved: Excel 2007 Multiplication Bug Da Capo... (4 replies)
- Delete unmatched records (7 replies)
- Shorter way of putting names to SeriesCollection (8 replies)
- Pivot Table Settings (1 replies)
- Solved: Insert Rows and Transpose (2 replies)
- Add records to table (excel) (1 replies)
- Check for active Word document (1 replies)
- Amend code - (3 replies)
- Solved: Code execution interrupted (4 replies)
- Holiday planner/tracker (1 replies)
- Solved: Multiple Pivot Tables - simultaneous field change (6 replies)
- Critical Error: Odd Behavior on This particular Line all day (1 replies)
- Need a function to convert mm to inches (20 replies)
- output to textfile (2 replies)
- Change empty cell to a character in VBA (15 replies)
- Solved: Deleting group of rows if string pattern doesnt match (12 replies)
- [SOLVED:] Prevent Delete of Certain Sheets (13 replies)
- Solved: Loops and linking to Internet Explorer Excel file (3 replies)
- Solved: How to call an action based on input (4 replies)
- Setting values to a whole range at once (4 replies)
- Excel Add ins - Free Ones (3 replies)
- Not sure how to Amend current VBA code to do one more step (2 replies)
- Solved: Close all instances of IE (4 replies)
- Excel 2007 Multiplication Bug?! (5 replies)
- Calling Word macro from Excel macro (2 replies)
- Rename Multiple files. Help wanted (6 replies)
- [SOLVED:] Excel/Word timing problem (14 replies)
- Running a macro when excel startsup (2 replies)
- Get File Extension (4 replies)
- Commenting code (4 replies)
- Returning to Excel from Paste in Word (2 replies)
- Solved: Using Object Browser: Discover New Info (11 replies)
- Disable menu options (2 replies)
- Highlight row if date is this week (14 replies)
- Pivot table macro (3 replies)
- Buggy scope of a variable (22 replies)
- Error Handling: Complete exit (3 replies)
- Solved: Assist in Converting IF-Then to Select Case (12 replies)
- Adding text to existing text (3 replies)
- Freezing two top rows (2 replies)
- Getting Weekday as String and working with dates (12 replies)
- Help with a while wend loop (2 replies)
- Closing Excel.. (6 replies)
- Userform Save with contents of TextBoxes (5 replies)
- Solved: Find "/" in string & debug.print ? (4 replies)
- copy sheets and files (2 replies)
- IF-Then-Else in VBA help needed (9 replies)
- Solved: Debugging Immediate Window Question (16 replies)
- Solved: Read string variable while ignoring case sensitiveity (15 replies)
- Seek help for value (25 replies)
- I need a menu bar in a userform (3 replies)
- Hide "track changes" option (6 replies)
- I don?t want the hide cell to be copying!! How to do it? (3 replies)
- Solved: Sum Across unknown Number of Worksheets (16 replies)
- MultiPage -how to change Page color? (2 replies)
- increase numbers by percent in a specific column (2 replies)
- Still a challenge (8 replies)
- forms-comboboxes & textboxes (4 replies)
- Workbooks.Open Does not Error if Workbook is not Present (6 replies)
- Solved: CHANGE FROM ALL UPPER CASE (10 replies)
- Solved: Writing to specific sheets on specific cells (3 replies)
- [SOLVED:] Getting Data From a Closed Workbook (16 replies)
- Countif multiple criteria (18 replies)
- Solved: ScreenUpdating Issue? (7 replies)
- Can I use if, sum, match and offset functions to do this?? (4 replies)
- Pasting some tables form Excel in Word (14 replies)
- Solved: Passing row height properties to array (3 replies)
- Solved: Temporarily Remove Conditional Formatting (13 replies)
- date of last backup (2 replies)
- Click on a cell, which one was it? (18 replies)
- Listbox columns from 2 sheets (9 replies)
- Solved: Print Multiple Worksheets Error (4 replies)
- Solved: 'Custom' data validation (10 replies)
- Import Text File to tab in sheet (2 replies)
- loading all add-ins at one stroke (4 replies)
- Using sound in excel 2007 (2 replies)
- Form not working, Cracking me up! (19 replies)
- Solved: Copy multiple Excel Sheets (12 replies)
- Edit Button images (6 replies)
- advanced graphs - plotting (0 replies)
- must activate sheet before paste? (3 replies)
- Copy and paste macro different worksheets (5 replies)
- add a numerated worksheet (7 replies)
- Solved: tooltip (9 replies)
- HTTP: Yahoo Currency Conversion (11 replies)
- "Out of memory" (7 replies)
- Cell swapping (3 replies)
- Solved: WorksheetFunction.Vlookup Different Workbook Reference (20 replies)
- Listbox problem (8 replies)
- Problem with Excel 2003 XLA (Menu) Add-In (7 replies)
- Solved: Connect Combobox to Named Range (11 replies)
- Setting values for x-axis (3 replies)
- flashing label (3 replies)
- column question (6 replies)
- Solved: Weird workbook on open (6 replies)
- Solved: Method to instruct how many times to do something? (11 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.