View Full Version : Excel Help
- Solved: create a named range with a changing area
- Solved: want to remove #div/0 error by vbnull string
- [SOLVED:] Counting Cells Where Formula Does Not Return ""
- [SOLVED:] Column number conversion: hex to dec and dec to hex
- Solved: Print 2 pdf VBA error
- Solved: Autofilter using date
- linking ranges into dropdown and option boxes
- Solved: Search for first open cell in Row
- Solved: Different Passwords for all Users to view W/sheets 1 master password
- VBA for copying and pasting and insertion of rows
- Error Generation during copypaste macro run
- Solved: check file for xls and xlsx extensions
- Solved: Downloading Excel File from Website
- Solved: index/match with more than one match
- Solved: Creating a drop down list with source from another sheet
- Solved: Delete workbook on date....
- Solved: Alphanumeric Sort
- Solved: Using is empty on a range
- Solved: VBA Userforms and Cell based formulas not getting on together!
- Solved: Adding and Naming a Worksheet using VBA
- Moving Data from one table to another based on value input
- Solved: Highlighting Option Buttons
- Data And control operations from a closed workbooks being applied on report
- Solved: Cut Paste data into different sheet
- [SOLVED:] check lengh of the values and move to next sheet
- [SOLVED:] Loop not looping properly
- Solved: Active Cell Help
- Solved: How to bring back Recording / Stop Recording floating tool bar
- Please help to tweak my VBA codes
- Solved: Formula For Less Than / Greater Than
- insert array formula into range based on option button selection
- Solved: Text Import - cell format issue
- Solved: Run time error 1004
- Solved: VBA Hyperlink Problem
- Solved: Insert Image from file
- Solved: VBA Sort
- Solved: multiply statusbar
- Solved: Deleting Worksheets without OKing "Warning Message"
- [SOLVED:] Solved: Check if Sheet Name Already Exists
- [SOLVED:] Dynamic Controls
- Solved: Drop down lists tutorial
- Solved: help with copy and paste
- copying data from a closed workbook
- Solved: Create A Short Cut Key in Menu
- Solved: Autofilling a formula within row parameters
- Solved: Subtracting Named Ranges from combo box selection
- Solved: Interesting Auto-Number Problem VBA
- Solved: rearranging Code, separating OffsetResize
- Solved: Index Match Formula - Odd Behaviour
- Email code problem, stopped working
- ScrollBar value * call Macro
- Combobox vs protected sheets
- Solved: Vlookup in VBA - problems
- Solved: YesNo Box - Options Query
- Solved: Covert number to absolute value
- Solved: VBA issue with named ranges across workbooks
- Solved: Long vs Double data type
- Read Only view of a worksheet
- Solved: Copy content of upper cells
- Solved: Create folder & export sheet, not working
- Solved: TextBox Deleter Mystery
- Solved: Changing code (connecting range to dropdown selection)
- Solved: Named cell reference
- copy rows to worksheet two and PDF to print
- Solved: Problem with textfile save
- [SOLVED:] Exporting select data to a .cvs
- Solved: Run-Time Error "13" - Type Mismatch
- Combine 2 Codes
- Solved: Using vlookup with changing end array column
- Solved: Deleting rows as if by magic!!
- Excel chart alert (32000 pts)
- Copying range value without cellformula
- Data changed when imported
- Creating Timestamps
- Annoying privacy warning
- Solved: Automatically Save As when file opens
- Solved: Want to apply code to all sheets but wont work
- Solved: if cell="yes" then colour row yellow? how could do this?
- Sum If Same Row in data table contains criteria
- Get txt files from a folder to master file in different sheets
- Solved: Employee Rota: Worksheet_SelectionChange not working
- CHART Formula Change VBA
- How to make an input form?
- Updating series for all charts on Worksheet
- Running a Function or macro of child file from a Master file
- Cascading Lists via VBA
- Solved: Select numerous cells from active cell
- Invoice
- [SOLVED:] Date format incorrect from Text File
- Solved: Search Macro and Merged Cells
- Userform in Defult text box
- Solved: write log of changes in workbook
- Solved: how to wrap pages in multipage control
- Thank You VBA Express.
- Scrollbar
- How to extract data from Oracle Database into Excel Spreadsheet via VBA code
- Solved: Simple delete entire row
- Separating prices by month
- Deleting All Shapes Deletes Data Validation Forms
- Naming ranges of cells using cell content
- Solved: Print Preview
- Finding average of a range with macro
- Solved: Loop and Compare cell value & value returned from ado query
- filter based on active cell
- Listbox items from an array
- Solved: EXCEL communicating with hyperterminal
- Comparing data against table of values to output new data.
- Get help for telling me how to code VBA to pass argument from Userform to worksheet
- VBA Strongly Typed Arguments
- How to line up input boxes on forms?
- How to deal with quotes within a string
- Column Formatting Works in one instance, but not another
- Preparation of excel spreadsheet data for google motion charts api (VBA?)
- How do I disable inserting of rows?
- VBA Code to Automate Grouping
- Returning Arrays From Functions
- Source Control Of Spreadsheets
- Solved: Copy/Import based on Column Header Name
- Error message for missing data in userform
- Pass date as parameter
- Solved: Split Control
- Getting user to log changes before workbook is closed.
- Solved: vlookup not cooperating with other code
- Pivot Table Macro to lock manual filter/remove blank rows from datasheet
- Running a function of another file
- Sleeper: The opposite of TRIM
- Professional Looking UI Forms
- Icon Librarys
- Bot
- Option Button first IF not working.....
- How to open Other file types
- Referenzen permanent verfügbar machen
- Solved: vlookup problems, even formatted as numbers
- How To Use Vertical Spacing - Make Equal
- [SOLVED:] Macro to make linegraphs
- Solved: Prevent duplicate data entry?
- My Macro stinks
- Closed: My Macro keeps crashing!
- Select/De-select items in list box
- Tracking Deadlines with Excel and Groupwise
- Solved: Calendar Control
- Error when passing data from Excel into Access (Office '97)
- Using Template To Produce Reports Where Number Of DataItems Changes - Advanced.
- Excel 2007 Pivot chart - showing filters on pivot area
- Copy from a cell and insert in another on a new line with a date
- Finding String2 in String1
- Trapping UserForm Events In A Seperate Class
- Solved: Pattern match to find worksheet name
- Maximum users of an Excel File?
- Solved: clicking on option button
- Selected Cell Color / Personal.xlsb
- How do I check if a word file is open from code?
- Functions
- problem comparing cells based on a condition
- Update specific data in one sheet with NEW data from another?
- move items in column up/down by criteria
- Solved: Get cell reference from one cell
- Solved: Copy range from multiple excel files in one file
- Solved: Insert a formula if a different cell is not blank
- Unable to copy, paste; Right click disabled
- Excel 2007 and if statements
- Solved: Sync ListViews items
- Copy to first filtered row problem
- Solved: Find a sheet name
- Self Destruct VBA Code
- Match value in two columns & delete non-matching rows
- Solved: Check list of folder files
- Decent Grids
- Disabling ActiveXControls Prompt
- Paste Combo Boxes so Cell Link is always in same row
- Solved: Macro to add value to cell based on previous available cell valu
- Solved: Sheet Calculate Event Not Working
- VBA Statements work in debug, but not otherwise.
- Using Progress Bars
- Delete Copied Data
- Looping through a range code
- Incorporating lastrow variables into sumproduct formula
- Solved: UserForm KeyDown Button Forces cursor to jump to next textbox
- Solved: Excel Update Links Problem
- Solved: Code to find a given string in a worksheet
- [SOLVED:] Database Connectivity Using Singleton Pattern
- Making a cell noneditable based on dropdown value in another cell
- autofilling formulae across columns
- Hiding sepecific column on based of condition
- Solved: Remove blank series from a chart using VBA ?
- Generate a message to Save and Not Open when downloading a file
- [SOLVED:] Need Help Trying to Unlock Certain Cells
- Do Loop Help
- Forward stepwise regression using VBA
- Working on Code efficiency...
- Capture Printer from Printer Dialog
- RibbonX code
- Solved: Error 1004 in Transpose macro
- Wrapping UserForm Modules.
- Solved: Hide Unhide Worksheets based on Name
- Help With Formula
- Public Variables don't work
- Unable to copy excel spreadsheet to another spreadsheet
- Solved: Data Validation , multiple selection same cell
- Solved: find, copy and paste
- VLOOKUP or HLOOKUP
- Solved: Changing Arrangement of Text in a cell
- Solved: Moving Rows with repeated value to different Tab
- Remove zero chart labels
- Solved: import data from another workbook
- Solved: Hyperlink - full address from displayed text
- Copy and Paste Range in the body email
- Solved: Dynamic code based on cell values
- VBA for Pivot Tables Help (Dates)
- Is it possible to create VBA or even VB just by entering data into a worksheet?
- File Lister
- Combine 2 or more Cells into 1 Cell VBA
- Userform input value to macro
- Workbook OPEN Event Code - Update Links
- Solved: How to chk on duplicated cell values & show msg box
- Varying the cell range around a sum formulae
- Passing a UDT member/element
- Can Excel 2007 help with website accessibility?
- Solved: Macro to Add Link to Each Worksheet?
- Solved: Prevent Sql injection in User Form
- Solved: Centralized Log Manager
- Solved: Limit length of input text box..
- Add subject, body, and attachments to emails thru excell/groupwise
- Solved: Detect if workbook is Read Only
- Shifting data in cell from a work book to another based on some condition.
- Special macro for range goal seek
- First & Last name comparisons
- Solved: wb close and form close
- Refresh pivots on close AND on data being entered
- Process works in debug
- Solved: UserForm change width- Left Border?
- I need help with a click proceedure attached to a dynamic label
- Print specific pages of PDF in Excel using VBA
- VBA Code Help
- Solved: useform help filling list from DB VBA
- Stop Excel from Updating Formula to external Workbook when copying the formula
- Extracting highest value correlations and series names from Correlation Matrix
- Solved: SUMIF "criteria"
- Solved: Calculate cell
- Solved: Formula Problems
- Solved: Inserting data from Excel into Access
- Sub string help
- Using an Excel Spreadsheet as a DataSource using DAO
- Excel VBA to print the entire Workbook single sided
- Problem toggling details
- Solved: Move excel files to a difference folder if sheet name is not "Payment Request"
- Report Macro
- Problem importing data from an xml file
- Solved: Copy a Chart into another Sheet without Links
- Solved: using "--"
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.