- Solved: Hyperlinking photos from directory
- Create Sheet
- export word tables into excel
- Solved: Find key words in a column and color the row
- Array or Collection - building a file summary
- next number in column
- Sum unknown rows with know columns
- Copy data from several worksheets to one existing worksheet with VBA
- Solved: deleting blank rows in a specific range
- expression for the code "cells.find(..)"
- Help perfecting some VBA from a recorded macro
- Removing Punctuation Macro Also Removing Leading Zeroes
- Creating a control
- Solved: Hyperlinking to bookmarks in a word document
- Solved: Display Message after Submission on a Data Validation List
- Change format of Variable to Time
- filter data and than load it into master file
- [SOLVED:] Run time error 424 object required
- [Excel 2010 VBA] Get events of an object created on a Frame, OLEObjects.
- WRITE FORMULA TO WORKBOOKS HAVE PASSWORD (EXCEL 2007)
- Solved: AlphaNumber Formula
- Solved: VBA VLookup not working
- VBA Problem taking cell data from IE
- Solved: evaluate some numbers
- [SLEEPER:] Pivot table multiple filters
- Reference a word doc embedded into excel
- invalid property value error with combobox
- Solved: Chr(34) returning ""
- SQL statements with VBA
- Shell with an array result - check items 1 by 1
- Who Can Solve This Problem?
- Solved: VBA code for number sequence excel
- Cumulative mismatch records to single one
- How to add calender controls button in toolbox
- Criteria Based web query in excel
- Solved: Enter Times Without the Colon
- [SLEEPER:] Excel VBA - load and search a Word Doc?
- Back to user form
- Worksheet_Change and DDE
- Password encrypted
- How can I let the macro determine if the contents of a cell is numeric or text
- VBA Code for Calendar Date Button
- Cell Tab Order
- textbox to integer
- Run macro at different intervals based on cell date's distance from today's date
- [SOLVED:] Infinite Loop problem
- [SOLVED:] VBA Code for Sum by condition for each date
- Solved: Incorporating dynamic ranges into CORREL function using VBA
- Solved: Simple Segregation of Sums
- Clear out static variables
- error when changing font color with VBA based on cell value
- regex function isn't working
- Email with updated spreadsheet attached
- Solved: Lotus Notes
- macro to generate next serial NO
- Hyperlink problem
- expression for offset()
- skipping ahead in for loop
- insert empty row where the content between two lines are different
- Solved: Msg Box on 1st of every month
- Copying from only cells with data in range
- Solved: trying to dynamically create a userform
- Solved: Print Selective Area
- check if workbook open - if not open it
- Adv Data Seperation
- Prevent Clear Contents
- pivot help
- if sheets("sheet1") doesn't exist, then a message box will appear
- Solved: VBA If statement using and OR function
- Solved: the last cell in each column
- VBA Generating List
- need vbd string to number
- Solved: Auto Numbering Alternative Column using VBA Macros
- cut, paste, blank cell....
- Solved: Vlookup help filling combo box
- Help to Create Addins XLA for user control access
- Open a File from a folder Excel Vba
- Increase row number
- Array to fill combobox
- Userform_activate from immediate window?
- Solved: Running a Function from a Worksheet
- Concatenate Data with Column Headings
- Solved: Need help to understand this code
- [SOLVED:] Problem Reading Text file with Excel Macro (VBA)
- How to use variable column number in vba
- Solved: Add amount everyday
- Solved: Pivot Table Source and Filter
- Solved: Code that returns the full path of a link
- Solved: Copying excel cell content into word template table
- Port to word doc
- Macro to LIST ALL FILES IN FOLDER and then IMPORT ALL LISTED FILES
- select columns A through D for each cell value in column A that equals a variable
- Excel Macro Code Run without Button Click
- Use a macro to stop to run other macros.
- Solved: Too next Together?
- Random
- Solved: Assign Cell Value to array
- Data Sequence like sheet1
- Problem with Macro printing code
- Solved: Silly Ques: What is the Underscore btwn listed variables?
- Runtime Error '9' Subscript out of range
- Error handler
- Solved: Too many nested loops in excel
- Solved: Controlling a webpage dropdown
- Interesting observation about evaluate command
- Web Query from Logon and password protected web page
- Copy non continuous ranges and paste it new word file
- Convert format cell to text
- [SOLVED:] Compare Two Columns and return text
- Close ss with confirmation
- Solved: output excel rows to txt files
- Solved: Copy and Paste in next available row
- Highlight Cell if it contains a specific character in specific position.
- Help with VB in Excel 2010
- Mass file renaming
- Solved: copy only used rows to another sheet
- Advanced onsheet Goal Seek
- send mail automatically on a specific date
- Need for Speed
- First empty row in given range (i.e. C3:G16)
- Solved: Update current url
- find worksheet based on selection from dropdown list
- First experience with VBA - hoping to get tips on streamlining my macro!
- Open each file in ary and transpose range
- Today() to send email.
- SUMPRODUCT confusion
- Help w/ Comparing Lists using IF's and vLookup
- Conditional statement does not work
- VBA to open, copy data from one workbook to another
- Solved: Excel file only to open on designated computers
- My first VBA
- Solved: Can you determine row number from Activecell
- ActiveWorkbook.Path
- Opening CSV-files as new sheets in current workbook
- Solved: enable more options in userform with password
- Please kindly help!
- highlighting precedent cell
- Solved: Sorting
- Solved: Found data in another Column using Formula
- Open Excel and do vlookup.
- Detect Excel Version of a closed file.
- Solved: Sumproduct Question
- Command Bar Control Error
- ActiveSheet.ShowAllData
- Solved: Coloring alternate rows
- Possible via vba to check the datetime stamps on files in a directory?
- Setup column to require unique entry
- Solved: duplicate record count and paste in new sheet
- Populating combo box using dynamic range - run time error 1004
- Error handling
- unhide and activate worksheet based on entry in other cell
- Solved: Understand and Modify Code
- When there is an advanced filter, clear it.
- Solved: Need a tutorial on Array Redim Preserve
- Solved: SUM a range based on user selection
- VBA Security / Encrypt VBA Code
- How to fill the number in the cells.
- How to change the code to search by row instead of by column?
- Fill listbox then update same row
- Thank You All...
- Functions Within Functions...
- Leave only numbers in a column
- [SLEEPER:] Save as csv file format
- Solved: Naming a worksheet for all subs in project
- Solved: Excel Macro Copy cells and pastes them in another sheet
- Selection.OnAction = "macro1"
- Populating an array with a userform
- Search Multi workbook with multi sheet and copy
- Time Calculation
- Solved: Environ("USERNAME") - Can't find Project or Library error
- List of all Application. methods
- [SOLVED:] Close Excel Window
- [SOLVED:] Vba To Fill Web Page Form
- saving tab as file
- Solved: Looping
- Compare Data in two excels
- Solved: It copy one row not all needed rows
- Series of IF conditions
- Trouble with Userforms
- [SOLVED:] Initiate .xlsm file with task scheduler
- Solved: SUMPRODUCT HELP
- Insert empty columns
- Solved: Reading a binary file into Excel with VBA code?
- Change cell color after using copy command
- Solved: Move every Nth cell up without affecting the rest of the columns
- Solved: Splitting addresses into multiple columns
- Excel 2007 automate calendar appointment in Outlook shared calender
- Import xml web page
- [SLEEPER:] Legend.LegendEntries issue - Object doesn't support
- Solved: Copying Data from Multiple Excell Files - Range function problem Help
- Solved: VBA Coding not Updating in Excell Run`s
- Open all Excell files in subfolders without specifying Name of Files
- Passing variables inside the dynamically created form
- Macro very slow while generating output
- [SOLVED:] Save file and a standalone read-only version
- Solved: Copy Formula from cell above and Paste only values: help required
- Solved: Calling a user form
- Solved: Pop Up Window to Select Range
- exclude holidays when calculating between dates
- VBA Check for Duplicates in Multiple Columns from Userform
- [SOLVED:] Controls combobox selection activating WebBrowser control.
- Solved: Color rows based on value
- Help Defining an ARRAY and c00 code
- Solved: Who can solve my matter
- Solved: Search document for words in keyword list
- Solved: Help with my code
- VBA comma method?
- Solved: Find last row
- Reading a binary file into Excel at certain hexadecimal addresses
- Solved: Entering same info twice
- Solved: Consecutive Numbers Define range
- Macro Excel
- Solved: Index for Macros
- Solved: EVENLY SPREAD PICK UPS ACROSS MONTH
- Why runs code twice in case of Mousedown event.
- Solved: Call cell by its name - not R1C1
- can't create object
- Unlock all VBA projects
- Copy Template to sheets
- Solved: Coloring rows
- Dropdown to change between spreadsheets
- Using hot button to export new Workbook
- Solved: Apply dates depend on Month/Year
- Macro to send email with multiple attachment
- Macro Recorder Error
- if workbooks("a") exist and is close, then open it.
- Solved: Comparing Array contents?
- Setting named ranges using a macro
- Solved: Splash Screen with no title bar "X"
- Solved: Autofill
- ExecuteExcel4Macro fails in Excel 2010
- If I put a password on my code is it safe?
- user form without excel
- Sleeper: Filter Languages Charactor Eng/Rus
- Solved: Assign a variable to sheet name
- Solved: Open PDF
- check and fill in the values to another sheet
- Format only the header data for all the sheets in workbook
- Solved: not every cell but every i cel
- Show avarage of cells with zero value in selected range
- PDF to word
- A VBA Question related to DATE
- Using Share Drive/Point to access Macros
- Solved: range
- Opening files simultaneously
- Autofill Macro from EXCEL to WORD
- Renaming the files in all the folders
- I need a macro file that could recognize the same rows With similar data and remove t
- data from all the html files in an excel
- Prefix with "-" sign