View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
[
112]
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Need help with insert text file Macro
- Syntax of this code
- Ignore other applications
- If, And
- remove query table when saving
- Haw can I to create the numeric counter?
- view 100%
- Cell alignment centered
- Excel hang when SaveAs
- excel 2003 xlodbc.xla
- How to control "Date Time Picker ActiveX Control"
- help me out with this - it's killing me..
- Worksheet change
- Access Link Help!
- Code for Access file manipulation from Excel
- Can Excel 97 be controlled from VB.NET
- ChildItems and ParentItem of PivotItem object dont seem to work
- How to display set of record s on the forms using previous & next button
- Help Opening file on network
- Apostrophies SQL from Access
- Removal of empty cells in an Excel table
- Find a match and display a message
- Conditional Test with Text to Speech Output
- Sort multicolumn listbox items?
- Problem with Work_Sheet Change.
- ABOUT MSGBOX
- RecordSet & New Class - Good idea?
- Worksheet().Range(Cell(), Cell()) syntax?
- Grouping Cells with Macro
- retrieve cell value from the cosed file
- add/subtracting date:time in Excel 2000
- Boxes on form. Datatypes error I think
- How to identify operating system user in excel?
- how to update time in corresponding cell only
- How do I set up a while loop for formulas?
- Keep text color from a Index Match Formula
- Copy only Visible Cells of a Variable Range...
- Run a macro always I open an Excel Document
- Forms Toolbar Button question
- Code slows down after a few runs
- Extracting Terms from simple linear equation
- leading zeros!!!! arrrrrrgh! please help
- Returning Values from specific cells in Excel using C#
- logos and such
- type mismatch error
- Easy Question
- Macro with non-static column length (name last row?)
- Hiding a whole sheet in a workbook
- Using SMALL where first two values are =
- encryted data in excel
- Problems using IgnoreRemoteRequests in a shared add-in
- Disabling the option to move cells programatically
- text in forumula problem
- Macro doesn't work when I use Protection
- How can I run solver from a macro button?
- Function working on whim
- Date With VBA
- VBA Newbie stuck
- Remove links to other spreadsheets
- add line during code
- Disabling disable macros
- Workbook "Locked for Edit" Problem
- Recovering VBA Modules
- expanding a start date and end date to show all the dates in a list
- access
- Protecting VBA code
- LARGE
- How to make command buttons move among worksheets?
- range function
- Excel formula pasrsing - BNF, Yacc?
- Recording macro for multiple cells
- Re: Printing Views
- Help creating a macro to copy from one cell to another spreadsheet
- Sort Help for Excel
- Plus sign in front of formulas
- SUMPRODUCT Issue
- Macro to Insert Comment to a cell
- Click Event taking time
- SOMETHING TO SHARE: Encripting/Decripting code
- Rounding up to the nearest 6" increment
- Need to know a workbook is just open
- first column in row
- Help with vb excel macro
- Using a cell integer to select a macro
- Macro to select range based on cell not being blank
- on error exit sub
- Spin Button only allow upwards of the previously saved value
- Timer control in VB available in VBA
- Date format
- Range with numerical data
- Add a Excel's references from VB .Net
- Add-ins
- Please help! Almost done...
- Command Button in Excel
- Can I use a Macro to unprotect a sheet in the workbook?
- ComboBox input
- How do I determine if it is a new file or an existing file?
- Help with "Waiting for OLE Action" error?
- Find out what is selected for AutoFilter
- find all the excel files in a folder.
- Nested For Each Statement
- Application events
- Locked cell without alert
- Combobox Problem
- EXCEL.EXE Application Error
- How do you programically remove carriage returns within a cell
- Looping and Testing Cell Values
- macros
- is it possible to unable the user to add more sheets to a workboo
- run macro on only one open workbook
- excel encrpted
- Date Type Mismatch
- Get the Date
- Print (Manual feed)
- Replace reference inside formula
- Excel File Growth Problem
- help with dates
- new sheet with change of column please
- Adding a worksheet from a date named workbook and save as current
- Automation problem
- SetbkColor doesn't work !
- Using Excel Library
- Überwachung Zellwerte und versandt von mails via Lotus Notes bei Unterschreitung
- Save as txt-file macro
- Find last nonblank cell in column
- Set OutApp = CreateObject("Outlook.Application") - Runtime error 429
- not insert link into history of IE
- help needed with formula or macro or both !!
- ASP: CreateObject("Excel.Application") IIS 6.0 Win2003
- Pivotitems("(Blank)") in foreign language
- sheet tabs and selection
- Add/Change Data validation list
- Textbox/Cell Problem
- Refine search criteria for Find Method
- Debug/Compile VBAProject not available
- can anyone help with copy-finding macro?
- NumberFormat
- How to run a macro (in personal.xls) whatever file (in the listing) open
- no add link into history link....
- Sending mails on behalf in excel
- How to export data to a closed Workbook
- Remove button
- IDTExten2ibility2 OnConnection method: Can't get it to start
- Problems with pivot tables and/or charts
- How to get a macro to work on another worksheet
- Proxy Error (Connection refused)
- Problems using SaveAs and SaveCopyAs
- Finding error messages in a workbook
- feed data in multiple files without opening them
- Comparing data
- Can I make a Macro Undoable?
- BeforePrint Event
- Selecting The Last Row
- BNF for excel formula
- Format Half of a Cell
- newbie VBA help please
- passing a range from another worksheet
- GetSaveAsFileName saves empty worksheet
- simple? Word Bookmarks link to Excel
- autofilter/cell selection problems
- Code Calculation Problem
- Would like to ask assistance in filtering multiple pivots at the same time
- syntax for code in MsgBox()?
- Code equivelent to a key combination?
- Data Validation Drop-Down List Problem
- Palmtop for Excel / Excel for Palmtop
- User Form Formula
- Help me finish my project please!
- How To Turn A Row One Of Two Colours Without CF
- General Cut & Paste Issue
- hiding the column and row heading
- Error In Saving Excel File
- Print If statement...
- autofilter copy to new range
- Macros to Organize the Data from multiple files to one file
- Semi-Complicated Question...
- How to Combine Grouped Records onto one row
- Testing Values of Cells
- need help with "searching" and "end"
- FileNotFoundException
- Binding data to a ListBox without using cells
- User Defined functions
- droping leading zeros when writing to a file
- I have a smorgesborg of vba/excel questions
- Insert value of formula into cell
- range offset
- referencing a column
- Visual Basic: Setting up a button to switch on/off a picture
- Dates
- XL "encountered a problem & needs to close"
- Sum a range with vba
- Calculation
- Replace code
- row select
- Brackets and Macros
- Choose printout color or b/w using vba
- Is this possible?
- How to catch the colorindex in a series
- Obtain Word Doc Info Into Excel
- Tab key functionality in a protected worksheet
- calculation based on row and column values
- Determing a range from numerical data
- drop down problem
- I want a macro that can open a worksheet in a closed workbook
- importing 10 sets of data with a macro
- Cell Formular
- Import CSV to 1 sheet
- VBA and Excel web query not accessing the Web
- variation of 2 rows
- creating a new sheet (back log)
- Shade Columns based on criteria in cell.
- Deleting Worksheet Error
- Excel and Shockwave Flash (Active X Object)
- Algorithm Challenge
- ambiguous selection
- Hlookup
- Convert to Number
- Selecting a column
- How to catch the workbook names...
- Colors overridden in a Macro
- Commandbar not visible in a graphic
- Finding Array Formulas in VBA
- Move Dash
- detecting a tab delimiter
- Copy after Autofilter with no rows found
- Mirroring worksheet contents without using Pastelink
- Squares
- Is it possible to use the MScomm command in excel's VB editor?
- Excel Form Validation in VB
- all
- how to protect header & footer
- subtotal
- Sending E-mail
- creating a list box
- how to create button?
- Copya and paste data pb
- More than three conditional formats
- Replacing a string within a text file
- Positioning MsgBox
- sumproduct
- How do you look for quote marks?
- Use varaible for worsheet name in a formule
- How to replace defined portion of string
- Pass multiple characters to a string variable
- Unprotecting not working in Shared workbook
- PLZ! Help me out with this "killdupes" script
- Editing text in text box grouped within a trapezoid
- how do I protect folders by password
- VBA Counting a range ofhgighlighted cells - before select
- programming a dice roll
- Selecting data from 1 workbook to copy and paste to a 2nd workbook
- Macros & alternatives
- The Run-Time Error 1004 That Wouldn't DIE
- Runtime error 1004
- automatically copy into cells
- Listpro
- index and match
- code question
- File with VB programming wont open
- VBA programming-autofilter function
- How Macro Ask for Variable Input?
- Question about dim statement
- how do I use a macro to center a shape in a cell in excel
- Simple message Yes No...
- Need Help With Active Cell
- Need Help With Moving Active Cell
- Logarithms
- Compile error in hidden module
- Positioning a char in a sheet
- Saving Excel document without macros
- VBA to save pictures from the web to local hard drive
- reading a user-set autofilter value
- Delete empty rows.
- MACRO not working on two different files
- Open Outlook
- select data between workbooks?
- What can I append
- how to make the barcode reader trigger a macro in excel.
- Sheet names in a form dropdown
- User Defined Functions
- formula to only calculate the last 15 entries?
- Certificate Discarded.
- creating multiple line charts
- Help With Conditional Formatting
- How to 'Click and then perform action'
- Filling Column with date
- column headings
- Excel Menu Item for a PC with multiple users
- deleting non-numeric rows
- Borders with Macros
- increment number by code
- remove cells with one digit
- saving Outlook attachments
- Relative Reference Outlining
- Putting column values in multiple rows
- cross-footing in excel
- i need formula help
- VB: How do I find next blank row then add another blank row
- Ruler in Excel
- Rank the Data
- Define name, count rows problem.
- VB: Find blank row then add another blank row
- Using an Excel macro to open a Word File
- Circular reference
- How to show to a form in excel vba?
- need help with formula?
- date subtraction
- Ranges in array formulas
- Generate list from other files
- Protect Excel 2000 Objects
- Diff tool for VBA projects
- Update links to other workbooks while running macro
- Insert Function Problem
- Count filtered data only
- Enabling context-sensitive help in Excel for ADO objects
- Get floating CommandBar position
- What is the best way to protect VBA code
- Need help with a formula
- Using "i" in File Names
- Automatically Hightlight Rows with w/Date Check?
- SendMessageString ...Maybe !!??
- VBA Code Problem
- pocket excel and macros
- Error calling Web Service from Excel Application
- Date problem when opening a csv with dates in dd-mm-yyyy format.
- How do I set the delimiter to save as a CSV?
- Auto changing field trouble
- Copying text from regular textbox
- Prevent a workbook being closed with the X
- Error loading forms
- Re: Help! Searching for text with more than one criteria
- VBA equivalent of GET.CHART.ITEM
- Help! Searching for text with more than one criteria
- Help with vbModeless
- Msg Box to change Macro criteria?
- Bit of help required.
- Position Form on screen v Window Zoom !
- Data validation named range update
- Can a pivot table function like data filter?
- Rounding to nearest quarter hour?
- Can a pivot table function like data filter?
- Fustration Help? Filter, Visible Copy/Paste
- Pivot Table
- Capture Update Links event VBA
- date formatting in excel VBA
- Indirect addressing
- Conditional formatting
- SpreadsheetML of selection
- Code can't locate filename
- form window too small - Help needed
- Coordinates extraction and comparison
- Amending a text file
- File saving
- ActiveWorkbook pointer for Macros from PERSONAL.XLS
- relative cell references
- Checking for copies.. but not an easy one %(
- different colours for different data
- Merging excel worksheets
- Wanna listen to music while surfing...
- Wanna listen to music while surfing...
- Copy a designed worksheet into Word
- A Function puzzle
- Create Combobox Visual Basic
- Position of Chr(10)
- Use static arrays
- *difficult* importing slection from a txt file to new column
- Amend the Code
- How do I select the first occurance of a number in a column
- Save .xls as .txt In DeskTop
- numbers to text
- Automate Send To/Mail Recipient
- Web queries in Excel 2003 not working at all
- Passing variables between Sub and Userform
- Excel paper setup
- VBA Declaration problem
- Macro-Button make tu hide?
- Scaling for printing
- Zoom via Macro for WorkSheet to activate?
- Wrong number of Arguments or Invalid property assignment
- Help with multipage+chart urgently needed and very much appreciated!
- help with an event driven sub argument please
- filecopy
- Your expert help required pls.
- Extracting from 1 cell and placing extractions in multiple cells
- Check for Hyperlink
- Find the Sunday with min value
- open up an excel program with an auto open macro
- worksheetfunction.sum error
- listbox value to a form
- Firing Click Events with Accelerators
- sheet protection
- Removing blank rows
- Remove HTML links in excel
- VBE With Maicro Security
- How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
- Macro security
- Link submit button to another worksheet
- put worksheet values into textbox on form
- Copy folder and paste to another folder
- matching values and inputing value in the adjacent cell
- How can I add values in 2 cells using a command button
- How can I add values in 2 cells using a command button
- message box transient -sub by Chip Perason
- How to copy 30 csv files from a folder to another folder
- Issue with 'Left' in macro
- Matching Data on different cells
- Rename a new workbook
- Trouble comparing to subtotals
- Linking Dinamic Cell value into another sheet
- Paste text into a header
- cell change
- performance question
- vba for countif
- Events... Changing the Interior Color
- how to check that a var type date is initialized ??
- Auto Add Control to Worksheet (to edit data)
- Problem with range and autofilter
- Add_Ins
- Heavy/Slow Calculations
- Compare Master Account List with Partner Accounts
- Graphics question on Excel VBA UserForm
- Macro
- Proper way to write a conditional statement with ands
- NewIndex for ListBox?
- Chart
- Range selection
- How to open Excel file from PowerPoint?
- if and else question
- Exporting to txt file, how to insert a "Enter" between lines
- Stopwatch In Userform
- which function i should use?????
- copy / paste
- Merging cells
- Check to see if excel file has been saved
- UserForm
- Formula to sheet change
- Excel Macro Programming
- close file macro
- ccard 6 or 16 digits
- Format column to have different decimal places
- Printing from listbox
- Selecting OptionButtons
- Cell reference to userform
- Multiple Workbooks
- Can't delete macro
- Solver Issues
- Formula help
- Rearrange columns using VBA
- Use Subtotal Function
- Data validation in 3 cells
- macro to email
- macro to email
- Toggle Columns
- declaring Arrays to use in a Form with few modules
- UserForm
- mixing of vba and sumproduct
- Excel 4 Macro Recorder
- How to get system login name
- How to get system login name
- lookup physical first worksheet
- Date Formatting
- Subject: how to calculate time in a payroll worksheet- Revisited
- Hide individual/range cells and temporarily increase scale for printing
- Need macro that will BREAK a running macro
- Help! How do I Auto-Update?
- referencing the active cell
- Printing form & contents
- Simple assignment question
- Macro to copy sheet(s)
- Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
- counting and loops
- Test for fractions of a penny
- key press event?
- Deleting A Worksheet - There may be data ...
- VBA Code to access the ACT! 2005 data bases and tables
- stock quotes in excel
- show duplicate rows in a pivot table using vba
- Deleting a blank sheet in a workbook
- Auto filter formula - help needed
- How to plot missing points
- macro to find numeric data & move it
- Tie 2 or More Modules Together (vba)
- Delete bolded items in column
- Return last column of dynamic range
- Determine last clicked object / control
- Question About customized menu bar
- Formula for Filter
- External Links Memory Error
- I need help Caculating Zip code Distances
- Weird... type mismatch only half of the time
- How do I group data in an Excel Combo Box
- Re: Ado Filter ?
- Excel treating text as function
- functions & range vars
- Excel 4 Macro Help File
- Fill Color Rows of Varying Size
- interacting with MS Access
- Locating min/max number of x adjacent cells
- Find next cloumn
- Interfacing with Oracle 8i
- exiting program
- Properties of workbook
- object error
- Writing a Date Function
- web page and excel...
- sort problem with first row
- adding two ranges
- Displaying A MsgBox for X Seconds
- Excel printing
- removing date from field
- I don't want to see what a macro is doing when it's running
- SQL Database Query
- Help on Codes for Accumulating Figures
- Printing
- Speed-up a macro!
- Project Window in VBE not displaying items grouped properly
- Excel 2003 does not calculate automation add-in functions automati
- Re: create a copy of a sheet and insert it into the same workbook.
- Filter Copy/Paste Fails - Two Ranges Selected?
- create a copy of a sheet and insert it into the same workbook.
- VBA column counts
- Disabling the standard X-Button?
- Word Search in VBE (True/False Solution)
- Easier Sorting
- Checking External Sheet References in formula
- User Defined Function
- Function Counter
- Handling Combo boxes...
- John Walkenbach Color Palette (Repost)
- getting row and coloumn info from listfillrange
- Using popups instead of Message Box
- Timeout
- Getting timestamp from a file in Excel
- creating a Help tool thingy (msgbox?)
- Variable ComboBox on Userform
- data validation
- formula in vba
- URL string, pulling in Stock Data
- row sum - 9 cells change values to 1 and add the "1"
- Development considerations for Win XP
- Save method and BeforeSave event
- How to Auto Filter Even and Odd Numebered IPNums from huge collect
- Detect which shape was clicked....
- How can I duplicate a user form and all code?
- ScrollBar object
- Help in Table Macros
- importing worksheet via code
- Setting a Constant when creating a new file from a template?
- MsgBox "Invalid property value"
- silly (?) problem defining ResultRange
- Help to get values from 3 option button in one cell
- Seting a Constant (via code) when creating a new file based on a template
- Sort Column B against Column A
- Re: Question about links
- Re: Range.Find skips the first cell ??
- Re: Macro fails after screen is locked or screensaver becomes active
- Re: Range.Find skips the first cell ??
- Re: Ado Filter ?
- Data Area in Excel 2005
- Loop until a unique worksheet name is entered
- User Forms and Excel Functions
- Inserting "template" rows
- Re: Question about links
- Web query on Open
- Request assistance with cross sheet problem
- Re: Subroutine vs GOTO "On Error"
- Copying Custom Toolfaces
- auto_close and removing menus
- range function
- Help 'Number Stored as Text Error' !!!
- Help me modify this VBA code please:
- Retrieving cell formatting from closed workbook
- Recording simple Macro
- RE: Subroutine vs GOTO "On Error"
- Protection problem...
- RE: Subroutine vs GOTO "On Error"
- using a For-Next in a module and a Form
- Date Subtraction/Time between Occurences
- print screen
- How can i attach active workbook to email- please see the macro
- Current Month
- range division
- Re: Range Question (very simple)
- VB directing IE to a local site's html page
- Awkward autofilter question (URGENT!)
- InStr
- VBA Post
- Creating Status Report like Microsoft Project
- Automation and multiversion of Excel
- Simple Question (for you wizards...) please help
- how can i adapt this formula?
- cutting and pasting ranges using offsets
- Union over multiple sheets
- UserForm
- how to hide the "(All)" option on a pivot table
- using worksheet functions in code
- Searching for Duplicates across columns and print to new column
- still stuck: get filename from range
- How to inserting text in thos email macro
- VBA Date formatting and locale
- Inserting Dim'd Name Between Letters?
- Hiding rows if...
- functions
- Open files, skip a folder
- Find subtotals of 160 each
- Help needed with the following macro
- Repeat series of formulas - REVISITED
- Format multiple pivot tables
- Pasting embedded OLE objects to specific filename
- get file name for FileSaveAs
- Open files
- Problems with a method form multiple worksheets
- John Walkenbach Color Palette
- Stop directory & folders changing in link when moving file
- Sorting based on the first column of a defined name range (Unknown)
- VBA Code to name a variable range
- universal code
- Return the row numbers or a dynamic range in VBA
- How to strip dashes out of numbers in a variable
- Sum only visible cells within a range.
- sum cells using command button ADD
- Cell wont calculate automaticaly
- This is not strictly excel, but I am running it from an excel macro
- Retrieving cell formatting from closed workbook
- Macro for saving file on Auto Date
- Formating cells
- printingstatus
- delete the hyperlink linked to the organizational chart in excel using vba
- Macro to Lock Columns
- Web Query Questions (2)
- Wildcard with constant
- getting information about a pivot table
- Cell wont calculate automaticaly!
- price and yield functions
- TextToColumn Split
- Error in Loading DLL
- Formula for last numberic value in column
- macro to merge workbooks
- (Leo) Strange print to file behaviour
- Trigger Event Code
- Protect Rows depending on Values in Particular Columns
- Wildcard
- (macro, formula,...) To Copy columm in various sheet's
- Recursive Function + File searching to return path
- What version Excel file was created in.
- Transfer amount into next column with condition?
- Array as output of function
- Automation Error ... Urgent help needed
- calendar
- Copy Method of Sheets Class Failed - after many copies
- Moving amouse over controls
- Alternatives for Sumproduct?
- keypress on a userform (with code)
- Find out which cell that called my function
- DR watson
- Re: Blinking Cell (Worksheet restarts)
- UCASE problem
- How to copy selected listbox item to sheet
- Newbie Confused...
- Re: Pbl calculating US$ values
- Variable for column selection
- Hide all PivotItems except for a specific Item
- Macros with switches
- is this possible...
- pivot "fields per column" setting
- Exporting to a closed workbook
- Guardar .xls como .txt En Escritorio
- Using a macro to work from Excel to Outlook
- Excel Menu help!
- Why doesn't this work in Win 2K?
- get date from calendar in dialog box
- Help with file open and data organise macro
- What library is xlLocationAsObject in for use in VB.NET?
- InputBox drop-down menu
- How can I know if Excel supports the fileformat constant?
- Detect which shape was clicked?
- Setting Column format as text
- VB for Excel/Foreign OS
- Creating a budget from a list of transactions
- Copying data from multiple sheets into one sheet
- Use Macro to open "Find" window
- Application.FileSearch crashed Excel in Windows 2K
- Use a Macro to Save a Copy of a Workbook?
- inconsistent size progress bar
- Error 1004 from worksheet activate procedure
- Activesheet <> Sheets("Name")
- Sending keys to DocuCom PDF Driver
- RE: Login System
- Setup Excel to autosplit one cell into two
- Named Ranges
- Re: Login System
- Macro to have user enter new worksheet name
- Selecting a defined Name via a cell's contents
- Wildcards in Advanced filter criteria don't work with Excel 2003
- Command Button Hyperlink
- XLVERYHIDDEN
- Information Rights management
- Graphs
- Dates not including weekends and holidays
- UserForm
- importing into excel
- UDF not returning correct information
- How do I create a list in excell?
- extracting a number
- Insert a row then copy a transaction
- Getting the source name of an OLE Object
- Toggling Display as Icon for OLE Object
- com add-in
- How to select columns using column index
- Excel automation question
- Selecting text only
- Saving and Closing multiple files and Excel program
- Use ADO to copy a graphic to Access from XL
- Macros Security
- Changing DATA VALIDATION box color.
- Add-Ins
- Installation of "Add-Ins" in code
- Password Protect Worksheet
- Excel Column Width Units
- Selective Mailing Of Attachments
- Time Userform
- addIn functions in automation
- Visual Basic code to find next available (blank) row in a spreadsh
- Help with function that crashes Excel
- Worksheet_Change with discontinuous cells
- Validate cell when contents are pasted into it
- "on error resume next" NOT working...
- skipping one row several times over
- Enabling sub menu items via vba
- Macro update
- Autofilter
- Password Removal Problems
- How can I make this simpler?
- The "Like" operator.
- get_Range Restrictions..
- My errorical understanding of Error handling
- how to control the "Save as type"
- UserForm Help
- Multipage Control Pages - Changing Index Value in Code
- Why is my digital signature is being discarded?
- Multipage Control Pages - Changing Index Value in Code
- printing to a pdf file
- Looping through files in a folder
- Custom Calendar Format
- Code to save spreadsheet
- Problem sorting a single column in a shared workbook
- PANTONE to custom color
- Delete rows with different criteria
- Excel HTMLProject replaced on RefreshDocument iages lost
- module related
- Repeat series of formulas
- Perplexing sheets.
- HELP PLEASE !!! Replaced HTMLProject for sheets but Images were lost.
- Dim Line Labels?
- Excel replaced HTML Project but Images are lost
- Closing Excel
- Function to capture the time a cell changes
- macro equivalent to arrow keys
- CommandBar
- GetPivotData with column grand totals
- How to show the maximize button
- Hide Excel Menu From Screen
- vba date function
- macro editting
- Send graphic to Access?
- HELP! - Printing a sheet with values populated from dropdown box
- Command to bypass the asking to save option
- Sudoko
- remove hyperlinks from objects in the excel workbook using vb
- Between to values
- File size...
- Programmatically reading data field values from PivotTable
- Stuck
- Changeing codename of worksheet via VBComponents collection
- Program 2 shapes
- Deleting data in userform and database
- Custom Classes and Cans Of Worms....
- save custom data in excel
- Macro to insert Current Time into protected cell
- I Need Help To Do This Code In A Macro
- Multilanguage translation
- Creating Option Entries in Excel Menu Bars using VB
- Displaying the result of a formula in a text box
- New Menu in Excel
- Code for Advanced Sort
- Attaching excel in Loutus notes
- Loop through for condition and input in adjacent cell
- Advanced Filter...
- Centering a Shape over a given cell when resizing
- Command Line Arguments
- copy formula
- How to make sure a Cell is within the current visible window's ran
- Help! How to get all the command's captions within a CommandBars?
- Explanation needed for CopyAllModules code
- Excel AutoFilter using ASp.net
- paste special/values can be very slow
- variation to code needed
- change macro wih macro, is it possible?
- Require Workbook to be renamed in order to Save It
- Sub too large
- copy worksheet
- Excel 2000 vs Excel 2003
- Setting a value in an add-in
- Disable hyperlinks
- help with arrray formula
- problem to create a line graph
- Name of running sub???
- A macro that copies and pastes autofiltered cells will fail.
- Filling cells via code..
- Time Format Input question
- Code that ask user for a password before it runs..
- Application.Calculation = xlCalculationManual mystery
- SHELL to open an application and pass parameters to it
- Validate an email address
- command button
- File Input Question
- Save If Condition is true
- RecordSet object - Cannot get help file to display
- Sort the Tabs
- flash drives
- Copy Contents of 3 Columns into 1
- code to run another macro?
- Can anyone recommend an affiliate tracking program?
- buttons on InputBox
- How to create dialog boxes
- Need help adjusting my code:
- Test for dups in Array
- how to close a form in vba (not hide)
- Macros disabled
- what is the Excel macro command equivalent to "end up"
- cell selection
- IF FUNCTION Trouble
- worksheet.activate not activating
- protect with password
- Compare Cells
- Using Web Queries -- unusual problem
- Scenario If Date is greater
- Change Event on a named range
- Calendar Control
- scrolling a sheet with vb
- Repeating rows at the BOTTOM of the page
- Excel 2000 Solver Problems
- On Error Issues
- Worksheet Navigation
- On hard drive, how do I restore .XLS prior to last save?
- Why code work in 2003 but not 2000?
- How do I FILTER this?
- Spacing Macro
- Duplicates
- Excel and Word Bookmarks
- Function with results in offset cell
- Copy between variable workbook names
- Input Box problem
- The column return value?????
- Looping through Worksheets
- Determining the height and width of Print_Area in a closed workbook
- Pass worksheet to macro as a parameter
- A simple question
- Excel 98 not functioning properly on formula
- Re: Moving to a different cell automatically.
- Opening a Word Document from Excel - ??Stumped??
- Missing Cell in a column when it is on row 16
- Moving to a different cell automatically.
- Save value on form
- Move page breaks programmatically...
- Find and Replace in Formulas
- Excel function
- MsgBox with Timer
- Make an indexer at rows for many txt files.
- Count number of cells in a range with amount > 0
- SQL CASE statement on EXCEL VBA
- select first non blank cell
- Cells formatting done without me allowing it in VBA
- Placing triangle symbols WITHIN cell for significance testing
- Next For looping in a If
- Date Format on Form
- (Newbie) Copying values from an array to the worksheet
- CountIf question
- sum on a variable range
- Mailing single rows via button
- Solver macro
- opening ftp-file from macro
- updateLink; files with passwords , VBA help!
- tidying up code and refering macros
- Preventing Users From Locking a Shared Network Add-In File
- Search and copy macro
- VBA error: Unable to set the Values property of the Series class
- Merge an entire row
- Counting survey responses
- Help! Is it Possibe to write UDF(custom formula) inside sheet
- Scannig number of rows
- Use Parenthesis in Filenames - workaround??
- Selecting multiple text boxes
- VBA English-Spanish
- Data correction
- Script question
- count up the occurences of non continuous value
- Help for a macro change cell colour under many conditions
- User form/spread sheet
- Custom Class and Properties
- Problemas with function Format()
- Remove the filename when assign a macro to a menu command.
- Looking at previous columns
- way to run sub after user exits textbox
- How to trap the worksheet_BeforeDeactivate event?
- macro for paste special values in different location
- Auto Editing the Row source.
- Visual Basic - Macros
- Update custom formulas automatically
- Problems with DATE data type
- Worksheet_Calculate problem
- Reload Listbox - type mismatch error
- running private sub
- Making rows variable
- Insert Character into Editing-Cell
- Can a macro be triggered when a cell is selected?
- Help with deleting rows where the value of the first column isn't divisable by a certain number.
- remove routing slip
- Code for Registering Add-in
- how to delete a chart using code?
- Count quanity of values in an Array
- Forest & Trees????
- Testing an unopened (or opened) worksheet for VBA Project protected
- Timed Message Box
- Write value to an Excel VBA variable by reading Access DB?
- Deleting a sheet via code-- different criteria
- macro running problem
- Problems with Paste
- Advancedfilter returning all rows instead of ones that match crit
- Select failed?
- Font Size on Forms
- Problems with ChartObjects
- Macro to select rows based on a value in a column
- Checking for security level to allow macros to run
- change font size in excel vba
- Routing / email
- Excel User Conference, 2005 - Ft. Worth, Texas - Sept 16/17
- ActiveWorkbook.Close (False)
- Printing only a selected area
- Find Autoshape
- how do I transfer information from excel to an existing word document using a macro
- Prevent Autofill from changing protected cells formatting
- Select Method Failing
- Deleting a sheet via code
- CommandButton Failure
- Some sort of a For Each loop??
- Arrays
- Need help with dates
- dll reference
- look up syntax
- Controls in a Worksheet
- Split or copy records n-times as excel scans the value of a colum
- How to make Pulldown menus
- Re: HELP! What's wrong with my code?
- copy row
- Problem with cell value
- HELP! What's wrong with my code?
- Output Text in specific place
- Individual Page Selection
- Save .txt file to .csv in VBA
- VBAProject Properties
- Search Text in Comments
- Creating Sheets in VBA
- HOW TO PORGRAM WITH EXCEL?
- color selector
- Determine Column
- activeX dll
- automatic printing / print report FIXED
- macro to paste certain cell formats based on wksht name
- find "closest" match
- Inserting Excel Range into Word
- If statement not working right
- Iterating through cells, comparing values
- Help on Excel data auto generation of graph
- Set up contract expiration dates program?
- Forms Textbox and Assign Macro
- If Then Help!!!!
- hide save as
- Array Question I think
- Help with listbox control events
- UserForm Popup Menu ?
- How to perform action in all worksheets
- Finding two variables on the same row to match function
- Frame on spreadsheet
- sorting a large selection
- hide columns from find
- Printing order
- Accesing Word Document from Excel???
- Change BackColor
- last column of a row
- Run macro when worksheet is opened
- Workbook name
- How to stop warning message when opening excel file in IE
- Random Selection
- Starting a Macro when Command is Executed?
- Object variable or with block not set
- macro needs to reference cell values in different worksheets
- How do I make specific columns Proper or Caps?
- Looping through my worksheet and copying cells
- grouping
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.