- Insert-Delete Rows with Formulas Error (0 replies)
- Solved: AutoFill Active Cell (13 replies)
- [SOLVED:] VBA Hiding Unused Cells (11 replies)
- Solved: VBA to Delete rows using IsError (8 replies)
- VBA Advanced Filter (4 replies)
- To open Another Excel in a different Window using code (2 replies)
- Solved: Excel formula needed for if or countif or both (3 replies)
- assign values next to the last used cell (7 replies)
- Creating a userform to perform a search function (5 replies)
- Cells Index (6 replies)
- Need VBA help - coming up with runtime error when remote users run a macro (1 replies)
- Solved: Recordset Seek method issues (0 replies)
- Solved: Select case statement problem (8 replies)
- Solved: Userform & enabling textboxes (8 replies)
- Average with vba (7 replies)
- Switch to a specific open application (6 replies)
- Change multiple worksheet names based on cell values. (9 replies)
- Solved: Macros to be disabled on the workbook (4 replies)
- Solved: Sort worksheets using a Range as the Sort Order (7 replies)
- Solved: Change Code Modules and Userforms (4 replies)
- The last date of use (3 replies)
- [SOLVED:] Insert/Delete Row Code Issue (2 replies)
- Adding zeros to numbers entered (6 replies)
- disable menu items (10 replies)
- new to vba (10 replies)
- Cells.find works but found info is not copied (8 replies)
- CountIF statement (6 replies)
- Solved: Extract Data from multi worksheets (5 replies)
- Shapes as a Toggle Button? (5 replies)
- Moving Forms (4 replies)
- Selecting a picture (1 replies)
- Solved: VBA to create Charts for several sheets with different data lengths (4 replies)
- how to use an input box to create a formula (3 replies)
- How to copy from Column A2 to the last populated Column. (1 replies)
- Solved: Before Save Prompt Userform (8 replies)
- Solved: Counting rows? (4 replies)
- Excel - Data Validation Lists (2 replies)
- Solved: How to auto populate data from Worksheet (2 replies)
- AutoSum an unknown range (4 replies)
- Solved: Required to copy and paste a formula to a column range (2 replies)
- show source of value (8 replies)
- Save an excel file got from a '.do' script automatically (0 replies)
- Evaluate() to return column number (8 replies)
- Solved: Turn txtbox on an off (3 replies)
- Solved: VBA: Copy Worksheets to new Workbook & Rename Tabs from Vlookup (2 replies)
- Solved: Lookin for values between workbooks and get the details (2 replies)
- Solved: Toggle:Hide/Unhide Issue with calling a module (10 replies)
- Solved: Write a vba variable out to a sheet (5 replies)
- Need to get web page elements and info (0 replies)
- Problem with loop & variable values (8 replies)
- Excel to Internet Explorer Google Search (1 replies)
- Solved: Message Box in Macros with variables (4 replies)
- DSUM Formula (1 replies)
- Find cells with like values & automatically sum them (1 replies)
- retrieve names from external file (9 replies)
- Solved: Macro in a Toggle Button (2 replies)
- Solved: Adding Time with 30 minutes interval (12 replies)
- Solved: Can I use VBA or DataVal with symbols? (7 replies)
- Using a repeating bottom row as a footer (1 replies)
- Solved: Conditional Formatting on Spreadsheet (7 replies)
- Solved: Average Difference with Date:Time Format (10 replies)
- Solved: Method 'Range' of object '_Worksheet' failed when that worksheet is not active. (4 replies)
- Solved: Determine name of caller procedure (5 replies)
- Add range of rows at the last row (2 replies)
- Solved: Save As Pop up issue (5 replies)
- Solved: How to add a text column to a dynamic range using a macro (3 replies)
- run code after finishing web query load (1 replies)
- Creating strongly typed array - Is this possible?? (3 replies)
- End Loop after submitBtnClick (3 replies)
- VBA for excel (2 replies)
- Solved: 2 codes with ambigous names, HELP (11 replies)
- Challenge: Triangle Area Select tool (72 replies)
- Solved: Presence of a Chart Sheet causes VBA to erro (4 replies)
- Data Validation (6 replies)
- [SOLVED:] Go to next row 1st column when cell selected (12 replies)
- Need to compare 2 very large worksheets (6 replies)
- Solved: Time Sheet Help!! (9 replies)
- Search box within data entry form (17 replies)
- VBA Copy and Paste HELP (5 replies)
- Display an array from one field. (5 replies)
- Data Validation and Formatting Question (10 replies)
- changing sheet name and issues that go along with this... (15 replies)
- Retrieving pixel counts in Excel sheet charts (3 replies)
- Data Import MAcro (1 replies)
- Possible Vlookup, or Index/Match or... (2 replies)
- Group and ungroup certain rows in a protected sheets (6 replies)
- Solved: Count click events then add value to label (3 replies)
- Run Code after Automatic Refresh (1 replies)
- Solved: Sort without selecting the Sheet (9 replies)
- Data Validation (2 replies)
- Solved: DateAdd Function (4 replies)
- Solved: hyperlinks() syntax (1 replies)
- combo box -no edit (1 replies)
- Solved: Accumulate the values (4 replies)
- Solved: Fill empty cell with previous value if condition is met (11 replies)
- sum of different cells in 20 different workbook-sheets (2 replies)
- Print Macro using validated list (2 replies)
- Solved: Add to end of cell (2 replies)
- Solved: customize sort (7 replies)
- [SOLVED:] Move to end of data in Column in different worksheet (8 replies)
- Solved: Lookup values in varying locations? (8 replies)
- Solved: Extract hyperlink from cell and place in cell to right (18 replies)
- Solved: pull excel workbook into excel template (9 replies)
- Solved: Place Date stamp on Chart (2 replies)
- Check Box Formula (2 replies)
- Solved: case to line 1 locks up (9 replies)
- Formatting numbers within formulas (2 replies)
- Solved: Can't loop through worksheets (4 replies)
- Solved: Find column with a value and replace it with another column (5 replies)
- Executing an external application with Excel (1 replies)
- Manipulating Data for Graph creation (3 replies)
- Solved: Odd behaviour of UserForms (1 replies)
- Directory Listing doesn't get ZIP files (1 replies)
- Solved: Proper syntax for writing a user defined function? (6 replies)
- Solved: auto-open and populate (4 replies)
- Filtering and copying (8 replies)
- Currency format from VBA (1 replies)
- Worksheets.Calculate not updating worksheet! (8 replies)
- Colour cell dependent on condition (7 replies)
- Excel - Date formula and Row Highlighting (7 replies)
- Question in logic (2 replies)
- Solved: Enter Formula on Multiple Locations using Macros (4 replies)
- Solved: Teacher needs help in evaluating some simple math text equations (2 replies)
- Button to import cells from another spreadsheet (5 replies)
- Solved: macro to convert all txt files in a folder to excel files (11 replies)
- Solved: Moving Data (12 replies)
- Solved: Teacher needs help in randomizing an answer into one of 4 multiple choice columns (12 replies)
- Modify default size of insert comment (4 replies)
- Solved: My Userform loading takes time (4 replies)
- Solved: Need to remove duplicates based on date in an input box (25 replies)
- Solved: Macro to Sum 2 cells of the Lastrow on another sheet (4 replies)
- Solved: can anyone see what's wrong with this? (2 replies)
- Solved: VBA to Delete Column based on Header (3 replies)
- Sum amounts of field on multiple records (1 replies)
- Macro only sorts 1 column (4 replies)
- Solved: Merging Sheets of Data (20 replies)
- Worksheet Change - Target Range & changes to more than one other cell (5 replies)
- Solved: Script with cells.find returns wrong values compared to VLOOKUP (4 replies)
- Disable a Checkbox with VBA depending on linked cell (2 replies)
- Macro to run at change of cell value without hitting enter key (5 replies)
- Subtotal, Find Max and apply rules using Macro (3 replies)
- VB code for cell linked to multiple selection list box (1 replies)
- Solved: Sorting a non-active sheet (3 replies)
- Create Workspace issues (1 replies)
- File Details - Need correct syntax (7 replies)
- Solved: Absolute Row, Relative Column Refernce VBA (4 replies)
- Solved: Macro not selecting correct sheet (4 replies)
- Collections Overflow (4 replies)
- Solved: Next without For error (2 replies)
- Solved: Look for word then copy and paste row (4 replies)
- Help needed - Memory leak in VBA script (7 replies)
- Manipulating Plots in Macro (3 replies)
- Solved: Create folder structure (4 replies)
- Allocated Day Off (ADO) coding- VBA HELP (2 replies)
- Solved: Concatention Problem (4 replies)
- Solved: Macro to Insert Entire Rows (20 replies)
- Solved: VBA SQL statement (xl '97) (2 replies)
- Use data in txt file in Case Select statement (5 replies)
- Solved: Loop through worksheet and delete rows inbetween 2 search criteria (13 replies)
- Solved: Removing duplicates from filter (2 replies)
- Solved: Macro to create a Table using individual sheets totals as the input (2 replies)
- Counting business days (4 replies)
- Solved: Toggle:Hide/Unhide Columns on 2 separate sheets (5 replies)
- Solved: VBA -Clearing the dropdown cells (2 replies)
- Solved: function to extract chars from string using VBA (4 replies)
- Solved: Code that runs automatically when a dropdown object selection changes (2 replies)
- Retrieve the Path of MouseIcon Picture (3 replies)
- [SOLVED:] Highlight cells which have no dependents (1 replies)
- Solved: Copy Macro that Won't Copy :( (3 replies)
- Solved: Colour of multipage headers (6 replies)
- Showing a userform, but not stopping code (3 replies)
- List of Files in Directory - Almost works (7 replies)
- Solved: Insert formulas macro (4 replies)
- Insert multiple rows-Delete Rows with formulas (1 replies)
- accessing outlook global address book (2 replies)
- Multiple GoalSeek macro: Runtime error '1004': Reference not valid. (3 replies)
- Solved: Assistance with email SendTo (xl '97) (7 replies)
- Solved: Combining workbooks then selective worksheets (12 replies)
- Solved: Deleting name ranges (xl '97) (2 replies)
- Solved: Dynamically Expand Validation Dropdown List (6 replies)
- VBA Tab Reference (2 replies)
- Solved: search for string, write coordinate to variable (2 replies)
- [SOLVED:] Conditional statement in a macro (3 replies)
- Importing Recordset to Access? (2 replies)
- Solved: Consolidating & Cleaning Data - Is there a better way to Do it? (7 replies)
- Solved: Compile Error - Variable Not Defined (6 replies)
- Solved: A way to avoid charting blank cells? (2 replies)
- Solved: CopyToRange then delete duplicate (3 replies)
- Data storage problem (4 replies)
- Start Excel 2007 with an empty worksheet (7 replies)
- [SOLVED:] Option Button in a Protected Worksheet (3 replies)
- Solved: Copy paste special different worksheet to Summary (2 replies)
- Solved: Pick email address from cell in workbook (8 replies)
- A Macro to replace a matching row in a block of cells (13 replies)
- Howto repeat/cycle code through all populated cells in column (10 replies)
- Solved: VBA and FTP (2 replies)
- Solved: Insert a column based on columns header (3 replies)
- Validation On Columns (5 replies)
- Business day only (5 replies)
- New worksheet ...help pls (2 replies)
- Solved: Unable to set the property of the Series Class (3 replies)
- Solved: Macro with a Formula to rename sheets (7 replies)
- Email macro failing (1 replies)
- vba cursor in textbox (3 replies)
- find unknown values which adds up to some values (4 replies)
- Solved: Autoconstruct Forecast Formula from Linest function based on number of variables (6 replies)
- Add blank row after each record (7 replies)
- Solved: Unable to delete custom toolbar created in excel 2003. (5 replies)
- Edit Work Sheet Whilst Msg Box Remains Open (1 replies)
- Solved: unload userform before worksheet deactivate (4 replies)
- Excel Advanced Filter (9 replies)
- Solved: VBA to import files to sheets (4 replies)
- Modify Email macro to check cells for entry prior to emailing. (1 replies)
- Macro Idea for find and edit (3 replies)
- Add formula dynamically to different sheets (0 replies)
- Solved: TRANSPOSE DATA IN COLUMNS INTO ROWS USING A PRIMARY KEY (8 replies)
- Solved: Insert-Delete Rows with formulas (16 replies)
- Controlling web checkbox and buttons FORM type POST (1 replies)
- ListBox Objects? (6 replies)
- Solved: Multiple messages boxes (9 replies)
- Solved: format cells based on 2 criteria (4 replies)
- Solved: Run Macro Whilst Editing (8 replies)
- Find certain criteria delete that row and the next 5 rows as well (7 replies)
- Solved: Arrange/Lag Data in columns By Specfied Lags (4 replies)
- [SOLVED:] Select multiple rows based on cell value (7 replies)
- Solved: Merge the Data (2 replies)
- Solved: Auto Update Links on a Mapped Drive (4 replies)
- Solved: Text to Rows (5 replies)
- Solved: Max 2 decimals allowed in cell (15 replies)
- CheckBox code repetition (8 replies)
- Remove or Bypass the 'File Reservation' Dialogue? (27 replies)
- Delete all files in a directory (0 replies)
- Solved: Spreadsheet control 2007 (2 replies)
- Format selected cells within filtered range (2 replies)
- Code Optimization: Running too slow (3 replies)
- Controlling child web pages of pages opened w/ Excel (0 replies)
- Solved: Pivot Table Formulas (0 replies)
- Solved: Excel - Text to rows (7 replies)
- Solved: Execute multiple subs or one large sub (14 replies)
- Subtotal Macro Formula Help (5 replies)
- Solved: footer code error (4 replies)
- Solved: A kind of Back button in sheet for other sheets (8 replies)
- TreeView node images (2 replies)
- Solved: Same cell address on different sheet comparison problems (8 replies)
- RegEx Split String (7 replies)
- Solved: Creating main folder and sub directories (6 replies)
- Solved: Track Changes in Comment (7 replies)
- Inventory Examples. (5 replies)
- Error handling odd problem (2 replies)
- Compressing VBA Code length (21 replies)