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 |
- Code To Insert Cell Reference
- digital signing for authenticode
- Addin Close problem
- Custom menus
- activesheet paste error
- Vlookup of VBA Array
- RE: quarterly reports
- problems with userforms
- Import Access data into Excel - Looking for programmer
- Matching sheet name to value in cell
- Automation of Excel to perform simple tasks on many workbooks.
- Format cell to uppercase using code
- xla with password.
- Public Functions As Worksheet Available Functions
- Looking for a convenient source of VBA expressions
- .End(xlRight)).Select Doesn't Work
- select block of rows w/data between blank rows
- Formatting a cell
- End If
- Range Names - help
- disable X button in main window
- order number
- 2pcs of code, a button & a checkbox
- Referencing same cell in calculation
- Combo box
- Extract values from certain Cells to a Master Worksheet
- tried to change my code but cant get it to work.
- Small square in the cells of CSV files - Text to column
- New
- VBA code
- Automatically Insert Text Into Macro
- Fourier Analys
- activating correct worksheet
- "Translating" values in a cell
- Re: last digit
- Retrieving Value
- Userform with 2 Listboxes
- Excel 2000 macro Assistant.NewBalloon
- RePost - Calling a Macro from a key
- How to loop through controls on a MultiPage
- Help with Solver & VBA ?
- eliminating zeros
- Macros
- date formula
- Any experience connecting Excel with a terminal emulator
- Password Protect Directory
- I NEED A SIMPLE IVOICE
- Type mismatch accessing variant array too many times
- Automating Modification of a Cell Link
- Re: Msgbox delayed using AFTERUPDATE
- excel charts
- Creating Pivot Tables inside a Macro
- user form and frame control
- function and combobox
- IIS, Excel, client server Excel... what direction to take
- another listbox question
- auto run macro
- Automate multiple series line graphs
- Disabling Row Select from Header
- Querying Data from Secured Access Database with VBA
- list boxes
- Inserting time into cell in excel and have it not change
- PivotTable using Named Ranges
- Attachments
- vba filter dates
- Can't Exit Design Mode because CommandButton2 cannot be created
- help with web query
- Maximum Number of Bloomberg DDE Links
- Filling a cell with today's date (Datestamp completed marco)
- ToDo utility in Excel VBA?
- Does VBA round .5 up or down?
- Search Cell Address and Cell Names in VBA Editor
- bad arithmetic
- Control to Choose Row and Column in spreadsheet
- Function limitations?
- Detect Custom Menu
- Re: Updating Column
- Send Mail question
- Execute on Cell Change - Problem
- Calculating Minutes and Time
- chart
- Using formulas in Excel
- Autofit of Row Height with Merged Cells - AGAIN!
- User forms in Excel
- Multiple Occurences within a range
- Removing every second instance of comma sign
- Using Trendline Formula
- UserForm Viewing
- Workbook_Open() problems
- Re: Dir("D:\") refresh problem
- Re: sendmail macro help
- how do I import macros from other users
- OnTime method
- Application Run Time Error 1004 and Stack Error
- Re: quarterly reports
- "Type" statement and arrays
- Re: Formula that referance a Cell
- Re: how to stop "On error resume next" ?
- i sent by mistake
- Beep when Messagebox is displayed
- Looking up two variables
- Input box used as password input
- Select Until Empty Cell From VBA Code
- Select a cell
- Move an Excel macro to another Excel file
- Calculate on Status Bar causing VBA to run very slow
- Why get Ref in my cells ?
- Import Text file
- shortcuts to excel files.
- terminate a runnig macro
- Code behind worksheets
- Frozen Status Bar upon Errors
- Re: Get range value active workbook on open add-in
- Autofill
- Re: Workbook_BeforeClose problem
- Increase macro speed?
- Select Case on a range - problem
- Problems with BeforeSave and Application.EnableEvents = False
- ADO recordset error
- Re: Excel Charts into Powerpoint
- reference to cell left of a cell...
- How to know whether it is using ADO ?
- Time Code
- trying to find random drive letters
- Copy/paste range without resizeing cells
- Re: last digit
- RE: computing ratio for samples with many subrecords
- Renaming an Excel file using a macro
- IE in Excel with intellisense
- Re: Closing Excel within itself
- Write Procedure With Logic Test To Open File From Given Directory
- RE: last digit
- Language
- HELP WITH CODE
- Erroe on Geting External Data
- Running code from list
- need to remove last few characters from data in field
- How do I sum hours from multiple workbooks?
- Can we use "*" to replace string in VBA excel macros ?
- Code to trigger drop down-select event
- Obtain value of a control on a shortcut menu
- Cell 255 character limit & VBA
- Delete Rows on cell content?
- Any takers?
- don't find my message : connect to oracle db (4.2. 19:39)
- Suppressing events
- RS232 to Excel woorksheet
- Lookup in VBA Array
- mouse position in EXCEL
- Merge rows with similar data
- Dave Peterson
- Tracing and reassigning macro short cut keys
- Calling a macro on a remote computer
- Add-in Asking to be Saved
- Button Control Jumps Around
- Select and Move based upon keyword
- Automation Errors
- How to trap automatic link prompt when an excel file is being open
- Trimming Email addresses
- Run-time Error "13" - File Type Mismatch
- Select Case with Text
- VLookup problem when a new row has been inserted
- data validation cell
- Change Event Track
- validation cell
- hyperlink to a button
- Convert net tons to long tons in an Excel Spreadsheet.
- Copy Method of WorkSheet Class Failed!
- How to consolidate/sum a list
- Shortcut Menu With Toggle Control
- How can I get a larger list height for a combobox while drop down ?
- XML creation via a macro
- File Always Asks "Save Changes Y/N" even when no changes made
- hide or unhide pivotfield using a checkbox
- help
- Button to stay on screen as you scroll
- Select numbers between two numbers...
- OWC Spreadsheet focus
- Run Macro
- Problem running code behind a userform
- Find the zero(s) and remove from a concatenation
- Default column separator
- Check for an item in a collection (without looping)
- For Each Loop with Exceptions
- MSChart.chartdata + Excel Names
- Function or VBA required to extract cell info from an unopened fil
- Open a Workbook
- Generate Random Number Table
- Macro to combine data in a column
- critique my project
- VBA protection
- Need help with VBA
- Need help with FORMULAR1C1 property
- test
- user form and frames
- Populating a select group of cells with randomized names...
- Msgbox delayed using AFTERUPDATE
- Help!
- Make a Fresnel Zone Calculator
- Time sheet
- Formatting SUMPRODUCT
- making drop downs "volatile"
- Passing a range into a VBA function
- dynamic named ranges
- Convert Text Column to Date?
- Docking Project Explorer Vertically
- Absolute vs. Relative Cell References
- How do I create a formula
- Event question
- Reported problems with Office 2000 Service pack 3
- Drop down list disapear
- Reference to analysis toolpak addin
- Personal.XLS MACRO Workbook
- HELP! Sh as Worksheet
- Size of worksheet
- Financial Calculation: Return on Investment
- add-ins
- OFFSET and SUMPRODUCT
- Renaming Worksheet Error
- Recording a macro within existing macro.
- copying deleting in excel vba code
- copy photo
- Export table to SQL
- Use of public variables vs. passing arguments
- Unable to embed control - Microsoft Map is no longer supported?
- saving blob
- Pasting from Excel Clipboard with VBA Macro
- QUESTION with Match command and OFFSET
- Prevent Excel VBA Code from being Interrupted
- Private Sub Running Other Private Sub Inadvertently
- Moving data between worksheets in VBA
- The Web query returned no data
- Add-In
- UF within a loop
- Worksheetfunction help
- Please help with do while
- Programatically sending a sheet through Outlook
- winsock lag error
- Can I have an array of arrays and access an element simply?
- format cell in excel as to convert any numeral into words automat.
- More than just time
- Listindex strange problem
- Refer to selected cell in custom function
- How to prompt user to set password that protects their worksheet?
- algorithm creation
- Public vs Global
- headings in a combo box
- Combo box column widths
- I want to combine a "match" command with a copy and paste command.
- Round number to 5
- Macro Excel 2000 do not work in Excel 2003
- Open a specific file
- Wondering why the following ADO connection to Access isn't working...
- Calling an excel spreadsheet from within a browser
- Need Help Please: EXCEL+Vb Programming Newbee Question
- What Causes DSUM to Report #DIV/0!?
- advanced filter
- cells automatically colour differently with 'what if' scenarios
- Re-formulating the problem: Dynamic Button Names!
- Set a Reference to a Type Library
- How do i insert lines into a worksheet depending on if data exist.
- easy problem for programmers
- Comditional Formatting Problem
- How to transform float to percentages within an array?
- Colouring Stuff, Toggle Buttons
- Fix column widths in Excel template
- Button to allow a search
- Row color change
- Date Format Problem
- Manipulating embeded exccel in word
- Type Mismatch Error when running a SELECT SQL
- Delete Line Macro - IF Function
- excel macros running slow with XP
- auto refresh
- Trapping NO selections
- Type mismatch error
- insert variable number of rows
- Workbook activation code
- link cells
- Toggle Buttons
- For...Next Question
- Default browser for web querys?
- Start macro by Command Button?
- Time Calculation - How long a macro takes to run
- User created control for use in Excel?
- IE not detected
- Can't think tonight - for a friend, can you help?
- Function for summing values of a field by date criteria
- To read from an Excel sheet using simple ASP
- printing
- Network activities while runnung macros
- trusted source/publisher
- Visual Basic commands for email
- how do i use the excel function search in excel vba?
- Put text on clipboard?
- Saving file
- Comments in cell (try #2)
- Better way....
- open Goldmine email msg from Excel VBA
- Assigning values to words, then referencing them in a formula
- WS formula for Julian date not converting well to VBA??
- Excel 2003 Memory Leak
- Macro, if then next
- Custom Worksheet Header
- Function in another workbook
- roster
- Loop a macro
- Format As TIME In A TextBox
- Question about Excel
- ODBC imports numbers as text
- changing value of a list box
- Offset.Value
- populate a validation List?
- filtering question
- OFFSET in Excel VBA Function
- querytable connection
- Suppressing or turning off the Printing dialog
- Creating a toolbar for my add-in
- Dynamic Button Names?
- Picture resizing
- Report--anyone???
- Email/Excel Website diff. methods
- time problem
- In excel, I am trying to copy a column to another sheet automatica
- Delete String Element
- Can Cell X be modified by Cell Y?
- Using SUMPRODUCT in VBA
- Running an excel spreadsheet from a website
- Clearing objects in a VBProject
- RangeSize set by macro
- Row parts and range confusion
- macro stop before end if I use a shortcut ?
- Adding additional rows in VBA based on character strings
- Photo in a sheet
- Re: Copy cells without splitting column
- Copy cells without splitting column
- non-duplicated values
- Using .Find with Hidden Columns
- Shell command ignores parameters
- IsNumeric Test
- Copy Sheet Limit
- I need to execute the SQL.Request with SQL strings larger than 512
- Speed up code
- Getting a File Date & Time stamp
- Too much for Excel?
- Format A TextBox For A Phone Number
- Adding custom faces-icons to toobar buttons.
- install a macro for all workbooks
- Message Box Pop-Up
- To Read from an Excel sheet
- Copying formulas in a column
- Run macro in another workbook
- Excel file gets corrupted
- Search and replace for non printable characters
- Stopping Display Alerts
- Automatic timesheets
- Weighting random allocations within a range
- Buttons work (but don't work in a cell)
- IE not detected
- Custom button starts new instance of Excel
- Formula in loop stops working
- PasteSpecial Paste:=ColumnWidths
- How do I stop the cursor from scrolling?
- Programing cell comments
- Using A Macro To Add Event Procedure To A CommandButton
- Detecting a printer is connected
- Copy sheets
- Add In target directories
- Insertline Macro
- IE not detected
- macro - how to make working for colums D:X
- How To Imoprt Text File With No Delimiters?
- Calling a macro from a key
- Averaging specific data in columns
- Time
- List valid values if a condition
- How to transfer the length of one column to a formula in Visual ba
- Please help to correct syntex error
- MAKE WHEEL MOUSE WORK ON USER FORM FRAME WITH SCROLL BAR HELP!!!!!
- I don't get it, Whats going on here?
- paste image into a form
- Password
- Question about multiple data sources
- Renaming a cell name
- Distance To Margin
- Re - Excel Loading Multiple Instances to Trigger Events amidst Switching-from-One-to-Another
- a macro that launches another workbook automatically
- Pivot Table
- display contents of a worksheet in a form/frame
- Test if Cell is Empty or Doesn't Exist
- Workbook_Open
- MsgBox Syntax
- Format a txt box.
- How to prevent routine from running on certain sheets
- copy worksheet to new workbokk & save
- Macros
- Evaluating a Sting in VBA
- change directory for refresh data
- Range name as varible
- % Formated cells randomly changing to hh:mm:ss format
- vba coding for formula in cell
- Help please
- how do i write a macro to automate some scenario/what if modeling
- Missing functions and commands
- vba code
- Formula Replacement
- maximum days in a month
- Need VBA assistance for Excel Open Dialogue Box
- To Bob Phillips ( Filesystem)
- Message Boxes.
- Open file - How to test the path ?
- Function behaviour, can someone explain please?
- Date and day
- Can I add a description column or alternate column in a validation
- How do I populate this list
- Adding a Chart or Worsheet??? with VB.NET
- Updating an Add-in
- Problems with R1C1 referencing in buildling indirect references
- Counting how long a Macro takes to run
- function trouble
- How can I export cell content in Excel to a text file?
- Delete a Worksheet
- Looping through Worksheets
- Custom date formats
- Insert variable cell in the formula
- regarding filter
- Move down one line
- Linking to hyperterminal
- Code to Send BCC
- How to set Axes Min/Max values in C#
- Counting cells in a schedule.
- Setup a macro to select a specific column within the same row
- splash screen macro problem
- Beep or Make Sound after Calcing
- Finding column again
- Table Caption
- Dim as CommandBar Does not Work
- Update Complete Message
- Conditional formatting with imported data
- Outlook and Excel
- Changing a Macro
- Getting value of an Autosum
- Addin Menu Question
- Counting CheckBoxes on a Userform
- Count Rows
- Merged cells numbering
- Checking the number of files in a folder using VBA
- Application Error 1004
- User form/ to show please wait
- Menu Issues when creating an Add-in
- Check sheets name and open goto workbook
- Formatting text in a a cell with selecting it.
- Can You Change A CommandButton Code Using A Macro?
- Create User Defined Folder
- how to get rid of selection of cells, after pasting
- Error exporting data
- Embedded chart along with DATA to powerpoint
- Coping dates
- Copying an Excel Graph to PowerPoint
- User Form - frame scroll with wheel mouse and cut & paste from tex
- Preventing screenupdating from modfiied
- Sumif Help needed
- Re: Frank Kabel: A Sad Day for the Excel Community
- How do I link the spreadsheet with data in MS Money 3000?
- Is anyone having problem with Excel 2003 Application.ScreenUpdatin
- AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED
- How do I stop duplication of cell data from a list (you can only .
- Re: A repost - Permuting SPACES within a String of words
- Dynamic copying & pasting of rows
- Web Query Query
- Change color depending on cell value
- Find the range of a SubTotal
- Excel Start-up parms
- VBA/Vlookup with workbook defined in a variable
- is word really smarter than excel?
- Formulae
- How do I determine if conditional formatting is applied to an exc.
- auto start filtering
- Error in code re case construction
- Nesting ,Ands
- ListDir
- Lookup/Progamming Help!
- Extract formula from Text box
- vba 2003 cut copy animated border
- Hidding macros
- Getting info off the Web into my spreadsheet
- msg for ron
- Export Excel Data to an Outlook Email
- overflow error 6.. the macro just stops any idea why?
- excel freezing
- messagebox problem
- find highest number then select next cell
- Networkdays
- How can I set up a page tracker?
- include empty sheets
- creating a collection of Sheets references
- ontime method?
- ontime method?
- Excell 2003-How Do I get custom drawn shapes into Autoshapes file
- How do I write a macro copies a column to another sheet but that .
- New to VBA
- Some help w/ simple loop, please?
- Clear then move text up
- Button flicker with screenupdating
- skip empty sheets
- Regular Expressions in VBA?
- count non-empty rows
- If statement
- VBA Equivalent of ASP 'Execute' Command
- How do I enter Unicode characters in Excel?
- Macro asking for input
- Changing Text in PowerPoint
- conditional reset
- Redesign for hitting limit argument in a UDF
- Copying a range of values between worksheets
- Protecting non contiguous cells
- dialogue box problem
- construct range?
- Lookup Outlook Contact to Fill Excell Cells
- how can I add a print dialogue?
- Select file after GetOpenFilename
- Userform1-Can I override the need to click on the form?
- Using 'On Error'
- Check rows for duplicate references and add related data
- Why is ActiveX invisible in Design mode
- how to reset a value in a cell after another
- how do i auto date a page in excel
- Calculate Number Attending
- Insert Row Condition
- Change cell formula & assign to VBA variable...
- Naming columns
- Extracting Custom Menu Code
- Automatically Replacing existing file on save
- Best options for importing text file
- Find a String in a Cell
- excel and access melded would be a wonderful platform for medical.
- Online VBA Training
- names changed somehow
- Using VB in Exce, can I loop through all worksheets?
- Excel Linking to Access
- Recently Used File List Doesn't show saves
- function for finding position of numeric character in a string
- Excel97 How do I enter a formula help please
- Import txt file
- So close! Problems with Loop
- word more intelligent than excel???
- Coverting Dates to Text
- Ecxel Macro to summary and eliminate duplicates
- moving cursor to text box
- msgbox
- Strange Log base 10 results
- Hyperlinks - They seem to work fine - just cannot find the cursor
- How to return the xlConstant for a number
- Sort and Combine
- Failure to open workbook via automation
- Enable Warnings
- Incorrect templates path
- moving cursor to a text box
- How do I switch between windows in the active workbook inside a M.
- Internet Explorer & Excel
- copy temp sum in bottom right of excel to clipboard
- Is this imposible for VBA to perform?
- Macro Auto-Fill Field.
- VBE Weirdness
- sum over more then one sheet
- Delete method
- splash screen
- File name a variable
- Shared Workbook; Update-on-Save not working when called from code?
- IF Statements
- Excel Access VBA
- Automatically copy down a column
- connect to an oracle db
- Comment indicators - web translation
- Unknown address change
- VBA VLookup Problem: Run-Time error '1004'
- Abandon invoice
- Copying Workseet to NewWorkbook
- Insert the same value in other sheets
- Formula - Time, Cell
- scrollbar on a text box
- Add shortcut key or hot key via vba
- Run-Time error "70" Permission Denied
- Restricting User Input...
- excel
- Microsoft Query: retrieve data by dates
- Microsoft Query: retrieve data by dates
- 2 Worksheet Comparison Across 2 Workbooks
- GetOpenFilename
- Analyzing Text file records in VBA without importing into Excel spreadsheet
- Auto-set Chart Data Range
- excel VBA
- Moving Access Mini App to Excel
- Copy picture from image control
- Rumba/Excel
- Saving in a location
- Erase Code
- Problem with if statement
- Path names to xla file in formula
- Only print worksheets with data in B2
- Do you wish to clear clipboard memory?
- copy last row without header
- Argument limit in Excel Function Wizard
- Save Filename
- how do get rid of a selection after pasting
- Text file to measure file usage
- Text box
- Deleting AutoFiltered Rows
- Application-defined or object defined error
- Range selection problem
- Properties with Intellisense
- prevention emergency kay - for experts
- Re: Passing var types, groups and properties to a sub
- ScreenUpdating & DisplayAlerts
- Change event help
- Hiding All Groups
- Finding column of a particular cell
- Mass update VBA macros with batch program
- How can I set up a dashboard in Excel from which different worksh.
- Re: Date Time Picker ActiveX Control Version 6.0 (SP3)
- Re: insert sheet and naming it
- 4 column sort... Fools rush in....
- Run/execute VBS and pass arguments
- Exporting to Word
- Wrap Text
- Can I save my Excel sheet with Macro as webpage? It seems the Mac.
- Storing variable in Option.Tag
- Delete a file
- Loading Excel Data into PeopleSoft
- Reading dates from text file
- inventory location flow sheet question - formula needed
- Row color by grouping?
- Sorting Problem Need
- When MultiLine Txt Box Returns a square to the formated wordwrap cell
- Re: Problems with sorting a pivot table
- text box
- Retrieving the state of a checkbox (form type) from VB .NET?
- Re: aligning data lists with code
- Error on refresh backgroundquery - help please
- SQL Query
- Excel Addin and Windows Profile
- Query on implementing drag-and-drop with VBA
- Re: RTD returning arrays
- 2 Quick Questions
- GetObject() returns different types of instances
- Excel 2003 VBA question
- Sort Filter & Create Text File
- Waking up a Printer
- Working with columns of data
- Modify Name, Title, Author, etc. of an Add-In
- List Worksheets & Chartsheets
- Naming and Adding Worksheets
- String Function
- UserForm positioning to second row
- Using Excel Spreadsheet to Survey Customers
- Using Excel Spreadsheet to Survey Customers
- merging cells and comments
- another "400" error
- Re: automatically select object references
- Random entry from list
- String manipulation and creating an "offline" excel workbook
- String manipulation and creating an "offline" excel workbook
- HOW WOULD I GO ABOUT ADDING SOMETHING LIKE A SHOPPING CART TO AN .
- vb "400" error
- displaying info on a form
- disabled list box text color
- shared files
- Total Row Not Calculating Correctly
- Import External Data
- passwords
- Re: how can I return the active row and active column?
- RE: ? for Jim Thomlinson
- Using listbox as menu on userform
- For each Checkbox
- RE: Moving rows to 2nd tab when worksheet is protected
- Programatically access Excel's Solver?
- Format NOW function
- Re: Simple Checkbox Question
- RE: Help with imprting a csv file into excel
- Refer to Elements in an array
- Re: Custom Menu
- RE: How to require entry in a cell or group of cells?
- Re: Moving data from Col B to Col A
- Re: Interaction with Internet Explorer
- Re: Simple Checkbox Question
- Re: macro to white out (to change a font in selected cells)
- How can I make a custom button in one Excel form to e-mail easily.
- De-link a cell reference in a formula.
- Pivot Tables - Percents in subtotal
- Help with Condensing 10 Digit Number Please
- Workbook activation issue
- #Name?
- Excel97 Date and Time Help Please
- Relative/Absolute Formula writing in to a cell.
- Inserting formula programatically
- Using Array Index function in a sub
- Passing an array in a user defined function
- RegEx Replacement patterns
- recover worksheet
- Test for end of array of objects?
- Passing a Range
- I need assistance getting VBA code to do the following...
- My Excel formula is using my text as a cell range.
- Visual Basic Error
- display sheet choices in combo box
- Argument limit on user Function?
- Error Loading Add-In
- matching items on 2 sheets
- Rename Sheets
- Finding a match
- Ex03 Custom views don't work
- Application-defined or object-defined error on copy
- Range Name
- Removing Excel Add-Ins
- returning filename in excel
- Turn Rows into Columns
- Turn Rows into Columns
- Automatically enable macros for particular template
- How do I split "A1B2" into "A1" and "B2" using text to column fun.
- Special Index/Match formula
- Making Workbook_Open macro conditional
- Help required putting borders around cells.
- How would I set up a Genealogy tree?
- merging or cancantinating worksheets
- Error unprotecting worksheet
- Rename sheets
- Please help me to adapt this code.
- updating a text box
- Two big size excel file
- Count Days Worked
- VBA ActiveWindow.WindowState Problem
- Find and Open Workbook then copy and move sheet
- VBA Code to Import VBA Modules
- Open PW-Protected MS Access db using Excel VBA
- Avoiding 400 Error code
- Format to percent in msg box
- error on ActiveWorkbook.Close
- auto add rows to ranges
- Esc out of userforms
- Setting up autorecovery problems
- How do I format a text box control to display the source in time .
- Copy Column A
- matching items on 2 sheets
- another question for Tom
- Prevent running macro upon closing Excel
- Macro to change cell borders
- Data Form (ignore previous one)
- Data Form
- VBE Question
- Parse String
- combobox to drop 'up' not down
- Inserting Hyperlink
- changing pivot table views with a macro
- More than 65,000 lines and ACCESS
- Difference between Word and Excel
- Excel Wookbook naming
- Sort Contents of Moving Range
- macros code & color based functions help
- data entry template
- Formula in given via input box
- rename worksheets after copy
- Anzeige "Bitte warten" während Makrolauf ?
- Can I list which sheets/cells have changed?
- Between values
- .AddShape(Type, Left, Top, Width, Height)
- Auto move scroll bars of listbox
- Excel VBA
- Userform handling
- Find, Match, Compare or Search.... Help!
- VB msg box - can it have a title?
- greying-out item on custom popup?
- Macro to Extract Values from Master.xls to Report.xls
- Event Procedure again
- without for loop
- Event Procedure
- Hidden cells
- making normal text to hyperlink.
- Autofit excelrow
- Limit User scrolling
- show messagen when running a macro?
- How to calculate this on all rows?
- First Empty Row
- troubles when 2 webbrowser navigate simultaneously
- Numberformat for Cells using Automation
- Excel SendMail Not working in XP Office 2003
- Copy changed rows into a new sheet and save them
- Reverse VLookup?
- Finding new entries in list
- Macro to Count how many times a number occurs on a day
- data validation quirk
- how do i programmatically insert a button on a worksheet
- How to know a row or cell is blank...
- copy active worksheet plus another worksheet
- How to get enique records from data list?
- Range of even/odd rows
- problem importing data from another file
- sending the active worksheet and an additional new sheet
- how to set random numbers that add to 100%?
- create a right click menu in excel 2002.
- Spreadsheet with merged cells - how can I unmerge the cell and re.
- Dates to Worksheets
- collection of sheets
- Opening a dialog
- hyperlinks out of a combo box
- Userform runs other subs when initialized
- Macro Start Autorun without Enable security
- VBA project in Intranet
- Removing Defined Names
- Selecting a variable number of cells in a row
- The disk is full error message
- Formating of Numbers
- Logging activity
- Number Formatting when joining two strings
- VBA Help
- How can I get this code to work?
- Display history in user form
- How to add control to toolbox
- Form writing blanks!
- R1C1 and the $ sign
- stack space deficiency
- Relative referencing in macro won't work
- Is There a Function To Reset Macros?
- Page Break
- command button move worksheet from one workbook to another
- How to keep a workbook visible
- update label or text box
- Copy cell data Workbook to Workbook
- VBA Excel project won't work when opened in intranet
- Adding and Changing 'CustomDocumentProperties' from VBA on other f
- Passing argument to another Sub
- TextBox in UserForm with > 24h time format
- Validate Data in VBA "How to get lost focus cell address"
- Outside Data Sources
- Application.Selection Is Range?
- USING SOLVER IN EXCEL
- stop recording toolbar
- Displaying cell contents based on input?
- how to copy formula without changing reference
- converting a cell text to date
- insert or update
- Hiding Workbooks
- How can the range.calculate macro be run with "iteration" and "ma.
- How to detect another application
- Displaying Custom Toolbar in Specific Worksheet
- Passing CheckBox Value from Click Event to Main Macro
- Recordset Filter by Array
- disable right click menu
- File get bigger when I save in excel
- How do I plot a scatter plot in 3 axies?
- Extracting footer informatiojn from unopened XLS file.
- Extracting Footer information from unopened XLS file.
- Stripping out contents of a cell after 8 characters?
- Do loop without do? Why?
- Set certain rows to Bold
- Changing Sheet Name
- Import xls file..vba excel2000
- VBA Form Button Closing WorkSheet
- Disassociate Macros when saving under different name
- SelfCert
- Adding checkboxes programmatically to a worksheet
- Adding checkboxes via code to a workheet
- Save without prompts
- Cell value prefix
- Jump to the next count in a FOR Loop
- Preview of Spreadsheet/Document
- Stuck on a validation loop
- Creating a (Modal) version of File :: New :: Contact from Excel (into Outlook)
- Finding Last Column in a given Row
- counting items in a range
- Footer info from unopened workbook
- Capture footer info without opening a workbook
- Model Audit
- Convert a String to an number
- Check cell contents then format as locked
- Want a simple VBA code.
- give back times of current month automatically
- Autofit, Centre and Text
- Populating the combo from worksheets
- find value and copy column to new spreadsheet
- about "GET.CELL"(cel interior color)
- Removing Password using VBA
- Commandbar - how to find out which msoCommandButton was pressed
- command to be run at a certain date
- Help needed with this autosave macro problem
- Using .formular1c1 with the Range/Cells Method
- Renaming a Module
- Changing data in a column
- ActiveSheet in a Macro?
- Font Examples via a Macro
- replace cut command
- UnMerge Opened Workbook from Add-In
- How to Determine if column of certain rows in a text file has data?
- Beginner looping / summarize question
- Macro one workbook to another
- converting from text to number
- VBA question: editing alpha characters out of numeric values
- Need help with a macro
- Remove a Reference
- union problem
- opening consecutive files
- Resources problem with VBA & charts
- Create an Adobe PDF from other PDF files
- Saving A File
- Must be first
- 'Right'
- Refering to Desktop
- VB in Excel
- List Box - MultiSelect
- Coding with pivots and Multiselect list
- EquationType Property
- big counting problem
- Using VBA to Paste items copied within Excel
- Format
- VBA Range Issue : Cannot programatically select more than 42 columns
- Validate mm/dd/yyyy
- macro extracting text
- printing and viewing
- Changing font color of textbox text.....
- Fill in the blanks
- Code Line Number in VBA
- Add-in Auto-Generation
- Error Trapping
- RE: Fill in the blanks
- code line number
- Adding text file to a user form?
- Count elements in array
- Trust VB projects setting Grayed out
- Can I get a chart to an image file?
- On a PDF Note --- Check this out..
- extending excel named range with vba
- Problem getting info to transfer
- Close Adobe after printing
- Selecting range based on values
- Running code on hidden sheets (revisited)
- IQY
- loop calculations in excel?
- Set row heights to values in cells
- How do I invoke a VB subroutine that exists in an Add-In?
- Formats: Too many different cell formats error message
- Multi Selection List?
- Passing String to Formula1 Method in VB
- Array or Pivot Tables???
- Problem with the round function
- Adding files to an array using Dir
- Splitting string into letters and numbers
- Returning Cell to Upper-Left-Most Corner
- VB question
- Open Save & Close All Files in Dir
- Auto_Open question
- Select Visible sheets
- manipulating a textbox in charting area
- Running code on hidden sheets
- Renaming Forms
- Cells(r, c) syntax and horizontal alignment
- autosave before close
- Is Validation?
- Selection in data range
- Sum of Variable Cells in a Column
- Conditional Hyperlink?
- Filesystem again
- Error Handling with a Match Function.
- Programmatic indication of file to be PROCESSED.
- sumproduct or other way in vba, help and thanks
- delete values in cells
- mutiple same lookup values
- Bulk processing
- "Formula is too complex to be assigned to object" ?
- VBE toolbar not ready for cutomizations
- SQL Connect
- change worksheets through code
- is it a microsoft prob..can it be resolved or not?
- Qualifying OptionButton with ro without MSForms
- Macro for Emailing a spreadsheet
- Protect VBA codes
- Macro compatibility problems between PC and Mac (Excel 97 and Exce
- string output needed
- Combination of 2 combo boxes to populate 3rd
- Automatically run a macro when a cell = FALSE
- Programming the Progress Bar problem
- Does folder exist problem
- Macro?
- define a database path
- Is worksheet open
- VBA 2003 Save|Change|Restore builtin menu OnAction
- msoControlButton tpye problem !
- How do I have an image in a cell based upon a referenced value?
- Determine if it's a leap year
- second file/Workbook open
- Toolbar Icon Size
- Input form question
- Loop Through All Open Workbooks
- VBA Code to Print a Variable as part of CenterHeader Problem
- Must be more than 1
- Workbook_BeforeClose
- Installing a Custom Add-In
- Search by rows and then go to selected row...in a frame?
- Menu Item Deleted
- Saving a column of data in another file format
- Creating a "To Do" List
- Corrupted Macro
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.