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 |
- Excel Function for Checking Email Syntax
- Search and Delete
- How to create a massive find & replace macro
- calling next macro
- excel filter question
- Automating a Printout
- find, delete, repeat loop
- Macro Interaction on Server
- countif problem when using range name
- VBA copying & pasting into a different workbook
- Comments & Scrolling
- Saving Workbooks to web pages
- Is there a script that will work?
- Formatting Data being extracted from SQL D/B
- Combo Box help
- IF formula syntax problem
- Missing Recording Macro Indicator
- How to create a Macro
- How to create a Macro
- Deleting duplicate data - inc original cell
- Pls. Help: Need Macro for Copy and Paste
- Copy only Visible cells to another sheet in Macro? Runtime 438 error?
- trouble with syntax with fill down in Excel
- Compile Error
- MS Query help!
- Update data from an external Excel spreadsheet
- Fill Down
- Get Autofit in Excel to format just part of a column?
- wildcard
- Easy way to plus 10 to each cell in A1:A50?
- I need an expert for that!
- Run-Time Error'-2147221080(800401a8)': Automation Error
- totaling copied columns from multiple pages
- Cut instead of Copy
- Assigning new values to charts
- Saving to PDF Writer
- i dont see what the problem is...
- Excel is not closing
- convexcity funcion
- Simple do until question
- check box help
- Automatically attach Excel spreadsheet to Outlook Email with Macro?
- Show cells with formulas without permanently changing the cells
- Merging two tables
- determine max number of columns in a spreadsheet
- (Email code) Strange sned/receive problems Help ??
- make the form execute file
- Shuffle through sheets in a loop?
- how to delete row from the runtime Datatable
- Looping thorough records
- Automatic 'Save As:' question
- How to copy a row with transposing to a column retaining links to input cells?
- Repeating code
- Range selection
- Manipulating a rumba session using VBA
- rename files in a folder
- Saving each row of an excel file in separate excel files
- VBA issue, debug
- Filesearch finding the same file twice?
- Data series
- Why Undo commandbutton is Cleared ?
- validation
- Spaces in Textbox
- print preview
- VBA Help required...................!
- custom toolbar looses buttons when closed
- Auto List Members rarely works
- VBA Convert only a particular worksheet to CSV
- excel column to word with coma separated!!
- application.worksheetfunction
- Accidentally close user form_how to open
- Is this the correct way to write code
- Security Message when emailing
- Need Help Filtering Duplicates in Excel
- Macro that Deletes All rows except first row
- Increase/Decrease Value of variable/cell using scroll bar?
- VB code to call a macro......?
- The "Do you want to enable Macros?" window does not pop up
- trouble with syntax with fill down
- Reading Data from a Cell to a text box-user forms
- Cmd Buttons directly on a spreadsheet
- Split cell data in mutiple rows
- SendMail and User Input & OutLook Express
- multi line cells
- User Form Change
- Calling Regression Toolpack in a Macro
- Event When the excel opens
- Formula, means and non following cells
- class module programming?
- Application.Dialogs(xlDialogSendMail).Show
- Limiting the use of a Macro Procedure.
- Unprotecting sheet did not prompt for password
- command button
- Printing to Adobe Acrobat
- Display Program Status
- Open Files Macro
- Variable range question
- Date event macro. Help!
- userform combobox treating numbers as text
- Referencing Cells without active cell
- extract data after sort
- Interacting with Forms
- Select group of cells and create arrow pointer to elsewhere
- VB Syntax for OFFSET statement
- function question
- Toggle Custom Views
- What the F@#% is wrong with this code??
- Word Excel automation and the problems I found - Help Needed
- Object required error - Still perservering with this code - Ideas
- text comparision
- Format number as currency in label control ?
- Have not a clue how to do this
- VBA question
- Shell Object Not Working Right In XL2000, But No Errors
- Extracting comma seperated data to new sheet
- Subtotal row formatting
- creating a macro with IsEmpty
- Problème avec une boite de message!
- Extract part of a Worksheet name.
- Formatting columnar data to a monthly matrix
- Password Protecting an Attachment sent via VBA
- zero filled changed to non-zero filled
- print charts from excel using VBA
- Web Service Array from VBA
- Count if, & Replace
- Setting the Chart name as the text from a cell.
- Unable to move sheet after inserting it programmatically
- How to write a macro to do...
- Suddenly Asked for Password on Tools/References
- relative versus specific cells in macros/vba
- Adding a Comment on a protected sheet
- Macro to fill in cell?
- calculate sum of range
- Sumproduct
- Worksheet change event-single column
- Find Values in Cell
- Color of Commandbars Controls (buttons) when disabled
- Automatically moving/copying cells
- Simple Problem - Please Help
- Find, FindNext and prompt user to delete
- Send file in an email
- Macro:Vb:elapsed time per day
- Activating a workbook
- Display the value of an auto filter
- Help me please
- Evaluate (Variable Function Name)?
- Resizing user form in excell
- Insert picture in Excel
- Closing Workbooks Formula
- detecting changes to series of charts
- Macro not calculating correctly
- Find value in range
- Find Copy and Paste
- Selection
- Pasting data following the last " > " in a cell
- Strange Link Appearing Automatically
- Need Help, trying to automate excel word and pdf
- how do I clear a dialog box option
- Data Verification Problem
- code for sum of sht with diff # of rows
- Bulk Upload
- Help emailing worksheet range via Redemption
- Dates
- compressing folders
- Many columns
- Transform entities from column of 1 sheet1 to row of another sheet
- Replace/substitute
- SelectedItems
- Sum Columns
- why doesnt cancel=true always work?
- VBA+API refresh userForm
- transforming excel cell contents in word document, with coma separated.
- Excel 2007 Beta 2: COM AddIn don't work
- Open spreadsheet
- Spline approximation
- application.sendkeys shift+ctrl+enter
- Selecting
- workbook macros now run VERY slowly ... ideas please
- How to get link file name in vba
- DisplayAlert
- Worksheet_Change
- Pastespecial code
- Urgent Please: PasteSpecial not working. Very wierd
- Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?
- mouse cursor for a shape
- Quite a complicated problem
- Please Help...Date converting to USA from UK when running Macro !!!
- Insert row and column headings
- Name Box and not picking up the correct value
- EXCEL SQL Problem
- Web Service Toolkit & using System.Net.NetworkCredential
- Named range using offsets
- SaveCopyAs
- Custom functions or VBA functions for Avg, Std, Min, Max?
- Help: Can open a spreadsheet in a folder which contains spaces in the folder name!
- Formula protection
- NEWBIE: How to sum cells using VBA
- Only as the user once.
- Almost there... dynamic and conditional set of PivotItems
- Excel Library?
- How many excel processes can you open?
- Copying data into sheet
- Putting pagebreaks after objects
- Drop Down Menu on the Standard Toolbar
- can 1 excel's DROP target change MULTIPLE cells?
- link all workbooks to a index page
- using match function
- simple code hide/show rows with cell = empty, set value or any val
- Change text colour of a cell when a different cell is selected
- Changing cell format
- Checkbox & Combo Box help
- Change Screen Resolution Macro
- Output param from SQL
- Order check in solution
- Saving VBA project on workbook close
- call macro if cell is selected
- Add menu item to right click
- Insert user's logon name in to cell in worksheet
- Calling an inactive sheet...
- Create a Pivot Table with VBA HelP
- Suppress Update Links dialog AND don't update links
- VB code Required-------!
- Add rows between months
- Look at Outlook and not Outlook Express
- Inconsistent appearance of HTML pages generated by Excel VBA
- Inconsistent appearance of HTML pages generated by Excel VBA
- disable worksheet tab options
- disable tab worksheet options
- Create ODBC link Using VBA
- Sending a parameter to a Userform
- Merged Cells quirky behavior
- Accessing Excel data through Outlook 2003
- Protect cell - VBA
- microsoft email range code. Add to Sent Items folder?
- Reference 5 cells offset from another for copying.
- Run Time Error "13" Type Mismatch
- RE: EXCEL, WORD Automation
- how to save a range of cell values
- Formula to count words
- VBA password protect
- Excel: useform and shapes
- Fraction of seconds
- Excel Problem
- Using the enter key
- set cell values based on selection from list
- Count Form Button Depressions
- row to column converter
- Form Button Security
- Excel StopWatch
- how do i add time to see how long my macro takes to run
- Previous data in a comment
- Excel user form modeless
- Related Tables - Access 2000
- Word VBA link to Excel
- Using a Macro to Reorder Data - tough one
- Change Event Problem
- How to copy a highlighted row
- Macros in Excel 2007 Beta
- Comparing cells?
- How to pimp my custom menu (want to display FaceIds and shortcuts combo)?
- How do I initiate a macro directly in a worksheet?
- Current Selected Range
- On export option where you want to save
- Dumb early binding question
- Calling Outlook in Excel runtime error
- Animated Gif on worksheet
- Complie Error with xlValues
- How do I insert Text Box in ActiveCell
- Change conditional formatting to coloured alternate rows dependent on a change in date?
- searching data & forms
- Retaining history data in cells when using a form text box
- Workaround for com exe timer?? help
- Macro for adding between dates
- Run Time Error on Closing UserForm
- copy to a sheet
- Programming Funk...Any help appreciated
- Simple MsgBox question
- Place a tick in a drop down menu
- Delete Rows
- Addin data persistence problem
- Add menu item to right-click menu
- Enquiry on VB for Excel
- Pls Help in code given
- Excel 2003 with SharePoint 2003 and Analysis Services 2005
- About "EXCEL6" Window Class ?
- IS 'RANGE WINDOW CLASS' AVAILABLE ?
- IS 'RANGE WINDOW CLASS' AVAILABLE ?
- Writing an If Statement for group of cells
- Precision in Excle VBA
- naming using F5 key
- SQL Server in VBA problem
- Autosize macro
- Copy?import whole sheet from another workbook
- Date Functions in Excel
- While sheet is protected, allow cmdButton to refresh query.
- Macro to enable the analysis toolpak VBA addin on entering a workbook??
- Advanced Conditional Formating
- Macro to Click Button?
- macro and button security
- text box?
- READING values from a closed workbook
- Function with Multiple Criteria...
- Wording a macro
- autoFill column equal to adjacent column
- Macro error
- Code for opening Comment box
- VBA help – an easy question
- Change in code
- Copy and Paste
- Puting data from an input box in two cells
- Listing or Changing all Defined Range Names (using VBA)
- Set PivotField to predefined value with check
- increase print range 1 column
- Find and select all
- Record set to array?
- Is there a way to vlookup and keep format?
- 2 questions: if-else & sheet loop
- Update Links Automatically
- VBA to SQL DB with user input and results to sheet
- Cumulative Total
- Excel and Internet Explorer (IE) - AutoOpen and Hyperlinks
- Repeat error trapping when file is not found.
- Copying Sheets
- formatting number in a text field
- Disable Workbook Summary Info?
- popup menu commandbar
- Run a procedure when exiting a a textbox within a userform
- Oddity with HSI
- Change Code in Macro to specify file/folder to look in.
- Looping help please
- Find New File/Folder
- Delete (kill) active workbook on close: Possible?
- Button alinement
- vb.net & excel properties
- setting first empty cell as range
- Formatting corrupting the workbook
- Random Select one of two or more numbers
- How to copy a range
- How can I perform multiple search & replace - all data in spreadsheet?
- macro: copy multiple workbooks to multiple tabs in single book
- Count Keywords in Column through Macro in Excel
- checking and copying cells
- Help with extracting variable text from a cell
- File Change Notification
- code need for time stamp
- validate a cell value
- Font Size in Chart Title
- Select Table and Field of Query by Cell value
- sheet protection
- VBA Script to Print several named ranges to PDF with cell-defined filenames
- Excel's Backbone
- Jump to Page 2 relatively...
- UDFs Worksheet Level
- When was data added
- Importing Modules From Other Workbooks
- Macro for user to select hyperlink file
- Microsoft.Office.Interop.Excel SaveAs error when clicking no or ca
- Excel 2003 causes error with Excel 2000 VBA code
- Visual Basic 2005 Express to make library for VBA (Excel) - How?
- Permissions issue that I cannot solve
- data reentry for ferification
- Copying and storing values
- paste special does not work
- Inconsistent behaviour Stop Statement
- SendKeys Positioning
- Help me automate a macro
- selct and Copy data from differant rows at the same time
- how do I import a CSV file with more than 65536 rows
- Selecting a worksheet from a combobox
- Color all cells in a row if row is completely filled?
- how to use partial (word) search
- Information Rights Management
- Function code
- Update date when changing a cell
- Textbox calculation problem...
- Sheet names
- counting records
- Counting the number of Cells with a Particular Background Colour?
- close user form
- Referencing variable Range in a loop
- Error 424
- lock excel worksheet when loosing focus
- Command Butons in Exel 2004
- Excel hangs on 'shtA.Cells(person_row, 1).EntireRow.Insert' comman
- Software Engineers - You will like Staffbucks!
- Minimize excel user form
- range names
- Minimize user form
- Help with three columns find unique data
- usedRange problem
- How to add user from to excel
- Wildcards
- msgbox to NOT display OK Button and to run while saving?
- VB Excel syntax for "offset" statement
- Help with filling empty cells with string + row()
- Check for file before opening
- Put current date into a cell when a macro is run
- Format colour of cells based on other cell - 34 colours
- Charting every 1000 points
- Wildcards
- Adding to a selection?
- Resizing Toolbar Controls Automatically
- Resizing Toolbar Controls Automatically
- Resizing Toolbar Controls Automatically
- Resizing Toolbar Controls Automatically
- Resizing Toolbar Controls Automatically
- Delete every other line in LARGE worksheet
- Auto selection of worksheet
- Day of month
- Trouble using UsedRange to trigger an event??
- Ron De Bruin Code modification needed when naming copied worksheet
- COUNTIF statements
- Delete a row with a certain phrase?
- Automate opening a 2nd xl book and copy ranges to other xlbook
- Automatically Changing the Print Area for Pivot Tables
- NavigateArrow parameter -- meaning?
- OLEObject.GotFocus
- The unnamed range selection button
- reformatting for labels
- Search / Copy / Paste
- automatic e-mail sending from excel
- Excluding certain rows from Sort
- Reference for VB syntax for Excel functions
- Search & Copy
- Solver in a User-Defined Function
- Dim VBComp As VBIDE.VBComponent
- using vlookup and sum functions and connecting two worksheets
- Variable row to repeat at top of page when printing.
- How to create an embedded Excel workbook in Word with cell text >
- Data check
- Using a PasteSpecial within a Destination:= line
- GetObject Error 429 - ActiveX control cannot create object
- Excel merging
- Programmatically selecting first worksheet
- Calling Excel File Save As Dialog
- Programmatically selecting first worksheet
- HTMLElementCollection Dilemna
- Macro/Solver error message question
- Getting Username from a file
- Paste Special Values but keep formatting and column widths
- Macros/VBA help
- Find exact match.
- OLAP Question
- {enter}
- Prompts
- Solver statements XLM ---> Excel 2003
- Can't find newly created userform
- Printing a form with a sequential number
- Change color of specific text within a cell?
- Problem with E-mailing from Excel
- a button that will hover
- setting up the print area
- VBA genius needed... Please help
- Scheduling
- Checking for existence of worksheet before creating
- File,Save run a macro
- If worksheet exists delete
- Show real time in Userform caption
- UserForm got focus
- Custom Help File
- When will Excel program with .net framework
- How to reference variable range in a loop
- Unprotect only certain cells after macros runs to unhide range of
- Find invalid names via VBA
- Excel Combobox with additional selection criteria
- macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting
- Running a macro on a specific time
- Moving the Cell Selection Within AutoFilter
- combobox and workbook_change event
- how do you make a macro run automatically when a criteria is met?
- Excel-Outlook interfacing
- Can I address in autofilter FIELD with a value in a cell?
- Shell
- Retain Original Date in Page Header
- Loop removal or optimization
- Adding data to the end
- Formatting certain text within a comment
- Search for text in multiple excel files
- Creating macro button on toolbar
- Time format will not exclude seconds!!
- vb excel
- vb excel
- Range existence check
- Shell ?
- The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel
- Adding Sum to bottom of Col C for all Sheets in Array
- How to calculate market growth and market share?
- pick from list
- Macro to sort
- Changing format of cells
- Extracting certain items from each cell
- insert image
- Problem with RNG Macro
- pop-up messages
- Buttons in toolbars
- Web links
- ADO; RELATE vs JOIN.
- Search box
- Hyperlink problem
- no view combo in cell with data validation
- Web Query error returns
- programmed hyperlinks
- Search macro adjustment
- Bloomberg connection
- Calling customized DLL function fails
- Pivot table on Forms
- problem in excel
- Limit entries to combobox
- how to create farmula in excle programming
- Remove all rows which do Not contain a particular word
- New Worksheet Values Auto Displayed on Sheet 1
- separate data from one cell
- Error Handling - Did i do it correct
- pass worksheet name to a macro
- PivotField refreshment
- Multiple Workbook sums
- Check if sheet name is a number
- List Validation selection
- Please Help...Multiple web queries and Macro help needed!
- How do I format a textbox with time
- copy paste sheet name
- VBA Macro
- Workbook_Open() does not work
- Compare two Workbooks and combine data into one workbook
- ActiveX Plugin needed in Excel 2000 missing from Excel 2003
- Updating a VData List in all sheets by changing a DynRange?
- GetOpenFilename With MultiSelect Intermittently Returns String
- Document Recovery
- Allow Bold & Italic in a textbox
- CC number both AmEx and Visa
- Open Access from Excel
- "For Each" Statement error...
- Way to store cell location to variable?
- Password Breaker
- UDF Using Defined Name
- Can I cause Excel to post an appointment to Outlook Calendar
- AutoSorting
- Is there a VBA PasteSpecial(PasteAllExceptFormats) ?
- worksheet grouping, Sheets(Array... property
- Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?
- How can I look for a sheet in a wkbk and run a macro if not there
- Why can't I tab?
- Conditional formatting for text to number
- "Error in loading DLL", VB6 ActiveX DLL
- GetData
- Can you convert a PDF to an EXCEL Spreadsheet?
- Lelf Columns Turns Grey
- Reading and working with a long CSV (more than 100K lines).
- Excel Freezes When moving from UserFrom to Excel Spreadsheet
- How to select cells in Excel accessed from VB6
- always need 32 characters
- DYNAMICALLY data source for pivot table
- Is a search box possible?
- vlookup type mismatch error
- Loading Values From Another Sheet Automatically
- Thank You
- Excel Macro - Create & Run
- Creating add-ins from Excel 4 macros
- Finding a cell given x and y values
- User permissions for ranges
- Macro Button Link
- data type problem XL9
- strings
- Overflow error, need help
- How do I extract a word from a string?
- Exel Code Locks up my Web Server
- Open HTM file from Excel
- Macro name changes
- Sorting an Addin Worksheet
- Opening doc in macro
- How to loop through PivotTable
- inputbox (error if close)
- count formulas
- Dealing with Shapes in Excel in a VBA sub routine
- Quick Question on Code
- XLA File Size Decrease
- Copy a range using macro
- Range Object CopyPicture Method; Paste to MS Word
- one less than range filldown statement
- Creating new worksheets in a workbook....with a twist
- generate form from excel data
- Cause Macro to Expire
- Update charts
- Combine Excel rows - macro needed.
- Convert formula to range name that is recognized by vlookup formua
- button to expand window over two monitors
- Time consumption in macros
- creating automatic hyperlinks
- List Boxes
- Concatenate
- Need to make a vbs, but dont know how....
- Find / Replace in a string
- Dating cells in a worksheet using VBA
- Deleting All charts using VB
- link to another sheet
- summing totals from varied number of workbooks
- Searching
- Keep IE on top of the form
- Paste Data into other row
- Inserting a picture macro
- ADO Connection vs Recordset objects.
- Creating macro in Excel that can add a check mark
- Excel Date
- Rename combobox with a macro
- Need to tailor my macro code.
- Parents and looping
- calculating textboxes
- count colomns
- Random Value...
- MDX query to filter the cube
- How to call macro from other workbook
- Populate pivot table with preselected items
- copy macro
- Maximum length of a pcuture name is 32 characters
- Relative Ranges - Multiple Cells
- refreshing outout value before tranferring into a matrix
- the Parent property
- Copy the same column from 50 sheets into a new sheet macro help!
- Compare Rows in Sheet 1 & Sheet2
- Pivot Table Calculation
- Adding a line to a PivotChart
- Is there a method by which we can programatically save the workbook?
- VBA Reference Book
- Text fields with numbers in .csv file
- Mesage Box
- Message Box if certain value is entered
- Getting reference of an excel cell from other sheet
- speech recogniition in excel macros
- Toolbar event management
- VBA to plot graph wiht variable range of data
- Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
- Repost - Is there a quicker way to copy paste
- Copying more than 255 Characters to the Clipboard
- How much memory does VBA code occupy?
- Outlook Email
- Sending automatic email + Bloomberg
- Is 300,000 Named Ranges going to cause problems?
- Unhide Columns in certain range
- Getting Excel Runtime Error 9: Subscript out of range
- Listboxes - populate with all worksheet names
- Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
- set excel <filename> to <filename-date>
- Add file name to end of all sheet name
- Need to save SQLdatabase userid & password after link has been cre
- Copying and validating data from two sheets
- How do I get cell possition in screen x y
- double click option in listbox outputs to cell in excel 97 !
- If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct?
- fresh learner need help!
- NEW DATA
- Macro to copy formula to all rows that contain data in columns A:C
- moving columns to a new sheet
- copy paste for each cell in an array
- Count Words in a Textbox
- SQL variable exchange
- combining spreadsheet tabs
- macro to import access data into excell
- For Each ... Next loop - need to reference the loop variable
- Gathering data from all worksheets for a report
- how do I convert an integer to hh:mm (part II)
- Find and Replace in mulitple tabs
- MSQuery question
- Disabling 'Cancel' option when saving work (Yes/No/Cancel)
- Import one column of data from multiple Excel worksheets
- Print merge file
- how do I convert an integer to hh:mm in excel?
- Uniqe Records
- False message .xla already open
- method 'SaveAs' of object '_Workbook' failed
- DTPicker
- Using Named Range in Worksheet_Change event
- Problem with VBA code written in Excel 2002 working in Office 2003
- VBA Password problem in excel 97
- Closing a possible Workbook
- Compare 2 list macro
- Pivot Table Automation
- Understanding macro statement
- If Statement then Calc
- if activecell is value
- I s there a quicker way to copy paste
- How-to create macro?
- Please help... Deadline (ADO recordset.filter)
- Help needed! How use a Command Button to pop up a text box in Excel?
- functions to change color of fonts or cell backgrounds?
- Workbook.Save triggers event Workbook_BeforeSave and things don't work!
- Lotus Notes doc link not working in Excel
- Textbox text into cell as formula
- Macro
- Wheel on mouse doesn't scroll in VB
- macro to open in all files
- trouble with website
- importing multiple text files into individual worksheets in workbook
- NEED HELP with Range command
- Value error on closed workbook links
- Enter Standard Time for H:MM Formula
- Macro to Export Active Cells, Comma Sep to .txt file
- FTP Upload
- Copying a range based on criteria
- Copying a range based on criteria
- ERROR WITH MACRO EXCEL
- How to permanently change Dialog Caption while in the Dialog
- How to permanently change Dialog Caption while in the Dialog
- Resize all comments
- Macro Error
- Simple Excel Ques?
- Passing Data to Internet Browser
- Help with an error message
- excel graph construction
- Worksheet Change question
- VLOOKUP PROBLEM
- TIP: Worksheets vs. Sheets (w/Charts) Count
- Inexplicable problem with function
- Need some help plzzz
- How can I save a worksheet as a jpeg file?
- Shape ControlFormat.LinkedCell returns wrong Address for named range - BUG
- Scroll bar
- Error: Wrong number of argument or invalid property assignment?
- Ignoring fields containing text
- autcompletion
- Format Pages
- Sort data
- Range question
- Series
- Question-user defined function
- Open another program
- Adding a sheet with a specific name
- excel add-in refresh
- Excel Macro Question?
- Macro coding to create a matrix
- sound or speech when a cell reach certain value
- Font in Userform
- Can I copy cell contents to an autoshape as text using a macro?
- Macro to compare two list
- Macro to compare two list
- Change Cell Color
- How to display a pop message based on a cell value
- Please Help! Object Required suddenly, was working before!
- Opening EXCEL with additional Parameters
- MS SQL Connection and Retreival
- Macro to copy active sheet and email to distribution list
- Rename active sheet with current file name
- Determine specific range
- Piloting excel with vb.net
- Send key in an inactive window
- Using Modules?
- Automatically insert a row
- Using PageSetup to copy LeftHeaderPicture in another sheet
- Change row in a Visual Basic messagebox
- HTML / Excel format problem
- Conditional Formatting - Run Time Error '13' Type Mismatch Error
- Listing of error codes
- re : Help needed on some codes
- Delete Blank Row & Put Total
- What code do I use to add a user form to Excel worksheet?
- locked cells
- May be a Chinese Windows problem??
- query information
- Help with code please
- Re-Format Date
- Old code in Excel add-in (.xla)?
- Help! Run time error 1004, range of object_global failed
- Split data and copy surrounding data
- Filling in missing data
- Re: Getting number of files within a sub-folder and its size
- Rate a post as an answer!
- Hide "All" option in page fields in Pivot Excel
- Shell function for opening windows explorer
- Application.DefaultFilePath to open not just save
- Recordset Searches
- Need Help with Offset
- Custom Number Formats
- Macro - msgbox vs. enter result in a cell??/
- format cells as "Text"
- J West: Using Word capabilities in Excel and vv?
- Check box
- Code VBA 4.0
- How do you name a new workbook in VBA
- searching names for '*', replacing it with first name
- Re: Bloomberg links
- Convert Table Formats
- Combine two data arks?
- File Open Dialog Box
- Edit Event from Macro
- User Forums
- Code to loop through multiple checkboxes
- Copy and Paste specific data
- Object Arrays
- insert current date
- RE: Bloomberg links
- How to trigger a selection change between a cell and a shape
- RE: Adding a Searchable Index
- userform problem
- arrayname as variable
- Import Data From Access! Please Help!!
- RE: Odd Tab behavior
- Re: Text to columns
- RE: Another basic problem
- I need Help With Range Command
- RE: Lookup or Match
- Display Sheet Tabs in Two Rows
- Looping through valid inputs (VBA)
- setting numberformat for -ve numbers
- Auto Refresh Time
- Auto Refresh Time
- Auto Refresh Time
- how to use a IF(AND) formulae for more than seven conditions
- Protecting VBA source code
- Extracting/Exporting HTML Tables or PDF Tables into Excel
- Page setup and formatting possiblities
- ReDim Array
- Cell Range Values with VBA
- Dimention & manipulation of Variant array
- MSGBOX not working
- Complete list of Excel Command line switches/parameters
- addin not running correctly
- Alternative to FileSearch for Finding Directories
- ComboBox only shows single value for horiz dynamic ranges
- Runing Excel macros from a Bat file.
- Date validation
- Reference problem / advice
- Looping and searching
- Copy Value Of Last Cell
- Setting chart size in macro
- VBA Project Deleted
- Setting chart size
- RGB for cell interior
- Userform TextBox TextAlign Problem-Bug?
- Making macros loop
- Wildcards in workbook name
- Add a button to a macro
- excel namespace import problem
- Split a 2gb csv file into two files
- Setting Excel Ready property
- changing values in one column based on values in another?
- switching between 2 arrays in one form
- Using Macro
- Sending Excel data to Access.
- Refedit copy paste problem?
- Finding specific data and moving it to a new sheet
- Exchange rate function
- Checking contents of arrays
- PLEASE HELP! Copy sheet with password protected cells debug error
- How to acess form elements values in the Workbook_newsheet event??
- Delete Commandbutton?
- toggle button text
- Controlling user environment
- Refedit copy paste problem?
- Refedit copy paste problem?
- Hide or Unhide certain columns based on a cell value
- sharing and protecting incompatible?
- Drop Down List
- Reading Word TextBoxes and Transferring Contents to Excel
- Help! Single cell owning > 1024 chars caused exception
- Locking panes in macro
- Getting the particular value on the basis of given criteria ?
- Mass Creation of Named Ranges?
- IF functions
- Copy info to new sheet
- Subform in excel or Frozen Panes (Top & Bottom)
- Lotus Notes Doc link in Excel??
- How to create a chart that it's datasource coming from a chartspre
- Code to look at all sheets not just specified sheet ?
- Recalculating Array Formulas
- >> Listbox OldValue
- Delete all sheets after sheet1, but not by sheet name
- ifs
- VBA Code to Group Rows Based on Cell Contents
- open an external file
- wanting to save HTML format in one sheet
- Multiplying 2 cells based on the value of one of the cells and...
- TransitionEffect
- Prevent control taking focus when accelerator key is used?
- Subaddress for a chart in Excel
- VBA vs Functions
- Counting Clicks
- filtered pasting
- Macro Help!!!
- Programming using date
- Run time error 424 Object required ?
- filter date excel2000
- Verify if sheet name still exist
- VBA Code to Group Rows Based on Cell Contents
- keeping a range a range object
- Error Message
- Lock and password protect only cells with formulas on all sheets in a workbook
- Can this be done- Spin button attatched to message box?
- need help on pasting link if certain cells blank
- need help on pasting link if certain cells blank
- Sort/Duplicate Help
- Urgent Help! Ms Query
- Prevent control taking focus when accelerator key is used?
- Passing a range to a function
- Get distinct rows from different worksheets into another worksheet
- for i...next i over images in a sheet
- Setting printing properties
- automatic shape property settings
- Method Add of object Sheet failed
- COM interop XL2000 vs 2003
- VBA: providing CustomerID for IP-Addresses in external logfile.txt
- Help With Vba Code
- Lock sheet tabs option in a specific workbook
- How do I avoid copying data into blank cells
- Vlookup in VBA will only find first match???
- How to add one column to a range VBA
- PrintToFile - PDF Issue
- Finding if Excel Sheet exists
- NEED HELP : In Macro
- Inconsistant formatting of Userform Textbox and Spreadsheet storage format
- Upper, Lower & Proper case
- Userform load problem...please help!
- Test if cell.validation is set
- Method 'SeriesCollection' of object '_Chart'failed
- monitoring range change
- Get values from a closed workbook
- Worksheet List, Dropdown List Excel 2000!
- =SUMIF PROBLEM
- copy method of worksheet class failed
- Possible ? Search all closed workbooks in a folder
- Macro log
- activate VB code for any WS in a single WB
- Path/file access error
- Testing for Named Ranges
- Retrieving Data from Excel Pivot tables into Datatable
- Loading Multiple TextBoxes
- OptionButton quandary
- Search /Filter vertical Numeric pattern (down single column)
- docking a custom toolbar
- Click events not working when added during runtime
- Add-In
- Determining repeated cells between two workbooks
- Character Locations in Strings
- File number not available on entering in a module in an excel add-in
- Cell Format Problem
- export CSV file with semicolon
- Minimize Maximize buttons
- Prompt to calculate the date formula
- Possible to create 300+ hyperlinks to run the same VBA code?
- Depreciation Formula
- Macro to rearrange/add columns based on column header?
- Exporting and Importing Data into a preexisting Workbook
- Open workbook macro- find correct month to open?
- Change Microsoft Scheduler?
- Replace blank cells with NONE
- Minimize data (as a section) on a sheet
- macro
- VBA Excel PivotTable Drop Down Help
- Macro hardcoding issue
- addin not running correctly
- Form Command Button Problem..
- Run a macro when validation field is activated
- UserForm TextBox validation and focus
- Help on Add-in for switching between sheets
- Include file
- column headings for a list box from a recordset
- I want a macro that will upload a number of excel files at once.
- contains formula
- Deleting Rows with Too Many of the Same Number
- Difference among Module, SheetX, ThisWorkbook?
- How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
- loop macros until reach blank in adjacent column
- Macro to automatically add amounts
- Comments in CSV
- Excel MSN Money Stock Quote plugin should return Dividend Info.
- Alpha sort, but some cells sorted by phantom term?
- ADD-IN will not appear in MENU BAR
- Counting cells with Invalid Data
- Prompt to say complete when macro hasd completed task
- Page Setup from VBA prints half wide
- Frustrating Problem with VBA Help in Office2003
- Need Help with Deleting Duplicate rows
- More Pivot Table Hullaballoo... text value grouping
- Formating excel value to numeric or currency with interop
- Editing Word Document within Excel
- Copying text from comments to cells with line feed
- Worksheets that refuse to go away
- Open workbook properties on save.
- Attendance database programming
- Help with dropdown boxes and preset selections
- error in code to format only a few sheets in workbook
- Using Sheet names & Workbook names in VBA coding
- Quirky Problem With Links & Excel Versions
- reading pivot cache
- Excel 4.0 Macro Help --> Excel 2003
- easy (?) subtraction problem
- Custom List to Define Sheet Tab Names
- Insert macro name in code on call statement.
- Benefits of using template in generated word document?
- Is there a easy way (no macro) to switch between sheets?
- read receipts from Outlook Mail
- new window event
- looping through items in a dictionary
- run-time error '1004'
- Automation Error using xlDialogSaveAs
- How to define
- sql stored procedure results in a recordset questions
- Alan Beban's Column Vector Routine
- vba code line number
- Looping Range
- sql.request question
- open other excel application by vba
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.