View Full Version : Excel Help
- Active button coding
- Create a Letter and Label from Excel
- Send email notification when conditions are met
- Creating buttons is very slow
- Creating Addin that will work regardles saved folder location
- UserFrom if can edit
- Solved: Excel Add-IN
- how to optimise sumproduct function
- Broken macro - can't transfer from excel to access!
- Compare, Copy and Paste using VBA
- Solved: LOOKUP function not Functioning!
- Solved: Check if data exists, then copy
- delay between codes
- Solved: Updating Excel Chart
- How to replace Access data from EXCEL instead of adding to it?
- How can I create a Vlookup to certain columns in a closed workbook?
- Applying Template to Power Slides via Excel
- VBA: If Date (range) Then (do this)
- Enter Formula in Cell Based on Heading in Another Cell
- Solved: hiding columns
- beforeclose, saving the workbook
- UDF Returns circular reference...?
- Please help me to write the code for this Excel-VBA problem?
- A Userform to enter data on a new line
- Produce charts with range containing formula
- Solved: Referencing UDF from another workbook; Evaluate?
- Getting Error Message in Excel 2007
- making a "Formula like" userform
- Solved: x dimensions array, combobox and loop...
- Increment upper bound of loop
- Solved: function match : error in vba
- Delete Sheets
- Delete Rows if Value in Column A
- import large CSV file(more then 80k records) to MS Access table
- Solved: Change font characteristics depending on value
- Solved: Function/Sub with Parameters assigned to a Button
- Receiving variables from a batch file
- Split range of cells into individual numbers?
- Need Help
- Solved: Uhh... Corresponding number detection and copying
- Solved: Counting different values
- Use Find Across multiple workbooks/ multiple worksheet
- Solved: Chose last of identical data from a column
- UserForm help, assigning variable from option button selection
- Solved: Redim Preserve
- ComboBox can't typing the value ?
- Solved: Delete if matching colour
- Solved: Match function in Vba
- Display DownTimer in the UserForm & at the same time User should work with UserForm ?
- [SLEEPER:] Even or odd week?
- Creating fields
- VBA help
- Solved: Insert blank row below set value
- Solved: Choose data for use in control limits
- [SOLVED:] VB code for greater than 1 or less than -1
- Using Excel type formulae in VBA Forms
- Solved: Update buggy workbook links with .Activate
- Ftp Folder
- advanced find and replace loop
- How to Retrieve the Last Search Term from Find()
- Disable comments on mouse hover
- Solved: Run macro in another workbook without its name
- For...Each Loop Backwards?
- Solved: Conditional formatting not working unless I step into a cell
- Folder referance ?
- [SOLVED:] Compile error in hidden module: distMon
- Using form to editing
- Generate file name with date from cell (not current date)
- Solved: Copy Paste in arranged manner
- Solved: To check if to versions are identical
- How to copy contents of text file to tab sheet of another excelsheet
- Solved: Userform Commandbuttons query
- Button to unhide sheets
- Solved: Backing Up in a Macro
- Solved: Sort multi-dim array by one value?
- Automatically Insert Hyperlink When Text Is Typed In Column
- Solved: Return DAY of Week based on Date
- A Loop in a Loop
- Numbers Directory
- Search a range of columns for values?
- Combo box
- Excel 2007 Buttons in Print Preview Disabled
- Macro code to generate Email..help
- Environmental variables to get to ?My Docs? or "My Documents" location.
- Dropdowns and Zoom??
- pivot table and MS Queries
- Solved: pivot table: sum column is incorrect
- Sending mails
- Solved: Creating Dynamic Validation Lists Based on A Selection from Another List
- Solved: Validating Excel data entry
- Solved: Need Macro to pull data from Web
- Solved: Compressing files
- Select or msgbox last cell edited by code?
- VBA if..then comparison not working ???
- Solved: Copy rows selectively
- Solved: Form-Filling GUI: ComboBox problem
- Solved: Trying to uninstall addin when closing file
- Update Checkbox across workbooks
- Create a consecutive character array?
- Excel - Email Groupwise HTML
- Image as Multipage Caption
- Solved: sum values based upon 2 or 3 conditions
- Refreshing data from multiple large workbooks
- Solved: Save specific cells in Excel with a Macro
- [SOLVED:] How to find the first and last row of merge Cells???
- Need help to get rid of unwanted " in text output file from an excel macro
- User Forms behaving strangely
- Print ranges on worksheet
- Macros Paste Special to another Workbook
- How to write a formula with a bunch of 'IF' statements
- Copy row from workbook if...
- VBA Code for mail merger & Printing
- Autofill not working
- Charting an array as a series
- Why does .address put $ in value
- Why my program gets slow down after running for a while
- Solved: Using IsInPlace
- Solved: sort without worksheet?
- Excel Chart Lists
- BO reports (rep files) need to be refreshed from Excel Module
- auto filter
- Solved: Image to Excel
- Copy Paste toggle not working
- Why is this chunk of code freezing
- Alpha Testers Wanted
- Solved: Multiple 'On Error' commands in function doesn't work?
- Solved: Worksheet freezes up
- [SLEEPER:] How to automatically trigger a VBA code to respond to expected msgbox
- Putting variable values in a second sheet
- Solved: swicthing between formulas
- vba if statement
- ERROr while running a macro
- problem with combobox
- Solved: pb: if condition = true then go to next iteration
- Solved: Excel Charts again
- [SOLVED:] Help Alter Code
- Enable paste
- vlookup in Vba + preventing tabulations in a form field
- Linked Picture; Add to Comment
- Solved: Preventing N/A# in Vlookup?
- Solved: vlookup non-contiguous ranges
- Using VBA to copy and paste the content of multiple worksheets to a new files
- Solved: Returning an array from a function
- Excel File Sharing Communication Tool
- getting a Macro not to call another macro ??
- Copying values
- Solved: Combine H and V lookup or better idea?
- Solved: Run-time error '53': File Not Found
- Use text from embedded object
- Excel 2007 template - issue with vba macros (emailing)
- Adding multiple entries to Time Sheet
- Convert to PDF on Legal Size Paper
- Solved: Returning data based on multiple criteria
- Dynamic Form CheckBoxes Controlls
- Date format
- Solved: copy contents of one workbook into another
- Solved: SUBTOTAL COUNT
- Help! Excel User prompt for data input
- Solved: Writing to a word file from within excel
- Fix data position
- Solved: 2D Arrays
- Conditional Formatting with command button
- Solved: Insert blank row, NOT "insert copied cells"
- Solved: Check cells in an AutoFiltered Range
- Solved: Copy and Paste - File to File (All files are Password Protected)
- Running a User Defined Function in VBA
- Solved: sumif feature needed for multiple criteria using wildcards
- A reminder please, copying range from one ws to another
- Shared Workbook Woes
- Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell
- UserForm: Initialize a ListBox
- Number of Objects Limitation in Sheet
- Solved: Creating A Shortcut Key
- Solved: UDF to convert long date to "mmmyy" String
- Solved: VBA hide columns or rows based on certain criteria
- Solved: Sub to Open workbooks, and update named ranges
- Solved: PLEASE: Chart Help
- Solved: Extracting only part which is within brackats
- [SOLVED:] What is escape character for quotation marks?
- Checkboxes and Sheet Protection
- Multi Tracker Entry Help
- Extracting information after B/C
- Solved: sort ascending leaves blanks at the top
- Row & Column Indicators
- Solved: Days Difference between text box
- Solved: I want to go to "File Save As" as soon as openned
- How to write a VBA-Excel code to find geometric mean?
- Dynamic Range over extending issue
- auto print
- Appends the contents to the respective columns
- add extra step to macro
- Solved: insert code to show progress
- Problems with FileCopy and Wb(name).close
- How do I keep a Custom Menu attached to a sheet?
- auto fill
- Solved: How do I get excel to change the colour of cells dependant on values in other cells?
- speed macro using array
- Solved: get the name of the selected file.
- Iterating through an array, and omitting results
- Help with wierd way of doing things
- Solved: Combobox - Dynamic Named Range
- User function to solve Polynomal equation
- Solved: Trouble with Inserting Rows
- Polynomal trend line
- Solved: Insert a new row after finding text "total" in a cell
- WorkBook Log-in Access
- Look up and sum across sheets?
- Change line color for new series programatically
- easy vb help
- Solved: Easiest way to check/uncheck all checkboxes?
- Page Header: Always 1st Row of ColB of that particular page should appear
- Cut Paste macro
- Solved: Stop user accessing worksheet "Administartor"
- Solved: clear data in data based upon a condition
- Color column A if another column equals 2
- Solved: Consolodating totals for duplicate rows
- Check for a particular value and formatting the cell in another sheet
- Help - Range Values Selection
- Solved: Two arrays and one set of code
- Compile Error
- Solved: Double Click, Insert Character
- Solved: Matching Multiple Cells
- Useing a variable to control a combobox
- VBA Script to open macro dialog box
- Help With - For Next Loop & Possible Inclusion of If Statement
- VBA script to download data from a url
- Solved: How to detect multiple cell selection
- Solved: Filtering issue
- Solved: Function to Return Offsetted Values
- Simple Question, Hopefully
- Solved: Sort by two criteria
- Solved: Dates Screwing up!
- VBA script to copy workbook contents
- Formatting issues: copy/paste & Ctr-F
- Help with Find program
- Solved: Check if cell begins with number
- Tricky worksheet Problem....
- Sub or Function not defined - switch off
- Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts
- Copy range in new sheet by criteria
- Assign Macro Shortcut
- How to make a range reaonly or locked or non editable???
- help with a message box on error
- Solved: Msg box - if password is wrong
- Solved: Trim the fat
- Parse .txt file
- Concatenate From within formula
- Dynamic Scatterplot
- Solved: Trim formula needed in condiational formatting
- Solved: Sort specific workbook
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.