View Full Version : Excel Help
- Adding Criteria to UDF functions
- Solved: Change value of one cell based on another cell (Tree logic)
- Solved: VBA create hyperlink
- average over several columns/spreadsheets
- Solved: VBA : multidimensional arrays to fill from a worksheet
- Solved: VBA: Extract Number from Cell
- Solved: VBA: Find next empty cell in a certain range
- Solved: How to find broken links
- Transfer zip code to another column
- Need Help: Updating dates monthly
- Solved: split cell based on a multiple delimiters list
- Solved: How to draw following plot is excel?
- Formula and Insert the Column problem
- ListView .finditem syntax
- Solved: Userform writing to worksheet
- Solved: Value Matching Validation
- Extract Application information
- Treat Several Columns as one in Pivot Report
- Solved: Shift rows to columns by condition
- Solved: If range has values then.....
- Test for Parenthesis at end of string
- Compiling Multiple XML Workbooks
- "Should Cost" Model template in Excel
- Trying to create a chart without a Legend
- sum then devide by a hundred
- basic syntax query
- Multiple nested arrays to fill from a worksheet
- VBA to extract information from Pivot Table
- SpaceChart plot does not show up
- Convert Sheet To PDF Before Emailing
- Solved: Can macro let user click to choose workbook
- vba open workbooks
- Solved: Lost Workbook
- Design of set up
- Solved: Simple error message
- vlookup probs
- VB Stopwatch Code
- For a website, are Excel scripts better than other programming language scripts?
- VBA to adjust print area based on UsedRange
- Solved: Excel chart
- VB Formula Assistance needed
- Solved: Okay, here is a wierd one for you!!!
- Run code when cell changes
- need VB solution for comparing trendlines
- Embeding HTML in Excel
- VB Button Code, HELP
- Controlling powerpoint from excel
- Solved: Getb Special Folders with Enums
- Solved: Correct method for a second FindThis criteria
- excel to powerpoint
- Drop down validation using array
- Excel VB Programing
- selecting a range from a user defined reference in another sheet
- VBA to perform specific instruction upon identification of duplicate entries
- anchor picture to cell
- Saving an activeworkbook as a time stamp
- Add dynamic subtotals and then hide all blank rows
- Moving files from one folder to another
- SPLIT TEXT BY MACROS
- VBA issue exporting Chart to Word
- Solved: changing cell value/mapping
- Input Line
- Data number, symbols, sectors
- Detect Change in Row . .
- Tough VBA data pulling from IE to Excel coding question
- Solved: ADO Assistance (Excel into Access) ('97 versions)
- Probably simple VBA issue
- Force users to enable macros in a workbook
- Solved: Filtering multiple worksheets based on master worksheet
- Time Out and auto close after expired time
- Solved: Creating directories from within excel?
- VBA to click OK in Javascript popup box?
- Solved: color code range
- List File Attributes of Directory and Sub-directories
- Conditional formatting question
- Problem with deleting empty cells
- Disable Cut, Copy, Paste
- Any way to prevent deleting a specific WS?
- VBA code to use a hyperlink to email file
- Vlookup problem
- Solved: ListFillRange from another workbook
- Solved: Adding a button to a commandbar (Excel '97)
- Solved: move cursor to row X in active column
- Solved: VLOOKUP problem
- test of KB code on Disable Cut, Copy, Paste
- Solved: Identify column or number
- Solved: Insert Image from Userform Commandbutton.
- Solved: Find Value in Column And Paste data into it
- Advice: Redefine type of variable
- refresh all on protected sheet
- dates in columns
- redefinition type in VBA
- Solved: Problem in personal worksheet
- Solved: Avoiding a <type mismatch> error using IsError ?
- Find maximum and minimum values each day
- Prevent variable from being initialized
- sumifs in VBA
- vlookup and hlookup on multiple criteria
- Write to text file question
- IF Formula
- [SOLVED:] Excel to World find Wholeword
- Two add-ins for one custom ribbon tab
- How to write a click event from a list box???
- Solved: Excel 2003: Disable screen refresh during intensive chart updating
- Excel Visible/Invisible
- Excel Chart
- Solved: Rearranging data
- Excel 2003 Query Sharepoint List
- Cycle thru worksheets and import shape according to dynamic values
- Excel Print Specific word document page
- Solved: How get TargetPath of .lnk or .url shortcut files?
- Solved: Protect UserForm but not module
- Help with USerForm Contain MultiPages
- Solved: Load IE to Excel Sheet
- Solved: 6 dependant drop down boxes
- [SLEEPER:] Prevent user from viewing the code
- Solved: make sure 2 values always equal
- Problem with hyperlink
- PDF all worksheets and print
- Using NORMSDIST() Function in VBA
- Adhoc SumIf on variable criteria
- Code help
- Solved: Can I insert a copied row with a macro?
- Solved: Test before paste special
- Solved: public functions
- Grey out menu item
- Solved: creating new workbook/searching for wkbook
- change code help
- [SOLVED:] Sort Sheets in ascending order
- VBA Project Password
- Solved: Visible Range after AutoFilter
- Strange problem with excel chart
- Solved: Soap: need refresher
- auto-complete scroll bar
- Converting number to text
- Solved: How can I return cell value via worksheet name
- Solved: Generate a random string of letters
- Dynamic Validation Not working?
- Solved: Macros across workbboks
- Solved: Setting Dynamic Print Range
- Solved: Fade Away Userform doesnt work properly when closing userform
- Clean the working mess
- Sleeper: Multiple pictures in one section in the header
- enter seperate cells in chart
- Opening File in VBA code
- Viewing VBA when passwd protected
- Referring to pasted shapes / pictures
- Read a Mainframe Dataset (PDS) using VBA
- Macro to Loop Through a Repetitive Task?
- Solved: 2007 Application.Quit
- Solved: Sheet Code is not working correctly
- Object-oriented programming in VBA
- Printing time period based on usr input.
- Solved: What formula or vba code for this case
- Solved: External Data Requery
- Solved: Extend range of cells from active cells
- VBA Running Excel 2003 when you have 2007 Installed
- Derived classes in VBA
- IMPORT *.LOG file into textbox + autosize
- Solved: Find, Cut, Move & Copy issue
- Solved: Prevent the user from bypassing Data Validation
- Folder/Subfolder list help.
- Solved: Prevent the user from seing some worksheets
- Solved: Subtracting Numbers with Sheets 1/2 data
- VBA help needed :(
- Solved: insert rows based on cell value
- A special calculation
- Enter seperate cells in chart
- Global Error Handling
- Solved: Highlight the line when certain cell is selected
- How to end unlimited cycle?
- Find last row, insert row retaining format of last line and repeat for named tabs
- Solved: Check if cell has data validation
- Print Multiple Sheets as Word Docs
- Functions can change some properties?
- Parse SAS LOG using RegExp
- Counting Data between Decades
- Solved: SOAP Action fails
- How to put together caption
- Sleeper: Distribution of data among employees
- How to construct VLOOKUP in VBA?
- help with "select method of range class failed"
- VBA userForm: changing images
- Excel VBA to check if multiple worksheets exist
- Solved: Run an access macro thru excel
- Solved: VBA to identify duplicate entry and insert row to other worksheet
- Sleeper: Using a UDF in Multiple Worksheets
- color grid
- Report to show >2 Instances of an Absence
- Hlookup
- What is the VBA code to enter text from a cell into a website's form?
- Solved: Text boxes
- How do I launch a program from Excel?
- Solved: How to copy only formats and formulas, not values
- Automatic Reconciliation
- Solved: Format code for multiple areas
- multiply value with 1 - optimization
- Formatting TextBox
- Solved: Problems converting date into required format
- Match function
- Solved: filtering on named ranges.
- Delete blank series from a XY Scatter Chart
- Solved: Insert set parts in list
- Combo Box question
- Worksheet_change
- Solved: Sort Data Help
- Solved: Excel Charts - Naming
- Solved: Array Help!
- Need help writing an Input Function
- Solved: Forms
- Solved: Solved Zoom in if specific cells are selected
- Solved: If Not fso.FileExists ?
- Solved: Hide button with associated row
- Solved: identify last row and change formula accordingly
- Solved: Delete a Worksheet Command Button
- Adding controls to a form at runtime
- Solved: Save changes to Add-in on application close
- Solved: save sheet to desktop with name from cell
- Solved: Combobox Colors
- Solved: Change based upon a cell value
- Solved: multiply values from a textbox and combobox in a userform
- Solved: Excel does not allow importing* accdb files
- Solved: Converting 3 Rows to 8 columns
- Solved: Code works without proper Dims, why?
- Soap Action Fails: redux and challenge
- Linking cells to sheets & Duplicate W/Sheets
- Could you give me an example of a VBA script that automates writing scripts?
- Solved: Where can I find some VBA scripts or related scripts such as VB & VBS?
- Solved: Looking for VBA resources?
- Solved: Macro is off... need help with copy & paste function
- how to count items in a column
- Questioner Form
- Excel and Bloomberg
- Solved: Coloring sheet tab conditionnally
- Solved: Move row to correct sheet if column V = &quot;Y&quot;
- How Sheet formulae is called
- [SOLVED:] Exporting data to Word
- FollowHyperlink
- Solved: Using Countif with multiple criteria
- Solved: dateserial format
- Solved: Minimize/Maximize Userform
- Solved: TextBox display columA & B
- Userform runs ok in VBA Editor, but not when started from macro in workbook
- Solved: Manipulate String based on Carriage Return
- Cost Forecast spreadsheet
- Solved: File IO low level functions -- not working
- Solved: Noob question
- Solved: Increment offset
- Solved: Creating a name range in one column
- Update Links in multiple workbooks
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.