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 |
- Custom Class In VBA
- Print all named ranges
- copy result from a .xls file to another without macro
- Excel rank question
- Saving particular sheets in a Separate Workbook
- Macro to create/edit calculated fields from a range
- Setting Scroll Area
- For each control in sheet
- Problem on openning a program via Excel
- Urgent Help Needed "Re-orient data"
- Is it possible to import an xml file using VB or macro at runtime?
- moving through sheets in a loop
- Animated gif on userform
- Macro to find empty cell and select range to print selected.
- Shifting the position of x-axis labels
- Is this possible?
- Change Pivot Table Range
- Adding "WorkbookOpen" Code Programmatically
- Suppress messages/warnings using Workbooks.Open
- accessing/reading vba macro without enabling macros
- Sorting records with a macro
- VBA Calculation Error #VALUE
- printing related code question
- Merging a CSV and XLS file automatically
- How to write a range function?
- Why isn't XML on my Data menu?
- Dates in Pivot Tables
- Don't understand - Arrays 101 (Help)
- Trying to work with User-selected non-contiguous ranges
- looking for heat loss programme to size radiators
- Change Chart Series with VBA
- help help help arrange userform in vb classic 6.0
- I want to change the dollar sign to pounds
- Invalid Web Query errors.
- Multi-tab Setfocus Problem
- inserting a row
- using excel functions in a macro - not familiar with macros at all
- Data Type Problem!!!
- macros to export to txt
- linebreak in ControlTipText?
- determining if cell is a date or number using C#
- Size of worksheets
- How to create drop down menu for freeform objects?
- Fixing macro to choose a blank row
- detecting the first blank row in the spreadsheet and populate the blank row with data
- what is the formula that help when cell=0/cell=0 to be display a .
- Assign a color to the cell
- Need help with a macro
- changing Print Preview default value
- date and day calculations
- XML in excel
- Copy cells to table in Access
- Have drawing object automatically move around point on graph axis
- how do i learn to write excel macros?
- Average Calculation in Excel VB
- VBA for calucation instead row/cell reference
- Run-Time Error '1004'
- Copying marked rows to another sheet
- Cancel Button Routine
- combobox values
- Executing an excel macro and emailing a column in Outlook . .
- compare name and copy to current worksheet
- error message 91 when entering wrong data
- how do i save a single sheet from my workbook?
- Formatting All Sheets in a Workbook so I can Print
- Combo box error
- VBA programming books: any recommendations?
- VBA programming books: any reccomendations?
- Excel inserts single quote marks into formula
- close excel
- newbie macro question
- programmatically add Outlook control for user interaction/feedback
- Creating a "sensitive regions" image on a form
- save as issue
- Animated GIF
- How do I restrict an inputbox to 5<= string characters?
- How would I make the result row of a lookup the active row ?
- How to create a live chart
- Looping Help Required
- formatting question
- SumByColor(Rng)
- Truncate/Mod
- Command Code Confusion
- spinbutton enabled = false not changing colour
- union range problem
- Excel VBA Hell
- Copying a Currency Format?
- Cell wording should change if result is +ve or -ve
- Auto Update Time When Cell Changes
- Highlight the autofilter cell to make it more visible
- inserting conditional rows
- help, find copied cell
- Excel export to Access
- Changing this code
- Saving a single worksheet as new file before close
- COPY DATA CELL TO CELL
- Database Functions and Hyperlinks
- Printing non-excel files from excel
- pivot table
- Tabulating Player Positions
- Code
- COPY DATA CELL TO CELL
- Trim Help
- variable - insert blank row/select range
- how do i tell a macro to begin in the current cell?
- Reviewing toolbar always opens on one particular file
- Reporting data to UserForm
- romanian currency (ron)
- locking cells
- VBA Code Examples
- Search for multiple things at once
- Excel Pivot Table Drop Down Macro
- 24 hour time
- On load
- copy a string from worksheet1 at row a, column a to worksheet2 row a, column a
- Delete files with VBA
- An obsure application or object defined error problem
- Calculated Fields Based on Running Total Fields?
- Search Column then Paste Data at end of Row?
- Yet another progress bar Question
- Need to Search Column then Paste Data at end of Row? Advanced Filter?
- how do i change the numbers on the row header?
- Calculated Fields Based on Running Total Fields?
- Find first empty row in a worksheet with a Macro
- Variables that survive an entire session
- How to debig a UDF
- Save a file without saving the macro
- Need help adding accumulator cells
- Search for text
- Change cell data
- Userforms: Disabling - Enabling the X
- show userform
- Morefunc VSort with array of long output
- Exit with out saving
- How do I get data entered in sheet1 to auto populate sheet2?
- Find Match in another WB and return detailed sheet
- Find the Error in my Code Please
- cant compare cells with numbers in them??
- Export txt file problem
- Look up error handling question.
- Looping...but why?
- data between the dates
- Hide command button
- selecting ActiveSheet.UsedRange
- Prevent Sheet Rename
- User form help
- Naming range where the no of rows indeterminate
- User form x button
- File path...
- RE: Help needed Writing formula that totals data at end of column
- RE: Help needed Writing formula that totals data at end of column
- macro graph highlighting some numbers
- how can a create a print command button in excel
- GROUP BY & SUB TOTAL - HOW to do it???
- Re: My ultimate goal is to create an ID that will always be unique
- Textbox Content Type
- Protected sheet - add rows & fix Summary
- Forcing calculation through automation
- Sort by rows...
- GetConnection
- Inputbox help...
- Accumulator cells
- copy from three sheets to one
- axWebBrowser1_DocumentComplete event handle
- Populating a chart with Updating information
- VB Script to automate Excel does not run as Sheduled Task
- find and paste
- MISSING: Microsoft Word 11.0 Project Library
- Searching for a Date
- CutCopyMode is never xlCut!?
- Limit data entered to list (drop-down control)
- Disable Copy, Cut & Paste - First Post
- Connection Recordset Loop Problem with VBA - Help
- Password protection with grouping causes error 1004
- won't update formula
- TextBox Updating
- excel - sql
- message 'calculate'
- Why does this produce an error?
- Macros works on one PC but not on another
- Macro to empty row
- CopyFromRecordSet changes cell formatting
- how to copy data with out using paste method
- dos command for es\xcel to add an entry in cell
- how to search a string in VBA
- Auto Fill (number & its repeat in bar code) for stickers
- Return activecell's column header in Alphabet
- Network Macro Crashes (cannot Save 'read-only' File)
- ComboBox Problem
- Using a macro to import from another spreadsheet
- lock only formula cells without protecting sheet - leave open
- use of activecell.formula
- PLEASE HELP** Pivot table auto updating
- File error. Some number formats may have been lost.
- adobe VBA object
- How to copy a sheet and rename it with the value of two cells from the source sheet?
- Looking for rent to own/lease option in Excel
- Convert Date to number
- External Data Range Name doesn't refresh
- Sorting - use of variable sort key
- Run-time error '1004': Method 'Cells' of object _Global failed
- need help creating a...
- Macro gives error 9 unless Administrator
- Making several Excel Apps Visible
- VBA - Activate a PowerPoint presentation in a specific Excel windo
- VBA – Problem with compound SUMIF function
- Creating cell ranges
- Menu Event
- Control Class Module
- Using If Then to count multiple criteria
- Executing Excel menu commands from VB
- Convert and Extract?
- Prevent certain cells from being copied
- Macro Will Not Run on Some PCs
- Macro Will Not Run on Some PCs
- Macro Will Not Run on Some PCs
- How to prevent copy/paste of cell with validation?
- create a new formula?
- Toggle Between 2 Windows
- Add-ins not loading
- lookup value in sheet
- Excel Marcos
- Who saved the file?
- Master sheet to split sheets back to another master sheet
- squashed test in combobox
- Can't enter break mode
- squashed test in combobox???
- wierd error I cannot figure out
- Size bug with DTPicker
- Finding a named range based on cell value and copy/paste to same sheet?
- Using Button on User Form to save Data to specific Cell??
- MS Query hangs in Excel
- How to move data in Column A into seperate columns / rows
- Temporary File Error with SendMail
- limit to copying rows in workbook?
- Display Alerts
- Auto run macro on individual worksheet open
- open an other workbook to eddit
- Cut and copying cells in a macro
- What are hidden processes of SaveAs function
- Determining Row in Which Labeled Cell Resides
- use Outlook address list as time /date/ signature stamp in Excel
- Formula that will leave cell blank if cell is blank
- Conditional Formating with Function
- copy sheets with values only and NO link to old workbook
- Copy A Workbook Automatically
- prevent chart values from changing
- Populate a cell based on a keyword it found in another
- Populate a cell based on a keyword it found in another
- How do you move the selection one cell to the right in a macro
- Interrupt code
- InputBox Variables
- Where should the code be stored? (Excel97)
- Combine data from two sheets in two one
- <Parent> of the Clipboard
- How many rows are hidden?
- Need Excel VBa to display Arabic characters
- Highlighting row causing problems with other progarms.
- How to get a vba macro to show up in the macro menu
- Loop thru Range Help needed
- Creating a new folder
- Problem with sql statement in vba
- making a phone number to be just 10 numbers
- WScript.Echo... VBA Reference?
- Defining Names for variable ranges Using VB
- How do you remove all the symbols?
- Hlookup Errors
- How do I find duplicate rows, add quantity field & retain one reco
- Extra series in charts when created using vba
- I would like to enlarge a checkbox/checkmark to fit my cell.
- How do you control worksheet naming of detail from a pivot table?
- Finding unique values from a filtered range
- Automatic log on to website and download report using VBA
- transfer/copy data between sheets
- Hide Sheet depending on List choice
- Help with run-time error
- Insert row variable
- Excel Drop down List with Named Range
- macro will not run from vbscript. help please
- Hide combo 3 based on combo1
- Deleting evey nth column
- Hiding Column/Row Headings/Numbers
- if statements.
- simple... HasFormula ?
- MS Query in Excel problem
- Increase Row Height of every other line
- Find/Replace from Table
- Start Date minus (Years + Months + Days) = ?
- Please Help - Vlookup in a macro.
- change a range colour after copy to another worksheet
- Sub works sometimes
- Currency
- Issue with Hiding Sheets Depending on Workbook Name
- GOTO the cell which contains the cell link
- Textbox Help
- Auto Formatting A New Worksheet
- Unload CheckBox
- Excel as top Window
- If Array
- What's the difference between 'Set UserForm1=Nothing' and 'Unload UserForm1' ?
- How to change cell colour based on numer of months?
- Change font size in Msgbox or Inputbox
- how to copy an excel sheet with out using paste metod.
- Please help to detect this file
- Found a small problem........
- Scanning Barcodes into Userform
- Looping: Selecting elements from a named range to change calcs
- Importing select Range from multiple workbooks
- Probably a completely stupid question!
- macro not running on workbook open
- How to make an inventory of incomming goods
- Opening zipped/compressed files
- help with ron bruin site - preventing outlook secuirty help needed
- Where am I going wrong?
- Deleting excess rows
- O2K code in XP - what gives?
- Date in header
- Still need help
- Challenge Parsing characters in a String
- Numbers not copied from closed file
- insert page break
- VBA to Identify changes in row1
- How do I have a value appear when I reach a specific level?
- Importing csv data
- How to program double click of fill handle
- a difficult problem
- bold AND standard text via function
- how do i set up auto number in excel?
- Returning an array from a function
- Error creating Pivot Table
- Rich Textbox Control
- "File Download" dialog box
- Error when use find method in vb6
- excel error using .NET web application
- VBA - Get array of filter values
- "Activeworkbook" function not valid when workbook embedded in Lotus Notes?
- Pulling specific information from a sheet
- Read/edit/write from/to files
- Excel bombs out in macro...help please!!
- How to get get variables to move from userform to main sub?
- vbcsript calls excel macro
- How take form based data entry back to main sub?
- Possible to select a range of cells from a Shape Object
- how to disable insert column
- Range object lacks Value property
- Excel: Mass change relative cell refs to absolute (more than F4)
- Accessing clipboard through VBA
- Complex Variable Programming
- IsNumber in VBA (not IsNumeric)
- Partial correlations
- Partial correlations
- How to right-align data in a column of a listbox?
- automatic input company name & address pressing branch #
- Identifing charts by user selection
- command
- print
- Add a form to excel work book
- Range.Select error and screen maximizing error in Workbook_Open()
- Interaction between 2 UserForms
- Replace Input box with Project Array
- Boolean formula
- FORMULA
- how to hide a macro name from macro listings
- Range.Select error and screen maximizing error in Workbook_Open()
- How take form based data entry back to main sub?
- spontaneous update of Excel spreadsheet - HELP
- MS-Query / Excel problem
- Use optionbutton value to select code to run.
- C# VBA DLL issues
- Automation Error using Chartobjects
- How do i get the vba tool bar in excel 12
- HOW TO: Move a picture to the top left or top right of a cell via
- Extract and Save
- Hyperlinks being cropped upon save.
- Calling procedures from within VBA
- Color Scheme Trouble
- Excel macro for multiple series in a single scatter graph using 3 columns
- Advice on code
- How to return a list of all selected Sheets in a Workbook
- list box DELETION during a macro
- Outline, expand or collapse via VBA
- Help copying rows and arranging in new sheet
- Macro to Add Comments with vlookup
- Drop down list query
- Running SPSS from Excel
- Setting a criteria in an AdvancedFilter macro
- Running SPSS from Excel
- Help with VBA code
- Pivot Table - '% of Total' question
- Replace Formulas with Values
- indirect reference to a formula?
- Page Break by using Subtotals is wrong
- Opening a xls for append
- Use a macro to modify a combo box
- Hide All Worksheets Except Specific
- Getting the values of the points in a trendline
- Using Relative Reference in a Formula
- commandbutton to replace spinner
- Help with activating previous sheet
- Help with capturing user defined error messages.
- Excel Functions for Records
- PLEASE HELP...How do I update a pivot table with VBA?
- Would like to change all "yes" cells in a worksheet with "logged"
- Cell Contents as text in Msg Box
- Validating number of characters in textbox
- I have many excel files, would like to aggregate into one
- Can not change default folder to network resource
- Macro - Insert formula
- Excel 2000: Comments
- Deleting lines that are not needed.
- Able to open same excel workbook at the same time !
- July 19-21 London Excel User Conference
- how to print charts which are embeded in a sheet
- Is there a property to get the values for a point in a chart series?
- Automatic use of Solver in an Excel model
- Re: Send sheet rather than workbook.
- Send sheet rather than workbook.
- MsgBox containing text from cell
- automate filter
- Locking Data in a specific cell depending on selection of another
- mark and skip a specific row
- Kill a process - Could someone check this code for me
- universal worksheet name
- Protect HEADER and FOOTER ?
- Reading the row number with VBA
- Date Time Picker : Error 35788
- Recording Mouse Actions in VBA
- Help Please
- Help with code please
- Check File Existence
- Maintaining formatting - Excel => Word
- Excel=>Word
- Excel=>Word
- Help to solve login problem
- Dates in range not selecting properly
- command for adding value in excel sheet
- Tough one
- Using a variable to gain access to worksheets through codenames.
- If Not c Is Nothing Then
- How can use LONGLONG type of C++ Dll in 'Declare Function' statement?
- License addin
- insert rows needs to copy formula
- addin design
- Save addin in runtime
- Addins store data
- Formula Question Please
- Want to change text in a cell on sheet2 if date changed in sheet3.
- How to activate and control modem from VBA Excel
- Archive Attribute Excel 2003
- sorting the tabs
- Change Cell Color On Condition Of Cell
- insert row and copy formula
- IE & Excel
- Lookup Value
- Last used column
- Can I add code to ThisWorkbook module with VBA extensibility?
- Sorting through multi-item list
- Method 'CheckIn' of object '_workbook' failed
- Insert function
- Finding number of empty cells
- Hyperlink
- Inserting values in MsgBox
- how to make cell read only
- Can I right-align numbers in a Excel's VBA listbox
- Autoclose code from Bob Phillips not working for me
- selecting an AutoFilter value in code
- Visual Studio 2005
- Delete etxra information from cells
- 1-800 number
- Delete non-contiguous selected rows
- moving worksheet
- excel .NET Addin in c#
- test
- Help with Ron de Bruin Script
- Pause code in vb
- Go to last col
- Hyperlinks on UserForm
- GetObject how does it works ???
- adding a VBA name to workbook names collection
- text box to variable
- Find specific text and return coordinates
- Dependant combo boxes
- Excel look up contact card in Exchange via user form
- execute macro; save it and close using Application.OnTime
- Automation error
- close .chm with form
- View settings
- Code help
- Drawing Object in a Userform
- how to import .csv to excel
- Using a variable in solver
- Loading worksheets from an add in
- pivot table - multiple excel sources
- Running a Excel function from access vba
- How do I overcome limitations in Find-Replace?
- Updating a Named range Automatically
- Saving to a certain month folder
- Check Point in VBA
- Check Point in VBA
- Protect a Macro
- Increment Purchase Order Number
- Is it safe to add event proc. to ThisWorbook module, if yes how?
- In progess
- schedule macro - application.OnTime
- Common Dialog Boxes
- count the number of nonblank cells within a range
- Print Code not working
- Please Help..Neeed VBA code to delete information in a cell
- Open only one instance of Excel - 2003
- Selection of variable rows
- countif
- Access to the undo list in Excel
- Sorting with multiple rows grouped
- Open a document using VBA
- Problem to launch a program from Excel
- How do I post the date?
- Copying Rows from one workbook to another
- Copy a value in a column over blank cells
- inserting formulae
- inserting formulae
- Activating previously used workbook
- Shortcut Key to follow a Call'ed Procedure
- Get Line From Text File
- opening form in new instance of excel
- Select & edit items in a listbox in VBA
- Having problems with textbox setfocus
- more then 1 figure in more then 1 cell ?
- Macro needed
- Help with copying a range by selecting a cell.
- Outlook - Object Model Guardian
- Removing unwanted 'enter' character from comment
- Change Dates to 01 of Month
- Compare named ranges
- Sub to replace pictures in a workbook
- Re: Printer Dialogue
- References to other workbooks
- Calendar control doesn't work on some machines
- Help with user form - selecting more than 1 file to process
- Printer Dialogue
- Error in macro - please help
- vbYesNo message box
- Rand function
- Please help with this error
- Describing a Range with Variables
- Links Deleting
- search over range of worksheets
- Saveas csv file
- Recording a Macro to create a Pivot Table
- Set position of excel chart to cell A1
- How to detect row number of selected cells?
- Release of DocuCom PDF Gold 8 and Gaaiho by Zeon
- VLOOKUP and Multi Lists
- Dating local singles here for free!
- Round function
- Getting data from unopened spreadsheet
- How do i setup a page break for a group of values/ rows .
- help needed from someone with xl 2000
- Using linked cell to change value in combo box
- tricky SQL problem using VBA Excel to read Access File
- VBA - Saving Rows With Text Criteria
- Add amounts in a column based on transaction date in another column
- forms toolbar vs. control toolbox
- When To use GOTO Sub?
- populate the fields
- correction to the question
- automatically populate fields from the source file
- stopping a macro based on a conditional
- SUMIF based on 2 columns instead of 1?
- I need to go to a excel spreadsheet get a value for product/qty
- Worksheet close event
- how to change font size of datalabels of two charts in a sheet
- Vba recordset for Excel programming
- Run-time error 75 Path/File access error
- Auto-run macro after auto-query refresh (Excel2000,sr1)
- How to determine the height of a Range as an Integer
- Determining whether dynamic array has been used
- Can you open Access Database through Excel VBA?
- Please help me create pop up questions
- Re: Finding picture stats with VBA?
- Finding picture stats with VBA?
- Looping through dynamic ranges from multiple worksheets
- How would you access an email address in Outlook from excel?
- Time display 1/0/1900 after imported!
- help to delete spceial folders
- Excel crashes when adding code using vbproject object?
- Split() and a few other questions
- Sheet Name
- VBA Printing
- copy folder
- Compare Two Worksheets and Highlight Changes
- Closing Excel w/o Error message
- Excel VBA Printing with several pages in a sheet
- delet rows based on cel content
- Selecting just my text
- Need help using VBA to compare data in Excel columns, then manipulating data
- Adding Values
- date
- Embedded hyperlinks not copying right.
- Macro to Delete a Row
- Get Average on results of Autofilter
- How do I use excel to create a unix script?
- Excel forms - authorise / deny forms
- storing a value in code
- Select column by finding the text
- Worksheet Name
- Worksheet Change Event
- How to create a date conversion in MS Excel using VBA
- opentext
- restricting input characters
- drop down list boxes in excel
- How to copy module form one workbook to another
- Structure of Excel Links
- Macro Speed and Virus Scanner Installed.
- Combobox exit event search error
- Call function with adodb.connection Problem
- Formatting font in a list box
- programming input box
- Now not regonized as a built in Function, in some spreadsheets?
- Refresh Data
- solver error
- Textbox Keydown event not triggered.
- Adding two values
- R/T error - 424 - Why?
- Dynamic Conditional Statement
- How do I create this range?
- Quick question on Add-in
- FileDialog Box Question
- Scrolling in editor window of Excel VBA
- How to call a function of an user defined DLL from Excel?
- Help w/ .Range(passing searched cells) I can't do it
- Advice Please?
- code not working properly - VBA beginner (random numbers generation, no repeats)
- Set addin reference at runtime.
- i am trying to use a formula that accepts equates words to a cost
- How do i make a macro which opens a box at startup where I can enter a date which...
- Print setup - fit to page - zoom
- Macro
- Help Plz
- countif in vba
- automatically assigning pivot based on unknown range?
- automatically assigning pivot based on unknown range?
- creating and populating an excel chart from within word
- Copying rows to different worksheets based on a cells value
- basic coding question
- Row count
- Get external data from MS Access using variables
- Bingo Card Generator
- check Open Excel applications
- calculate time and multiply it by $ amount
- Macro
- Pasting Question
- Help with code please
- Using Ms form in Pocket Excel
- Search within range for first populated cell and copy to new workbook
- error when setting XValues for chart
- how to clear up mixed date/text column
- how to clear up mixed date/text column
- how to clear up mixed date/text column
- syntax when using a variable in a formula
- how do i find and replace using variable input
- how do i find and replace using variable input
- Basic Checkbox question
- Macro issue with Merging Non-Contiguous Columns
- Adding a custom label to a series point
- library/object name conflict in Excel VBa
- Create new excel files, Save backup of excel file
- help in VB for cell values changing in rows & columns w/result in
- PLEASE help
- passing a variable from sheet to form to another sheet
- Tab Colour Change
- Calling a function from Select case
- Newbie Q: Specifying external Sheet name from Inputbox
- vba toolbar additional controls not opened
- Problem copying data with ADO
- Re: Problem copying data with ADO
- Getting a value from a web page to put in a userform
- open a form maximized
- Problem with creating a named range
- Sum data in workbook 1 and write result in workbook 2
- How can I disable multiselection of tabs in excel
- Inactivating a Sub Function
- saving messes up my command buttons
- How to summarize two sheets in the third sheet
- validating input of textbox before publishing
- Avoiding the 'Update Values' dialogue
- running an XLS Macro from within an XLS attached as Object
- Border help
- Big problem with doing one part of invoice
- How to change value of cell based on another value of another cell
- Delete row if column criteria was met
- Excel2002 & Trapping Esc key
- Office 2007 Problem
- EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
- How to check if external .txt file has text in it...
- Sum Times
- Add open file to last files opened on Menu
- How to hide freeforms conditionally?
- help please (VBA to insert images)
- how to sense -1 value at any cell in a column
- advanced filter- no findings
- Does worksheet exist
- Arrange column after delete
- Downloading Refreshed Web Query Data into Adjacent Column
- Excel popup position
- Copying autofiltered data to a specific (changing) row using a macro
- R1C1 style reference as Condition
- Code assistance needed
- Text initially appears in a different cell to one selected until e
- How to "wrap" email names in a Macro
- compile error
- Comments
- Mass Delete/Paste Graphics in a Workbook
- Intellisense
- ** Imp ( can we use INDIRECT to access cells in other worksheet in the same workbook)
- what should be syntax for evaluate Indirect
- Evaluate(Indirect) doesnt work
- fastest sorting routine for 2-D array of long values
- Using Arrow keys in a macro
- evalaute concatenation gives problems
- Macro to print and email a pdf
- increase rowheight to show imported text in full excel 2000 VBA
- Help referring to query tables by name
- Tutorial - Use MSCOMM with a serial device
- simple question
- Pivot table code help
- VBA to open in different browser
- How to assign a macro to a key e.g. ctrl-S
- Change a constant from VB
- Sendign email from within Excel
- Outlook 11.0 Library
- Workbook Condensing Problem
- start a copy of data at a line depending on date
- Help Please - last bit of code needed
- Find cell below last number in a column
- Extracting Numbers
- Need More Help on Stuffing Checkbox control
- Copy rows that meet a certain criteria
- Frustrating Boolean/loop iteration problem
- Multipe file transfer using FTP
- Re: Frustrating Boolean/loop iteration problem
- Inserting data into a different worksheet
- floor and rounding
- run time error 1004
- Need help with For-Next problem
- vlookup txtx and sheet...
- print preview
- Determining number of pages
- How to stop the popup warning window when clicking on a hyperlink
- YES/NO Button - Tied to Macro Functions
- DT Picker control
- Excel macro works with keyboard shortcut, but not command button. Please Help.
- syntax issue
- instrução OpenText
- Roudup problem
- Saving to network - trap error
- Stuffing Multiple Checkbox Captions
- How do I make excel talk to outlook using dates?
- Rollup the SUM of a column until last non empty Cell
- Excel Macro Advise.....To Open The Template Dialog.....
- inputbox with wait
- Sumproduct and wildcards
- Obtain folder names in a excel sheet
- Filter Problem
- NEED HELP WITH FORMULA, possible an array
- Variable Error
- Bloomberg xl function - a simple question
- Returning Arrays, emulating standard function behavior
- Combine workbooks into one master workbook.
- Excel VBA Form error message
- Is there an easy way to do this? (formatting numbers)
- Re: Can anyone help me tidy up?
- Can anyone help me tidy up?
- Chose two printers with vba
- Protect/Unprotecting Sheets with CmdButtons
- Splash screen that is not rectangular?
- How do I create a macro for adding spreadsheets?
- Protect/Unprotecting Sheets with CmdButtons
- vlooukp with sheet and txt file
- Problem with rngCopySpot.CopyFromRecordset rs
- MACRO FOR READING MANY FILES
- setting rowsource
- email question for ron debruin
- On Error GoTo Failing - HELP!
- Shortcut contents
- Default value in empty cell
- Page set up across multiple files ? x
- macro vbscript doesn't run !!! I am desperate! I need help
- Determine Last working day of Month
- Determining Last Edit Name on Excel Workbook
- How to find the addresses?
- Incorrect date format when opening txt or csv files via macro
- Arranging rows function wanted
- writing macros in excel
- Sheet-Variable in Berechnungsformel
- Anyone help to improve my code?
- Passing calling workbook name to called workbook
- Problem with RICHTX32.OCX
- Hiding Row based on cell value
- Saveas with date problem
- user form, saving values
- Problem with compiling this VBA - help please
- Refresh external data
- Cells.find help
- External Data Query
- How to access the text selection when user is editing cell
- How to set user's input in textbox to be numerical?
- How to write a marco in Excel to delete worksheet?
- what does "Compile Error : Invalid Qualifier" mean?
- HPageBreak Row
- How to apply the trim function to a whole column.
- Can the Save Changes prompt be bypassed when using a volatile function?
- Replacing Series Point with Characters
- Variables description in a function
- Date comparison in VBA (MS Acess)
- In what version was the change event on a data validation list fixed?
- How to move a button with an assinged macro
- Need help please
- IObjectSafety
- ADO Excel Datasrc
- Word Color of statusbar
- Transpose a .csv from columns to rows
- Printing Help Sheet For Addin
- Professional Excel Development book question
- Is there an onload event in Excel?
- Understanding: "BUG: VB Hangs While Automating Excel Using OLE Control"
- Help !! How to scan Outlook e-mail contents from Excel VBA
- Help request for vb .net in excel
- Loop until cell is empty
- Need to open two macro excel files for macros to work
- 1004 error
- Find function in VBA ?
- conditional cell.value statement
- best image on a userform
- worksheet exists or not
- Excel Locked up behind splashscreen
- Multi Column UserForm ListBox
- RTD Server question
- Error 1004 Paste method of Worksheet class failed
- Selectively Populate Excel VBA Combo Box
- SUMPRODUCT
- Determine if a worksheet is sorted
- Transpose a .csv
- Event change copy
- Event Change Copy
- using odbc, get external data
- page break problem
- Macros
- Hyperlinks dialog
- Count remaining rows after autofilter has been applied
- Opening multiple workbooks in Excel through VB
- Macro to copy a row, then insert shift:=x1Down
- Creating a Flag based on cell value
- Automatic Page Breaks
- Copy rows to new spreadsheet
- Copy highlighted.
- Select all sheets and copy
- Trace Dependents not working
- Macro
- Range is not being picked up
- Re: Range is not being picked up
- Variable help
- Need your help. I need to add additional information into cells
- Disk id
- "Reference is not Valid" when calling fast fourier transform
- Macro
- Filter Macro
- Error trapping
- Cut selected value frm sheet1 & paste value to sheet2
- Excel into Word
- Minimum DatePicker
- Run Time Error 1004!
- automatic email notices
- automatic email notices
- Automatically update print area
- Alternitive to Collection of Ranges
- RTD Server question, Excel to Excel connection
- Programmatically counting info from formula
- Differences in controls on forms and sheets
- Explain some things please
- Barrier Option
- inserting code into a Worksheet_Change event
- sheets macro
- conditionally insert image
- Determine upper visible corner of sheet
- problems using Filesearch object when files have a password
- Formula Not Found - Urgent!
- how to get the recent values corresponds to the time
- Imported negative values
- how to link an Access Database from excel if it required a password to open
- Function to retrieve maximum value of Y axis scale in chart object
- ***PLease help. Need to Merge directory of files into one file.***
- Function to retrieve maximum value of Y axis scale in chart object
- macros run increasingly slowly
- sending excel spreadsheets to cell phones
- Vlookup Question
- Multiple combobox and change events
- Import XML Data
- Formatting e-mail generated by Excel
- How to get TOC shown in HTML Help when calling from VBA?
- Print Macro
- use VBA color the cells
- xlUDF
- Macro to automatically paste a pic based on a certain condition
- Passing Byte array to DLL
- Create a report using multiple queries
- Selecting charttype from macro is not working
- Making a macro interactive
- Change event for comboBox
- workbook_open execute macro
- unique list
- ComboBox Events Fire Many Times
- Answer to Saving worksheets as individual workbooks using code?
- Reffering to named cells
- transfering all data.
- Sumproduct Help Please
- Temporarily stop script
- Error: Double execution of macro :-(
- SQL REPLACE Statement (or similar) in MS Query
- Constructing a chart: HELP
- form using windows explorer
- copy and paste
- find text then insert new row above
- Urgent help Runtime error ‘1004’ Method ‘SaveAs’ of object’-Workbook’ failed ?????
- printing using macro - too slowwww
- Clearing cell contents
- Re: Always Sendkeys...
- Combobox change event issue
- End(xldown) not always going to last cell?
- List could not be retrieved
- Update cells, from a filter
- Export data from excel to IE form
- AdvancedFilter with Blank Rows - Any Help
- AdvancedFilter with Blank Rows - Any Help
- Stopping error
- Excel program only runs on one computer
- Lookup problems
- Copy or replace sheet1 from a closed workbook
- Standard solver in a macro
- Deleting unique cells in two lists
- Setting a Variable range in VBA
- EXCEL 2003
- Show only Print_area range
- Transfer data by defined name
- EXCEL
- Need help adding formatted textboxes
- sheet named as an integer
- Emailing from nominated email address
- Text Display in cmdbar
- Read .xls File Via C# Without Having Excel Installed
- Starting a 'floating' form once a spreadsheet is open
- Button on condition
- Programming drawing obj. to center around value on graph
- script to hyperlink and reference a cell value in the hyperlink
- How to receive e-mail using Excel VBA
- Loop to find next empty cell to the right not working.
- UDF with several cells output
- Inserting columns in rows with some text
- Time Loop
- need macro to page break between company names automatically
- Disable Security Warning
- Sheet change code
- Using a user-defined function from the Personal workbook
- Forms window comes back like Freddy Kruger
- How do I exit on blank cell?
- Does a worksheet exist?
- Importing multiple files into spreadsheet
- without using a loop...
- Re: Open excel file from password protected Intranet site(IE)
- Combination of left and right justification in a cell?
- Excel Indent function flexibility
- strange error when assigning macro to a form object!
- Desperate for AddNodes msoSegmentCurve Help
- Checking user defined types for Nothing
- Display % of Subtotal
- Obtain grand totals from a PivotTable
- weighting a cell
- VBA-Error Message Assistance Needed
- Jumping to a location in an excel sheet.
- Range or test for blank?
- global variables
- Rectangle with curved corners
- Referencing and loading Solver programatically - how?
- usedrange function
- What is the verbage in VBA to send files to Excel?
- Turning off the "We are sending on your behalf" message
- how insert pic into excel and have cells shifted to make room
- urgent help with autofiltering wanted
- How can I reset an Excel form that has radio buttons.
- Copying data & creating new worksheets - error
- A work problem
- Format for underlining a cell
- Help with rolling quarter figure on a pivot table
- Conditional formatting based on conditions in other cells.
- Pivot Table Run Time Error 1004
- Change Macro names
- IF ACTIVECELL contains
- How do I get VBA to generate a chart with square axes?
- CheckBox question
- Making a worksheet macro superfast
- How to load Excel startup files through code
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.