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 |
- copying changing range
- macro help please
- Validation
- Tweaking Code
- Enabling macros for my workbook
- Range class failed
- Next Row
- Macro Instability
- Excel Problem....
- Merging 2 excel file into single excel
- Merging 2 excel file into single excel
- Creating a stack to push/pull ranges
- calculate blocks contained in a larger piece of wood
- Excel app now requires password
- Sort by Hierarchy
- Formula in a Macro
- The project file " is corrupt and can't be opened
- Tweaking Code
- Help! Question about Worksheets.Copy
- print or row like command in excel vba
- "Out of Resources" Message
- Macro gives the wrong date format
- Worksheet-template (HELP!)
- statistics question
- What am I missing?
- Excel 2003 very slow
- Count Cells in Range
- Office SP2 update causes Excel automation crash!
- Re: coding a submit button
- How to iterate through sheets and set ActiveWindow
- Screen 'Refreshing' - Too Much Code???
- group method - is there a collection
- VBA Help Please (delete row)
- Array
- Target Address/Value Macro Won't Work
- Spell Check Macro Help
- Compare two worksheets and highlight the one sheet’s difference from the other one
- Put values into excel range from single dimension array
- programmatically deselect a selection?
- Return network share/drive letter equivalent
- Opening file without alerts
- Fast way to make rows visible and invisible
- Adding PivotTable to AxSpreadsheet
- Ron DB! -Calander question
- VBA - Determine last cell in range?
- Deactivate then Reactivate UpdateLinks
- using a cell value as graphic file address
- validation
- Cell Formatting Failure
- Undefined function
- Updating a Validation List
- While refreshing data excel hangs because the certain page is temporary not accessibl
- How do you get Excel to record a macros using relative refernce mo
- Macros
- Undefined function
- ADO Resource
- Help with a loop VBA with an if statement
- Creating or going to a worksheet
- Add-in / xla causing random wierd GPF / crash
- Macro - pls help =)
- Combo Box Referencing and Assignment
- AS400 transfer via VBA
- Pivot Table version (xlPivotTableVersion12)
- Shared Workbook
- PASTING CHARTV IN METAFILE FORMAT TO PPT
- CUBE FUNCTIONS!
- Conditional Formatting Limitations ?
- find and move data within a column
- outlook/excel interface error?
- use vba to write vba for a chart sheet created on the fly
- Cannot Get SQL Query to Work with "LIKE"
- develop an if then else loop in excell that follows cursor moves
- Excel buttons display differently on different PC's
- Adding leading spaces
- Email
- Setting Shortcut Keys
- Best way to check
- Command buttons
- VBA newbie needs help with triggering a macro
- How to write a macro to select print ranges that vary monthly
- Click cell to activate macro
- RecordHigh(Cell)
- Time and date each entry
- Excel Rookie Question
- Whats wrong with this?
- Inserting a row
- Creating combinations based on a criteria
- Nested Arrays
- Can anyone do this?
- Replace characters in columns in excel
- Getting RAND() value but NOT its Function?!?
- Transpose (?)
- Delete rows foward if cell is empty
- custom format cell, if value is 0, then write "-"
- export to excel from acces and format
- CmdButton - How to make button it the default button?
- How do I expand Excel lookup function to search more than 16,384 r
- questions about Dim
- VBA help please - remove leading spaces
- MsgBox Help
- "Smart" Copy
- Form Show Error
- Auto Fillter data and copy to other table
- Modules and code
- From CellA1 to a column of Date
- How do I perform a certain function if VBA throws up an error?
- Works fine in debug, but...
- exporting image from sheet
- How to make Form Modeless
- Macro assistance please - again!
- macro to copy down formulas
- Conditional format for labels
- how do i run a macro in excel 12 beta?
- How to handle double byte data??
- reusing a recordset for a pivot-table
- copying multiple selections
- Deleting ActiveX control???
- VBA pulling data from other workbooks?
- Hide column depending on its header
- Loop .WebTables to increment by 1
- Automatically save workbook when exiting
- Cut and move rows to different worksheets
- accessing value of a cell having formula
- Best way to do this!!
- Need a macro code for formula using both absolut and relative refe
- Sort by an expression?
- list boxes - multiple row sources?
- Controlling Row Inserts and Deletes Via Code
- How to activate Add-ins for files in a particular folder????
- conditional count of cells between dates
- shortcuts
- [VBA] how can a Vlookup return the Formula instead of the Value?
- Compare Strings Question
- Need Simple Copy and Insert Row, Move Down Macro
- copy 2 cells into 1 cell
- Named ranges vs setting range in code
- Is it possible to display cell value on a form?
- cell.formula fails
- How to manipulate a row with a certain value
- Create a Macro to Copy a Worksheet, and link certain cells...
- date references in macros
- Problem running Find code for different sheet
- Loop Issues
- Help with UserForm code.
- SUMIF function
- Error 400 on making row visible on a protected sheet
- how do I set letters to indicate a range of values in one cell
- a complex use of sumproduct ?
- Setting ScrollRoll without ActiveWindow
- For Loop Help
- Access Editing from Excel
- counting criteria within alist
- VBA to set print area of single page
- VBA Question Multiply vs' replace
- How to update macro from 2000 to 2003
- Number Format Controls on a User Form
- How to do this? Thanks
- Strange question about combobox and msgbox
- VBA Help Please (rookie issue)
- Removing the Insert Function from the tool bar
- Pivottable invalidated by .childfield
- sorting a range into a single column
- How Can I use "#N/A" return from a vlookup to change row color?
- Alerts in sorting
- A QueryTable refresh, a named range, the 'Hidden' property
- Best way to do this!!
- Pivot Item: removing non-existant item from the drop down
- Lookup and paste
- Macro Virus?
- how to stop text size from reducing in TextBoxes in Excel
- saving in other File types
- Macro (Codes)
- Excel 2003, can't setfocus in a textbox inside a multipage, tab key don work!
- French Vs English
- Running code/switching between sheets
- Casting Problem in VBA
- Message Box
- Replace only "A*" by an other text
- Marco & hyperlink
- Copy Problem
- Try again - adress from a range to combobox
- iterate columns to select certain cells
- Manipulating text file data
- Check if several workbooks are open
- RowSource for User Form
- DELETE SPACES In part
- Deletion of rows in a column according to a given criteria
- Location of Cell Between Embedded Chart
- Importing a File into a Template
- MACRO VBA TO SAVE EVEN IF FILE EXISTS
- Repeat tasks automatically to others sheets
- Inserting a combox
- Help,, need macro to replace 'space' in list of names with "." (dot), then compare ss
- VBE Tools>References
- Moving sheets to another workbook
- Simple question about FORM / SAVE & EXCEL
- Emailing A List of People using VBA
- Asci equivalent of soft return (alt+enter)
- Use An Excel Built-In Function Entirely Within VBA
- EXCEL CACHING ...
- Would like Macro example to write out a range of cells to a file
- Re: Concatenate 3 columns.
- Userforms keep popping up, need code to stop it
- Value from Combobox to Cell (Excel 2003)
- Concatenate 3 columns.
- COUNTING 3 DIFFERENT TYPES OF DATA FROM A RANGE
- Copy cell
- Copy destination problem
- Record a macro which enters a password to unprotect a workbook
- Closing and attaching spreadsheet to an email
- Getting "Object Variable or With Block Variable not set" error
- lookup function
- Convert excel to different file format.
- Not allow the user to link to other workbooks
- Want to Set the File Save As path
- Excel & PCL Commands
- What is the fastest way to pull a recordset using ADO to Oracle.
- Delete file if it starts with a number
- Multiselect List Box
- How do you edit the text in a userform-textbox?
- 1:N mappings
- Application level events - calling from standard module
- Changing filename
- Using Cells Method to define Ranges
- Set a range in a Macro to copy
- Big Help
- When last saved?
- Date in Header
- Last row with data in a column
- Printing subtotals on same page
- Need selected item from listbox after double click
- count with a range
- Retrieving Excel Database Data
- urgent help needed please anyone
- autorun macro by pressing hyperlink, help
- 255 character limit
- cells mandatory to fill
- shortcut for add-In menu
- Workbook by name open?
- Apply code to other worksheets
- Relative cells in macro - and pasting a formula too.
- Chabnging macros to functions
- Unload Userform doesn't work here - why?
- Re: How to use Excel VBA to query a SAP database?
- Help on excel macros
- My Macro crashes excel - anyone know why.
- Replace element of chart source?
- Using Conditional Sums/Averages on Arrays
- QueryTables - Excel 2000 to 2002 migration
- Deleting Specific Dimensions of a 3D Array
- Listbox - Rowsource
- Why won't this allow decimals...instead it keeps rounding...and won't format correctly.
- Extract tables - Web Querry
- Stop Workbook from closing.
- Using "dd/mm/yyyy h:mm" on Date Variables
- Is there any way to access the formula bar through VBA code?
- Copy & Paste (Merged & Centered)
- Arrange Meeting in Excel
- how do i use IF ELSE IF FUNCTION in excel to chk more condition
- Making cells mandatory to fill in if a previous cell contains info
- Does Excel Statistic Feature comes as a COM component or a library
- worksheet change
- Shared Workbook flag?
- Print area
- Forms and Macros
- How to retrieve data from web?
- Date converting problem
- dde link
- How to create different workbooks from a single worksheet
- navigate sheet onclick
- Print VBA in color?
- WorkBook VS General Module
- Unembed photos in a list of word documents from Excel
- Autoshape event handler?
- Spaces in a cell
- Tab order on User Form not working
- how to save file on different computers
- Calling subroutines from Class Modules
- how can I compute from degrees to degrees-minutes-seconds?
- how to do web login for web project on Linux machine?
- Need to expand Macro
- Range = print area? to unhide rows.
- =ROW-1, =SUBTOTAL(3,$B$2:$B2) don't work in hidden rows.
- VB and Excel
- Change date in URL
- SQL server does not exist or access denied
- Marcos and buttons
- From Outlook to spreadsheet
- case
- time
- Issue w/ AutoNumber Field during DAO Record Insert
- selecting adjacent cells
- Inserting rows
- SendKeys problem
- Compare and Copy
- Help with Lists
- excel chart to powerpoint
- how do import data from two sheets into one
- signing a spreadsheet
- Excel hangs
- changing the date separator
- hide macro in listbox
- Using double click on active cell to open a custom help window
- Two values in a combobox
- Collecting data from multiple sheets in wbk
- Use a lookup with a variable for the workbook name
- EntireRow.Delete only removing half of the rows
- arrays
- Macro for Saving!!
- copy formulas from a contiguous range to a safe place and copy them back later
- Excel crashes when copy
- Do Loop Won't Stop Looping
- Display a form prior to workbook being displayed
- Excel Developer Needed - Dallas, TX
- Restrict copy paste ability
- Test to see if custom menu exists
- programmatic grouping of columns in pivot table
- Listbox RowSource problem
- A1 in sheet1 =” =SUM('sheet2:sheet3'!A1)”
- Deploy Excel Macros
- Enter a number to the same cell for all sheets
- Problem with cursor position after Find is run.
- Showing Toolbar Buttons as Pressed...
- lookup function with 2 parameter in VBA ?
- worksheet_Change
- Still stumped with printing macro
- Move contents from one tab to another
- Deleting cells in Macro
- run-time error '91' - Close Button Error
- Compare to columns on two different spread sheet, only pick up the
- Reading from a closed workbook
- Adding rows within a list
- Finding major peaks and troughs
- Need help with UserName entry
- Trigger copy on AfterUpdate event
- Cell protection
- IF then question
- Using Groups on Protected Sheets
- Sum in hierarchy
- How to capture when a User changes the printer
- VBA Code runtime error only after opening Locals window
- How do I copy a cell with effects?
- Good Practice
- macros opening files
- Is there a way to make a sheet viewable but not selectable?
- ThisWorkbook
- Delete Files with less than 2 sheets
- Sheet calculation target cell
- Insert row for each different value in a vector
- Compare data with in a couple of sheets then output to a blank sheet
- VBA code question?!
- Merge and move worksheets
- setting error handling on control creation and deletion
- error code help
- Print Form
- Range parameter on different sheet not working?
- Combo Box tab navigation
- urgent VBA question
- Count Matrix
- Insert text in bold
- Does XML have equivalent code for ADO?
- Excel to Word
- sharing Add-In on a network
- Enter data into excel and export it to a webpage
- how to delete a string from another string
- I need instructions
- Custom Document Properties - Last Calculation Date
- Programming help statements into my VBA custom user defined functi
- Repost: NumberFormat/Autofilter/Rounding Problem
- Saving file to specific directory
- Consolidation of selected worksheet from several workbooks
- Connecting two checkboxes on different sheets
- Vertical into Horizontal
- Urgent.. Need help with Excel..
- Not empty but zero
- Pivot table Destination
- Pop Up box to filter based on User Criteria
- Problems Programming a sort to move rows
- How to test cell contents in a macro?
- how to erase the full content of a sheet
- MemoryFree
- Column with semicolon-separated values
- Does anybody know when Excel 2003 SP 3 will be available?
- Newbie, Variables not retained in sub?
- Simple Msgbox needed
- Play Sound File
- module not found error in Excel Marco
- Looping and creating sub sums
- check if formula parameter is a cell-adress
- ComboBox with colors?
- Userform Image
- Partial Searching on a row
- Using Solver add-in across multiple computers
- Web query excel 2003 not good for Excel 2000 code
- Convert workbooks of worksheets into different order
- Slect left and right part of text
- Reverse True/False with VBA
- Excel2000: Searching a value in named range
- VBA macro Cell argument
- Top 10 Values
- word to excel (how to avoid enter button marks?)
- Table To Text ( MS Word)
- Worksheet name anomalies
- Deleting ? Again . . . Sorry
- Create login popup for excel worksheet
- copy content of 1 sheet to another one.
- pie-chart problem using macro..
- Reduce the file size of Word file by removing all images in it
- calling a function
- Essbase VBA Functions for Excel Add-In
- how to input date only in A1 cell.
- Don't save external data.
- how to use dbgrid control
- Cell Values from a Closed Workbook
- Compile VBA Project
- insert row and add functions
- List of Environ expressions
- Can a non-modal form be viewed w/o Excel in the background?
- Index data
- How to load/insert/update an embedded word object to Access...
- Using EQUIV and INDEX fonction in vba
- Open Event not working
- Ctrl + Home on all worksheets
- Date format
- Convert column to text
- Ignoring Blank Cells in a range
- Pasting Banking Info to Excel - Debits and Credits
- Visual Basic in Excel to Control Internet Explorer Object
- hyperlink to other sheets in the workbook using vba
- macro to paste active cell's full path into another cell
- Please help with cut&paste to "Save As" problem!!
- Print Form
- Execute warning message
- Bypass Worksheet_Change Sub
- Convert every xls file in a folder to csv
- Data Validation based on range of values
- range name question
- Application/Object error in code
- Copy the body of an existing email in new emails generated via Excel with VBA.
- Why Excel programming???
- NumberFormat/Autofilter/Rounding Problem
- Hide/Unhide worksheets based on login?
- automate csv field change?
- Insert combobox in excel to complete lookup function
- AutoRun Macro Based on a Sum Calculation
- Change color of active row
- remove a control from a worksheet
- combining two short VBA scripts from two buttons
- update links when Macro ends
- Date and Day Programming
- Help, inconsistent results on Filter -> Unique, to new location.
- Selecting image on worksheet and deleting..
- simple: type mismatch
- Footer variable for user name?
- Copying then deleting every second row
- Problems with NORMDIST
- ExcelVBA Paste record In next empty next Row
- How do I save a linked word form a Macro in excel?
- merge excell data
- VB editor for word pops up???
- select rows of data & move to new column
- How to change the VBA Editor's font size?
- The reel address from a combobox ( bob phillips)
- doesn't appear Read-only notify alert
- XML to Excel 2003
- Setting the scrollbar positon
- Importing CSV as text
- Names not deleted until book closed
- Loop through a User-Defined Type?
- Return intesected range
- Named Ranges
- Delete record if cell is empty
- Code error
- Search for non alphanumeric characters
- Filtering in VBA
- Obtaining cell reference from index function
- Selecting values in the page field of a pivot table
- Random Number Generator
- Replace first 8 letters of filename with Macro
- excel on the web
- Inserting Proc-Call Into BeforeSave
- Commandbutton flashes, then laout changes
- Calculate,Copy, Paste Cell Group
- Range object in Worksheetfunction.Sum
- Macro to populate files
- Showing all in Filter
- Selecting Range
- Trim not working....
- Import dat. file
- Private Sub on the fly
- How to read a line from Ms Word
- How to make custom functions (VBA) read changes automatically?
- Macro menu item versus keyboard shortcut on pivot table
- Address from a combobox
- Porgramme a undo,Redo on a form
- Renaming a button using a macro
- Code to calculate the first row and last row of a range
- BaselineDate
- lookup
- Name a range
- How to name the list
- How do I make a Pivot Case sensitive?
- Ticklabel problem
- Conditional formatting a cell
- Tracking domain names
- How can I create a worksheet using Macro
- How can I create/add a worksheet using Macro
- word to Excel
- Avoid unloading of .xla addins when closing books are cancelled.
- How to add real time data from broker website?
- Delete two records together with looping
- Memory problem (I think ???)
- AutoFilter in C#
- Add area code to phone numbers in ranges
- "With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets
- Loop through worksheets to unhide rows
- dbgrid control usage
- Printer orientation with multi pages
- No toolbars or menus?
- Needless Horizontal scrollbar in Listbox
- How do I create an executable excel file?
- Compare values in different columns
- How do you make a column number its self in order from a given #
- How do you make a column number its self in order from a given #
- Pasting problems
- Common routine to handle a check box
- Saving the spreadsheet only with no code? Selecting shapes too.
- removing acontrol from the toolbar
- Changing Command Button Based on Data Entry
- Copy and Paste Special Dynamic Range
- Adding Controls in a toolbar?
- Perform code on all (closed) workbooks scattered across sub-folders of common parent folder
- Show only specified columns
- How to write vba to evaluate the text font and size on an active cell range?
- select one range and then go to next
- Inputbox/Regression Problem
- Saving the spreadsheet only with no code? Selecting shapes too.
- No additional controls in VBE
- Run Time Error 1004: Please Help
- Run Time Error 1004: Please help
- Tenure - Anniversary Year
- To find more than one Please
- GetObject method not work after Call Shell Method
- Selecting an output folder
- VBA Trim - has no effect in workbook- looking for ideas
- 1004 - Unable to set the hidden property of the range class
- Three loops to this circus
- URL links in Excel spreadsheet
- Why is c not a valid name?
- Formula
- Working with Cells on Userform
- Copy one worksheet from one workbook to another....
- Problem wqith connection to Oracle
- argument and Cell Color
- Disable Autosave via Code
- reference problem
- add automatically a component to component palette
- Sorting data with Named Ranges
- Why does this coding not work?
- Clear Contents won't work on merged cells
- Creating a check digit
- macro to list file name and path in separate cells
- Table with descriptions of ButtonFaces
- Macro asking for a password twice when unprotecting sheet
- Creating macros
- Cant run vba code independantly.
- ChartType inconsistent on various LanguagePacks
- Why is NewWindow Ignored?
- Oleobjects group box
- Macro help
- Funciton that Combines 3 or more Arrays
- user forms coding help
- why I got error value after running this code?
- Replacing Word text with Excel data problem
- VBA availability AFTER unsharing workbook
- Finding Empty Cells
- avoid overflow?
- Field width when printing to immediate window
- Newbie syntax question
- Compile error in my Application
- Printing with watermark in Excel
- Incrementing a number with non-decimal base
- Subject: Your Help Needed with the Data List Generation
- Auto numbers??
- convert excel formulas from english to norwegian
- Shared workbook-VBA availability
- Program to create a matrix
- Excel 2000 file when opened in Excel XP generates errors
- Use of check boxes
- How to define table array in Vlookup function using VBA?
- Sum up identical workbooks
- VBA Format Row Height
- Automatic running of Macros
- auto-size userforms
- Is Excel "caching" pages ?
- User forms
- Comparing columns - "special" case
- Your Help Needed with the Data List Generation
- Hyperlink
- If you dont know exact name of a feature, you cant get help on it
- is there any substring function in macro?
- Excel Links
- Screen Resolution
- Urgent simple formula help
- Printing specific pages
- Has anyone out there created an excel dart league template?
- Did LostFocus ever exist or is just a dream?!
- How can I put interactive buttons in Excel document
- Toolbar Query
- XML - VBA conversion (.uxdc file)
- ControlTipText
- Less than 10
- Change image in UserForm
- I would like to create a button on the worksheet to work a macro
- Value from form to excel sheet
- Finding the End of a Range
- Macro to copy range of cells and paste into 1 sheet
- Excel Date Question
- Areas
- Code seems to crash after clearing comments
- How to do this?
- Disabling VBE Break on All Errors Programmatically with DAO SetOpt
- Best Practice
- Progress Bar form window goes white
- Command button copy array
- VBA to get Google to search
- excel to powerpoint- paste a range
- Excel 2002 VBA code to return a page number within a worksheet
- Bold contents of a variable
- Zoom a range without actually selecting it
- wordart
- Does VB have SYMBOLIC CONSTANTS similar to C/C++
- Another If/Then ?
- Right Mouse click advances macro?
- locate picture location using macro
- Ron - Summary_cells_from_Different_Workbooks_2
- combobox question
- Lock down a wokbook
- Auto Rostering of Staff
- Reference to Item in Collection
- Create a list of unque entries
- deselect all option buttons in a frame
- date Calender user form
- XP Profesional
- Copy rows macro
- Date format
- some functions doesnt work in macro?
- Help with code to re-arrange data for pareto analysis
- how to make my custom formula in OLAP data source pivot table?
- Where to place code that changes a cell value?
- GetText Client Access AS400 window API Help
- Selection too large
- vlookup table in another workbook
- VBA to count rows in a sheet and increase counter on another sheet then print
- how to print to pdf?
- Adding Two Text Cells
- userform to store employee numbers...
- Matching Values in Columns problems
- Market data for different versions of Excel?
- Macro reading new rows
- i have to press sent to email
- FFT in Excel
- Help! complicated programming visual basic
- Automation : Excel::Font : get_Font does not work
- Combo Box code
- Adding digital signaure to multiple files at once
- Adding a coulmn total using a range name and sheet name
- remove stuff code
- Dynamic scroll area
- How to avoid an error dialog
- Help with Extending code (Comparing Two Sheets)
- DATA VALIDATION
- resizing a range
- Yet more problems with Excel forms :(
- Problem with a macro changing paths
- VBA Question (rookie issue)
- Where to place code that changes a cell value?
- LOOKUP Problems
- MsgBox, VBYes, VBNo
- Help me count this
- Recording maximum and minimum
- geting data from internet
- combobox question
- Excel printing macro problem
- VBA Help please (rookie issue)
- user input into active excel macro- prompt - respond -insert-cont
- ---
- Check Box Value
- list boxes
- problem in excel sheet
- excel
- Sort referencing incorrect worksheet
- Resource for Programming ...
- Strange Toolbar behavior
- changelink macro failing. Prior link is to a non existent file.
- working microsoft office using a single program
- Deleting groups of continuous rows where col K = "x"
- Page with tab names in cells
- Is it possible???
- counting occurences from multiple ranges
- resizing a range
- concatenting dates showing m/d instead of m/d/y
- Finding data of one sheet in another sheet
- Dynamic Toolbars
- <HELP>Modify calender code for a combo box
- [B]counting multiple occurences with data missing[/B]
- ".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlockedCells" not tabing
- select all cells in an active sheet containg links to other (external) workbooks.
- Deleting dates
- "next without for" macro error
- Row Color based on cell entry
- Excel Lookup?? Problem!
- VBA Password
- Proper SQL Syntax - DAO
- Match problem
- Need Some Help
- Specify data to import from other excel file
- Lookup problems
- Problem coding NextFind
- If Worksheet exists...Then run code
- mailing labels. . .but first, name list
- Inability to Capture Username
- Macro - copy cell contents IF
- Excel Runtime Available?
- Range variables and Freeze Panes
- combobox question
- Code Breaking
- Sorting unique values and returning values from a formula
- calculate time for employees in 24 hour operation
- If then else
- Inputbox/Regression Problem
- Array Data Not Persistent
- Sorting Numbers as Text in Pivot Table
- Help !
- Subtotals in a range of varying size
- Macro error-"Selection is too large"
- Populate cell IF another cell is blank
- How to Specify Multiple Rows to Hide
- How to indicate that the current visible worksheet is the active o
- Why does this statement give an error message?
- Multipling the value of 3 text boxes
- Move cell contents to another column IF
- Eliminating duplicate records using advanced filter even with unique set to true
- Disappearing drop-down box
- Posting VBA for Excel
- Need help with beginner VB question
- Merge and Move Data??
- Clipboard Limits in Excel?
- Sum workbooks cells
- program to print some landscape, some portrait?
- Working with non-specific cell references
- calculate now for user defined functions?
- Radio Buttons
- CSV file with Comma in text Field
- Reposting Date List Generation Question
- macro slow after printing
- Code Review
- Copying random rows to other worksheets
- Workbook Property or Method
- Keep data visable in excel from vbscript input
- R/T error 1004 - App-defin or obj defin error on last presented li
- Getting the last line of data in a data sheet.
- Formula via VB error
- Creating ToolBar at Run Time
- Workbook_BeforeClose: Cancel doesn't work
- Select a cel on a worksheet
- Help needed for combo box
- Post Code UK Structure Verification
- reposting: combining multiple columns into one column - enhancements
- Help needed with the list of the trading days between start/endDat
- Why does copy after worksheets command not work on some computers
- compare values
- Array Problem -- again!
- Any thoughts - VBA Slow Down with Range.Clear Command
- Private sub worksheet_change(bval target as range) issue
- Xml mapping
- getting Excel to create an extra column
- Macro on specified Workbook
- visible footer
- Run a macro after time
- VBA Help needed -- compile error: object required
- How to make a macro that automatically starts after clicking a cel
- After Save Event (Interop)
- Stop a macro
- Save As... / Save as Web Page... how to differentiate?
- How Can I '{F4} Key down event' on RefEdit Control?
- Pass contents of a cell to a macro
- Hide Enable/Disable Startup
- Minimizing windows for 50+ opened books at one go
- Macro in Lotus 123 to ExcelXP
- Help not sure what i'm doing
- RE: How to subtract weekend days?
- Event Procedure not working
- Excel warning "too many different types of cells", then crashes..
- CAN I GROUP TABS UNDER A "MASTERTAB" IN EXCEL WORKBOOK
- Use a cell value to point to desired location.
- Re: How do I link cells, sheet to sheet, to recognize row deletion
- What am I doing wrong, here?
- Determining volume/number.
- Re: Macros-creating new sheets
- Macro
- Checkbox Offset
- sum alphanumeric cells
- macro to search for a set of numbers in a row
- Can I link a row on sheet 2 to a row on sheet 1?
- Named values drop-down
- Excel VBA Lookup Functions
- Fork Truck database
- Running a Marcro when sheet is opened
- Stop the loop when found.
- Load forms from another workbook
- get module line from erl and procedure
- default = vbNo in Msgbox
- Open dialogue box and importing text files
- How do I turn a VBA script on and off with an entry in a cell
- Security Across Applications
- ReDim Variant array for worksheet copy
- changelink with the name and new name as strings is failing
- worksheet change infinite loop/calculate for user functions
- Can I call a sub procedure from another file?
- copy an array formula
- Localisation decimal problems
- Localisation problem??
- How to highlight Top 10 and Bottom 10 Amounts in a Column
- Copy contents if.......
- Is it possible to add a tab to the Options section in the Tools Menu?
- Macro code to open a workbook only when closed
- Basic question....syntax on active cells from a filter
- merge worksheet from different files
- What is Error "Method "Paste" of object "_Worksheet" failed?
- Difference btween Automatic and Manual calculations.
- Overridding the "already exists" message with the SaveAs method
- Setup/ sharing questions
- In Excel, how do I create a point and click icon?
- Input Box
- Returning Values
- For and IF statement error
- Reformat Number
- Remove Blank Cells within each row
- INDEX/MATCH formula in VBA to populate text boxes
- Why is Application.CutCopyMode False?
- Comments
- Pivot...and macro.
- Eliminating Toolbars,Sheet Tabs,Scroll Bars. etc.
- Insert Copied Cells?
- Split text like line wrap into multi columns
- Input box
- Dynamic Formula Built from Search Criteria
- C
- Counting occurences which includes text
- How to format number the same way calculators do
- Drag and drop images
- Help converting code to late binding
- need help revising
- Excel to Word and back again
- Color of custom button caption
- Problem with Excel Form and VBA code
- Formatting Month display via macro
- Excel worksheet cell comment box
- Combining Data from multiple sheets...
- Cell Link in a Drop Down - Where does it get its data?
- Counting occurences which includes text
- Cursor disappears / Cursor verschwindet
- Remove old selections in Pivottable row field dropdown list
- A Macro to search and sum
- Multiple range formula
- Cases within Cases
- Copy range using offset range value
- Systematically Renaming Ranges
- Defining a range for a look up
- Checking that file exist and if not display a message
- Date format from UserForm
- If ... Then Loop
- Cannot create object
- TRICKY: different data sets within the same page
- Macro To Insert Row And Add Data.
- Funtion that adds two named ranges
- catching cancel on QueryTable.Refresh
- [hyperlink] del 'browsed pgs'?
- Excel ODBC Driver with ADO
- Rollover Define Name
- Referencing sheets/objects
- Approach web-data via Excel
- Missing Sequential Numbers
- VBA opentext command
- VBA opentext command
- Publishing my excel workbook on the web
- Opening Word in Excel
- emailing a whole spreadsheet
- how to learn vba systematically
- FormatConditions(1).Formula1
- Use existing macro to create another macro
- Deleting Last values in an array
- Cycle through each row and look for string in each cell
- Macros to send email automatically
- how to record new macro using vba
- help I need a formula
- Disabling worksheet_change when deleting rows . .
- Disabling worksheet_change when running a specific macro . .
- Greater or Lesser Than Formula
- How do I retrieve the current workbook link in vba?
- Need code to pair off numbers
- insert Worksheet_SelectionChange(ByVal Target As Range) through vba
- replacing warning message
- Conditional autolist
- average with conditions
- Error Checking
- Print Area
- Printing PDF outputting to multple files - change to 1 file
- loop...until ..
- HELP!! automate excel pivot table from acces
- Select Date Range
- Automatic install of Add-in
- can you encrypt an excel cell
- Problems with a VB addin for Excel
- Changing title from default
- Visual Basic References
- Formula won't copy and offset as I intend
- Have I reached Excels limits? (this is a repost)
- this is code that down excel
- how to increase a spreadsheet's column number from 256 to a large.
- Have I reach limitations of Excel
- enable option buttons
- Why is Excel so bad at dealing with user forms ? isn't this a major unresolved flaw ?
- trouble selecting a named cell
- Combo Box
- how do I debug my Excel macro & make it actually WORK?
- Help with Visual Basic for Excel
- Insert Picture Macro.
- What is the server name of this newsgroup?
- Hyperlink in excel spreadsheet to email file automatically
- delete empty rows of a sheet
- Counting only values
- sum of cells
- delete just empty rows
- Save VBA without saving the workbook?
- floating list box in Excel?
- Excel User Conference - Few hours left - Early Bird pricing
- prevent same entry in a single column
- Testing a group of option buttons for a selection.
- Macro for text file with different size
- Use VBA to change security settings
- Attn: DP - Automating a dependent list - Code not working
- Saving sheets as their own workbooks?
- sending outlook tasks to multiple people
- Help with opening variable filenames
- Form Control for Cell Reference
- Excel aborts on file open...
- Excel Addin works that works on a template workbook
- Help with hiding rows by VBA
- Excel2003 could not load managed COM Component
- Justify Method
- How to get rid of #Value!
- Forms wont show in VBA.... is this a known bug or do I have a corrupted Excel file ?
- VBA code erroring in XL97...
- insert blank line at change of year
- ActiveX
- Lookups and references in relation to countA, sumproducts
- Solver Reference Problem
- Can you put a formula on a field that requires user input?
- Conditional formatting & Messagebox
- nested if vba problem
- Help! Forms that lose their show method !!
- User define function and dialog
- Conditional Formating - Change Color
- Dynamically populating textboxes on a form
- Orphaned Menu Item
- Save Excel file as Web Page through VB.NET
- Why does this code not work?
- Macro to do the sum at the last when ever type chages
- sheet namimg macro
- multi-column listbox on userform, multiple issues
- Detect missing rows
- Macros across office programs...
- VBA code merge Word doc with Excel data
- Macro Troubles
- How do I set an excel macro to run when the spreadshet is opened
- multi line caption on command button??
- Custom Userforms
- Having problem with subtotal helpme out
- macro doesn't do anything
- Plz help.....Problem in creating a dynamic form
- Macro To Find Data And Insert Row
- Can't use Vlookup on data range
- getting data from access
- Deleting worksheets privately
- help --- Commandbars
- keep getting type mismatch error
- Showing Forms using a public variable
- subscript out of range error for .csv file and vlookup
- data from userform to a cell on an execel sheet
- MacroOptions problem
- Count multiples and add to pivot table
- How do I write a formula in excel that will calculate time?
- Detect printer properties
- Controling Excel using Word VBA
- Plz help.. When a prodhiernr changes i want to sum the costs for this product.
- Filtered list for Combo Box ListFillRange - Nested Combo Boxes
- Using ODBC function calls
- How make Module remember closed status in VBE?
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.