- Cascading Lists via VBA (2 replies)
- Running a Function or macro of child file from a Master file (1 replies)
- Updating series for all charts on Worksheet (5 replies)
- How to make an input form? (35 replies)
- CHART Formula Change VBA (17 replies)
- Solved: Employee Rota: Worksheet_SelectionChange not working (3 replies)
- Get txt files from a folder to master file in different sheets (5 replies)
- Sum If Same Row in data table contains criteria (2 replies)
- Solved: if cell="yes" then colour row yellow? how could do this? (6 replies)
- Solved: Want to apply code to all sheets but wont work (1 replies)
- Solved: Automatically Save As when file opens (2 replies)
- Annoying privacy warning (11 replies)
- Creating Timestamps (5 replies)
- Data changed when imported (7 replies)
- Copying range value without cellformula (6 replies)
- Excel chart alert (32000 pts) (1 replies)
- Solved: Deleting rows as if by magic!! (11 replies)
- Solved: Using vlookup with changing end array column (5 replies)
- Combine 2 Codes (4 replies)
- Solved: Run-Time Error "13" - Type Mismatch (3 replies)
- [SOLVED:] Exporting select data to a .cvs (32 replies)
- Solved: Problem with textfile save (1 replies)
- copy rows to worksheet two and PDF to print (7 replies)
- Solved: Named cell reference (6 replies)
- Solved: Changing code (connecting range to dropdown selection) (14 replies)
- Solved: TextBox Deleter Mystery (18 replies)
- Solved: Create folder & export sheet, not working (1 replies)
- Solved: Copy content of upper cells (14 replies)
- Read Only view of a worksheet (3 replies)
- Solved: Long vs Double data type (8 replies)
- Solved: VBA issue with named ranges across workbooks (2 replies)
- Solved: Covert number to absolute value (2 replies)
- Solved: YesNo Box - Options Query (3 replies)
- Solved: Vlookup in VBA - problems (8 replies)
- Combobox vs protected sheets (4 replies)
- ScrollBar value * call Macro (3 replies)
- Email code problem, stopped working (3 replies)
- Solved: Index Match Formula - Odd Behaviour (2 replies)
- Solved: rearranging Code, separating OffsetResize (4 replies)
- Solved: Interesting Auto-Number Problem VBA (11 replies)
- Solved: Subtracting Named Ranges from combo box selection (5 replies)
- [SOLVED:] Autofilling a formula within row parameters (2 replies)
- Solved: Create A Short Cut Key in Menu (11 replies)
- copying data from a closed workbook (1 replies)
- Solved: help with copy and paste (4 replies)
- Solved: Drop down lists tutorial (2 replies)
- [SOLVED:] Dynamic Controls (7 replies)
- [SOLVED:] Solved: Check if Sheet Name Already Exists (2 replies)
- Solved: Deleting Worksheets without OKing "Warning Message" (2 replies)
- Solved: multiply statusbar (29 replies)
- Solved: VBA Sort (8 replies)
- Solved: Insert Image from file (2 replies)
- Solved: VBA Hyperlink Problem (6 replies)
- Solved: Run time error 1004 (2 replies)
- Solved: Text Import - cell format issue (2 replies)
- insert array formula into range based on option button selection (5 replies)
- Solved: Formula For Less Than / Greater Than (2 replies)
- Please help to tweak my VBA codes (0 replies)
- Solved: How to bring back Recording / Stop Recording floating tool bar (2 replies)
- Solved: Active Cell Help (18 replies)
- [SOLVED:] Loop not looping properly (2 replies)
- [SOLVED:] check lengh of the values and move to next sheet (29 replies)
- Solved: Cut Paste data into different sheet (2 replies)
- Data And control operations from a closed workbooks being applied on report (0 replies)
- Solved: Highlighting Option Buttons (3 replies)
- Moving Data from one table to another based on value input (1 replies)
- Solved: Adding and Naming a Worksheet using VBA (3 replies)
- Solved: VBA Userforms and Cell based formulas not getting on together! (4 replies)
- Solved: Using is empty on a range (4 replies)
- Solved: Alphanumeric Sort (7 replies)
- Solved: Delete workbook on date.... (4 replies)
- Solved: Creating a drop down list with source from another sheet (3 replies)
- Solved: index/match with more than one match (7 replies)
- Solved: Downloading Excel File from Website (7 replies)
- Solved: check file for xls and xlsx extensions (3 replies)
- Error Generation during copypaste macro run (5 replies)
- VBA for copying and pasting and insertion of rows (0 replies)
- Solved: Different Passwords for all Users to view W/sheets 1 master password (40 replies)
- Solved: Search for first open cell in Row (4 replies)
- linking ranges into dropdown and option boxes (3 replies)
- Solved: Autofilter using date (4 replies)
- Solved: Print 2 pdf VBA error (9 replies)
- [SOLVED:] Column number conversion: hex to dec and dec to hex (11 replies)
- [SOLVED:] Counting Cells Where Formula Does Not Return "" (3 replies)
- Solved: want to remove #div/0 error by vbnull string (1 replies)
- Solved: create a named range with a changing area (2 replies)
- Update Links in multiple workbooks (2 replies)
- Solved: Creating a name range in one column (1 replies)
- Solved: Increment offset (3 replies)
- Solved: Noob question (1 replies)
- Solved: File IO low level functions -- not working (1 replies)
- Cost Forecast spreadsheet (1 replies)
- Solved: Manipulate String based on Carriage Return (8 replies)
- Userform runs ok in VBA Editor, but not when started from macro in workbook (1 replies)
- Solved: TextBox display columA & B (19 replies)
- Solved: Minimize/Maximize Userform (6 replies)
- Solved: dateserial format (2 replies)
- Solved: Using Countif with multiple criteria (4 replies)
- FollowHyperlink (5 replies)
- [SOLVED:] Exporting data to Word (13 replies)
- How Sheet formulae is called (9 replies)
- Solved: Move row to correct sheet if column V = "Y" (2 replies)
- Solved: Coloring sheet tab conditionnally (4 replies)
- Excel and Bloomberg (1 replies)
- Questioner Form (2 replies)
- how to count items in a column (2 replies)
- Solved: Macro is off... need help with copy & paste function (4 replies)
- Solved: Looking for VBA resources? (2 replies)
- Solved: Where can I find some VBA scripts or related scripts such as VB & VBS? (1 replies)
- Could you give me an example of a VBA script that automates writing scripts? (1 replies)
- Linking cells to sheets & Duplicate W/Sheets (1 replies)
- Soap Action Fails: redux and challenge (1 replies)
- [SOLVED:] Code works without proper Dims, why? (3 replies)
- Solved: Converting 3 Rows to 8 columns (6 replies)
- Solved: Excel does not allow importing* accdb files (1 replies)
- Solved: multiply values from a textbox and combobox in a userform (10 replies)
- Solved: Change based upon a cell value (2 replies)
- Solved: Combobox Colors (3 replies)
- Solved: save sheet to desktop with name from cell (5 replies)
- Solved: Save changes to Add-in on application close (5 replies)
- Adding controls to a form at runtime (4 replies)
- Solved: Delete a Worksheet Command Button (12 replies)
- Solved: identify last row and change formula accordingly (4 replies)
- Solved: Hide button with associated row (6 replies)
- Solved: If Not fso.FileExists ? (2 replies)
- Solved: Solved Zoom in if specific cells are selected (3 replies)
- Solved: Forms (5 replies)
- Need help writing an Input Function (7 replies)
- Solved: Array Help! (3 replies)
- Solved: Excel Charts - Naming (4 replies)
- Solved: Sort Data Help (0 replies)
- Worksheet_change (2 replies)
- Combo Box question (12 replies)
- Solved: Insert set parts in list (23 replies)
- Delete blank series from a XY Scatter Chart (2 replies)
- Solved: filtering on named ranges. (8 replies)
- Match function (4 replies)
- Solved: Problems converting date into required format (5 replies)
- Formatting TextBox (6 replies)
- multiply value with 1 - optimization (9 replies)
- Solved: Format code for multiple areas (2 replies)
- Automatic Reconciliation (0 replies)
- Solved: How to copy only formats and formulas, not values (3 replies)
- How do I launch a program from Excel? (1 replies)
- Solved: Text boxes (8 replies)
- What is the VBA code to enter text from a cell into a website's form? (12 replies)
- Hlookup (5 replies)
- Report to show >2 Instances of an Absence (5 replies)
- color grid (3 replies)
- Sleeper: Using a UDF in Multiple Worksheets (4 replies)
- Solved: VBA to identify duplicate entry and insert row to other worksheet (14 replies)
- Solved: Run an access macro thru excel (4 replies)
- Excel VBA to check if multiple worksheets exist (6 replies)
- VBA userForm: changing images (6 replies)
- help with "select method of range class failed" (3 replies)
- How to construct VLOOKUP in VBA? (4 replies)
- Sleeper: Distribution of data among employees (2 replies)
- How to put together caption (2 replies)
- [SOLVED:] SOAP Action fails (5 replies)
- Counting Data between Decades (1 replies)
- Parse SAS LOG using RegExp (10 replies)
- Functions can change some properties? (5 replies)
- Print Multiple Sheets as Word Docs (7 replies)
- Solved: Check if cell has data validation (2 replies)
- Find last row, insert row retaining format of last line and repeat for named tabs (1 replies)
- How to end unlimited cycle? (6 replies)
- Solved: Highlight the line when certain cell is selected (10 replies)
- Global Error Handling (11 replies)
- Enter seperate cells in chart (4 replies)
- A special calculation (8 replies)
- Solved: insert rows based on cell value (6 replies)
- VBA help needed :( (14 replies)
- Solved: Subtracting Numbers with Sheets 1/2 data (6 replies)
- Solved: Prevent the user from seing some worksheets (4 replies)
- Folder/Subfolder list help. (16 replies)
- Solved: Prevent the user from bypassing Data Validation (10 replies)
- Solved: Find, Cut, Move & Copy issue (3 replies)
- IMPORT *.LOG file into textbox + autosize (9 replies)
- Derived classes in VBA (1 replies)
- VBA Running Excel 2003 when you have 2007 Installed (1 replies)
- Solved: Extend range of cells from active cells (6 replies)
- Solved: External Data Requery (3 replies)
- Solved: What formula or vba code for this case (5 replies)
- Printing time period based on usr input. (10 replies)
- Object-oriented programming in VBA (5 replies)
- Solved: Sheet Code is not working correctly (8 replies)
- Solved: 2007 Application.Quit (2 replies)
- Macro to Loop Through a Repetitive Task? (7 replies)
- Read a Mainframe Dataset (PDS) using VBA (6 replies)
- Referring to pasted shapes / pictures (10 replies)
- Viewing VBA when passwd protected (1 replies)
- Opening File in VBA code (1 replies)
- enter seperate cells in chart (0 replies)
- Sleeper: Multiple pictures in one section in the header (0 replies)
- Clean the working mess (5 replies)
- Solved: Fade Away Userform doesnt work properly when closing userform (9 replies)
- Solved: Setting Dynamic Print Range (3 replies)
- Solved: Macros across workbboks (12 replies)
- Dynamic Validation Not working? (4 replies)
- Solved: Generate a random string of letters (6 replies)
- Solved: How can I return cell value via worksheet name (2 replies)
- Converting number to text (7 replies)
- auto-complete scroll bar (2 replies)
- Solved: Soap: need refresher (5 replies)
- Strange problem with excel chart (0 replies)
- Solved: Visible Range after AutoFilter (5 replies)
- VBA Project Password (2 replies)
- [SOLVED:] Sort Sheets in ascending order (2 replies)
- change code help (1 replies)
- Solved: creating new workbook/searching for wkbook (14 replies)
- [SOLVED:] Grey out menu item (5 replies)
- Solved: public functions (1 replies)
- Solved: Test before paste special (8 replies)
- Solved: Can I insert a copied row with a macro? (9 replies)
- Code help (4 replies)
- Adhoc SumIf on variable criteria (2 replies)
- Using NORMSDIST() Function in VBA (4 replies)
- PDF all worksheets and print (1 replies)
- Problem with hyperlink (15 replies)
- Solved: make sure 2 values always equal (6 replies)
- [SLEEPER:] Prevent user from viewing the code (1 replies)
- Solved: 6 dependant drop down boxes (12 replies)
- Solved: Load IE to Excel Sheet (5 replies)
- Help with USerForm Contain MultiPages (0 replies)
- Solved: Protect UserForm but not module (1 replies)
- Solved: How get TargetPath of .lnk or .url shortcut files? (8 replies)
- Excel Print Specific word document page (5 replies)
- Cycle thru worksheets and import shape according to dynamic values (3 replies)
- Excel 2003 Query Sharepoint List (0 replies)
- Solved: Rearranging data (9 replies)
- Excel Chart (0 replies)
- Excel Visible/Invisible (4 replies)
- Solved: Excel 2003: Disable screen refresh during intensive chart updating (8 replies)
- How to write a click event from a list box??? (2 replies)
- Two add-ins for one custom ribbon tab (2 replies)
- [SOLVED:] Excel to World find Wholeword (1 replies)
- IF Formula (0 replies)
- Write to text file question (15 replies)
- vlookup and hlookup on multiple criteria (12 replies)
- sumifs in VBA (5 replies)
- [SOLVED:] Prevent variable from being initialized (2 replies)
- Find maximum and minimum values each day (2 replies)
- Solved: Avoiding a <type mismatch> error using IsError ? (4 replies)
- Solved: Problem in personal worksheet (18 replies)
- redefinition type in VBA (1 replies)
- dates in columns (2 replies)
- refresh all on protected sheet (7 replies)
- Advice: Redefine type of variable (3 replies)
- Solved: Find Value in Column And Paste data into it (15 replies)
- Solved: Insert Image from Userform Commandbutton. (6 replies)