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 |
- Server Busy message during printing from Excel after Off. 2003 SP2
- Data Validation combo box click - 2007
- How do i create a macro using copy
- How to open a password protected powerpoint file by Excel macro
- how to open a password protected powerpoint file by Excel
- Macro Record problem
- Need help in highlighting the cell color in VBA
- filtering two pieces of data
- Parsing a String - Call to Ron Rosenfeld
- Passing Information to and from Forms
- Excel 2007 - VBA Password Input shows after Excel is closed
- Looping with more than one condition
- HELP: Unable to clear values for control of type text in a userfor
- Change color of row (Col A thru Col Q) based on text value in Col J
- How To Use External VBA Custom Function In Excel ?
- Working in Sheet2 with data from Sheet1
- How to change to active sheet on macro?
- how to load a file
- AUTOMATIC EMAIL
- How do I print xls file into two separate columns on the page?
- Sort tabs numerically
- Sheet codename not working
- active control box name on worksheet
- Just a test
- Vlookup from closed excel file
- Equal list values.
- VBA Conditional Formatting
- XL 2010: Parent of a Range can be a Shape?
- Addressing HTMLText object in Spreadsheet VBA Script
- The last day
- simple reszie
- simple resize
- Delete all rows where there is no entry in Column 'C'
- Alterations/corrections on userform
- How to create a function in a code sheet
- Evaluate problem
- Formatting previous selection
- Problem with existing workbook with macros
- Problem with - sign in sheet name??
- Replacing spaces with underscore for specific expressions
- Change Times
- Parsing (again)
- Coloring Alternate lines
- Help - Need a Macro/Popup to Find a Date in a Sheet.
- How to open & copy paste a word document in excel using macros?
- How to Show/Hide Columns or Rows with no data via VB
- Change Color for Drawing Line Object
- Day of Week from dd/mm/yyyy
- delete file in addin directory
- Case Studies
- Running macros when multiple Excels are open
- SOLVER Reset command does not work in 2007Excel why???? Two Questi
- Swap Two Values in one Command
- dim
- Menus & Hot keys - works in Excel 2003 but not 2007
- Move data between ListBoxes
- Stopping a timer
- Web pop up
- Auto_Open over Private Sub Workbook_Open()
- Macro Help - Updating Master List
- Problem with the "Or" operand in Excel
- Problem with offsetting one row down
- How can this crash Excel?
- restrict a product eg 10*5=40 because 40 is maximum
- Need List of Embedded Files
- Input box to find date
- Method 'OnTime' of object'_Application failed
- Protection Problems
- Using a modeless form to show status
- Make (save) a file by using macro recorder.
- Need VBA Code to Select text boxes in spreadsheet
- Best way to copy and paste row of controls on userform
- Save as PDF not working on a domained Windows 7/Vista box
- export data between spreadsheets
- Need VB code to edit cell values
- Need Help Remove Duplicate Values In Array ?
- Refer a column in the 'sumif' function
- Help again!!!
- Thanks Everyone
- Lookup Cell Interior
- How do I stop my conttrols from resizing
- Indirectly referring to a variable
- Print sheets based on cell value
- Worksheet_Change?
- Automation of Excel Report using Access Data
- Error 1004 - Application or Object Defined Error
- NumberFormat not getting changing onFly changing the regional sett
- Alternate Column Shading to be applied only to visible columns
- VB converting UK to US dates, randomly, ignores cdate func!
- Find "invisible" conditional formatting
- Grouping
- VBA - how do I pass info from dropdown list to a string??
- Export Table Records to txt file
- referencing controls in userform from a different workbook
- Help with IIF statement in macro
- Macro for hiding all rows accept those selected by a dated column?
- Default Ribbon on File Open
- Exporting charts outside excel
- Code corrupts file (XL2003)
- Array - retrieve certain amount of recods for query
- How To Assigned "SelectionChange" Event To different Worksheets
- How can I use a IF Array combination to return values?
- Identify excel file on taskbar
- Odd VLOOKUP Error
- Macro to merge cells of the same colour/pattern index
- how do i allow fields to be either input or output in excel?
- autofit with wrap
- VBA problem.
- XL file opened using automation - how close?
- In a cell find words, copy and paste in another cell
- Find word copy and paste
- RE: How To Assigned "SelectionChange" Event To different Worksheets
- close excel; leave access open
- Automatically OPENing (GetObject) and Closing EXCEL via VB calls
- Help with VB code
- Showing Excel Cell Data in PDF Document
- Remove spaces
- RE: Array - retrieve certain amount of recods for query
- String search on two tables
- not in array
- Conditional Formatting v VBE code for desired effect
- Resize commentbox in VB
- "Do you want to update" msg
- Macro to delete rows
- RE: Code corrupts file (XL2003)
- MODI printing and combining files
- Protected project visible
- Using excel to Determine if a File Exists in SharePoint
- How to move worksheet into specific position?
- RE: Automatically OPENing (GetObject) and Closing EXCEL via VB calls
- RE: not in array
- RE: Odd VLOOKUP Error
- Pass Parameter from Excel to SharePoint
- testing for password protection
- RE: Remove spaces
- RE: "Do you want to update" msg
- RE: XL file opened using automation - how close?
- RE: Pass Parameter from Excel to SharePoint
- RE: testing for password protection
- Formula for Data Validation
- Send a worksheet to an open email
- RE: Macro to merge cells of the same colour/pattern index
- RE: Resize commentbox in VB
- Converting a HEX string
- Can you calculate delta time using different entries
- Remove add-in
- RE: XL file opened using automation - how close?
- Print Preview slows my code?
- RE: Macro to merge cells of the same colour/pattern index
- RE: Pass Parameter from Excel to SharePoint
- How To Remove VBA Code For Distribution of an Excel Sheet
- starting a function will not allow comm_button
- RE: Remove spaces
- Show / Hide items in Pivot Table as required
- RE: Macro to delete rows
- RE: not in array
- automatically number a table in word document
- RE: XL file opened using automation - how close?
- RE: Odd VLOOKUP Error
- RE: Removing or deleting Checkboxes from workbook
- RE: Macro to delete rows
- Have VB Code "on" for all workbooks
- code to delete vba code
- Can we set the UI color scheme via VB[A} or XML?
- Change checkbox value
- Conditional Formatting with Hyperlinks
- RE: Remove spaces
- Rotate application
- RE: Can you calculate delta time using different entries
- Calendar Control
- Linking data with variable cell location
- using the cells property for use with Application.WorksheetFunction.Sum
- How to access macros via tool buttons?
- Sorting stuff into alphabetical order
- can I use code to make code in another book
- VBA to insert .xlborder if cell value not equal to previous cell
- Optical Character Recoginition
- To show a message box if the mouse is over a particular cell??
- Fix Broken Cell Formula with VBA
- Cosmetics
- Reading system log files
- Icon in Notification area
- Icon in Notification zone
- Next weekday ...
- Next without For Error
- Copying worksheet from hidden instance of Excel
- Delete Columns if sum is 0
- Conditional formatting if condition of an if statement is true and astring value is displayed
- Looping Open and Save as CSV
- Calendar Control 12.0 help
- Reading properties from closed book
- Addins attached only to selected workbook(s)??
- Still need help with a code reference problem - Excel 2002 XP
- Timer question
- date handling problem with International issues
- Advanced compare of two worksheets
- Calling a sub on another worksheet
- Programmable Column Sequencing?
- Userform ComboBox Row Source
- Excel 2007 sorting ribbon is not working with .Net save code
- Problem With Code...Still
- Text Formats
- AutoFilter macro
- Macro for merging rows
- Code "crashes" after dynamically adding control to worksheet
- sumif help
- Email From spreadsheet
- Hand Icon when sheet protected problem ?
- VLOOKUP VALUE ERROR
- Printing sheets based on a cell value
- Autofilter macro
- MultiWorkbook Change Event Detection / Spell Checker
- Automatically Copy Information when data is entered
- VBA Dynamic range in Pivot table
- Open Excel file from SharePoint; opens as ReadOnly
- For statement behaving very strangely
- Newsgroups going bye-bye
- Non existent code reference problem
- SendTo
- EXCEL 2007 - export to dbf files
- Exporting to .txt converts single quotes to double quotes
- P.S.
- File not saving
- Autocompletion For UDFs?
- Autocompletion For UDFs?
- New functions needed
- Comparing Apples and Oranges
- GetOpenFilename code execution interrupted
- Copy data in table to column in worksheet
- Create a list with multiple criteria
- Parsing a string
- Register HelpID via Categories dll
- Using Color as Criteria in Countif Function
- Finding the end of Data
- Protection
- Answer Message Box - Other than Y/N?
- Running another program
- Controls in a frame within a frame are always invisible - What am I doing wrong
- Pivot Table Macro Run-time error
- Button to add Rows on Form in Excel
- Protection Tutorial
- Macro to rename Tab and then save as
- View what macro is assigned to a tool bar button
- Fire a macro
- please help.. highly important...
- Excel wait for Find Replace dialog box in Word
- Using Trim in a Userform
- Date programing in a cell
- Creating a formula which references a dynamic cell location
- Sort Order Doesn't Seem Correct
- Drill down pivot table data via VBA macro
- Latency on the move - without tripping down the stairs!
- Save in different folder
- Help with forcing chart axes scale
- How to code it in macro?
- Blinking Text
- BKF files
- autofilter master copy data to worksheet
- Coding for inventory
- creating a pivot with external data source (from access)
- pivot table with external data
- "000" reverts back to "0" even with a string
- Entry data sheet automaticlly updates or adds data to differant sh
- Re: Maintaining Text Box Font Setting (Excel) using VB
- One line is killing my program!
- Testing/Finding .Hidden for Rows May21
- watermark
- Check out Excel file from SharePoint; if no other Excel file is op
- Maintaining Text Box Font Setting through VB
- Problems with ACE OLEDB provider
- ounces vs. pounds
- Using Select Case on Single column only
- I need VBA Help for Excel spreadsheet -- Please!
- General Question on one line of code - parentheses and quotation marks
- RowSource property in cbox
- Open Add-In (.xla) workbook as Read Only automatically
- Change Gradient Fill Colors of Bar Chart data points
- delete single occurances in a string
- xlPasteValues is also pasting Formats
- Open & update another file (through macro) while running macro
- Conditional Formatting
- get Control of a Butoon placed in the Sheet
- How to prevent a graph update
- Redefining a table range with a macro
- value of value of a variable.
- Get control of a Userform by the Name
- Command Button to import worksheets
- Getting data from a closed wbook (adaptation of rondebruin's)
- Identifying other users
- Help changing Keyboard Shortcut assigned to Excel Macro
- how to disable update links message when opening files
- Macro to add / delete column
- Public Variable problem
- Save BeforeClose
- Check numeric char
- Prevent Save/Publish
- String Search
- Disabling Built-in items on a menu
- visual basic excel 2000
- Application.VLookup and External files
- Capture Date from External Sharepoint Portal
- SaveAs *.txt - Outputting with Text quantifiers
- Count Workbooks that are open; Prevent another from opening
- launch instance of excel without loading personal.xls
- Disable Save
- Running formulas with data from mulitple workbooks
- DTPicker controls missing from userform
- Columns("C:C").Value = Columns("D:D").Value not working after adding16th page
- Setting a reference to the Ribbon
- Unlink chart from sheet
- Option Group actions
- Calling Excel shortcuts from VBA
- Calling Excel shortcuts from VBA
- Autocomplete Custom Functions and functions arguments
- Export Several Worksheet Groups (Values Only) Macro
- Fails to delete empty rows
- Code not working as expected
- retrun an RGB value to a specified cell
- Can I put something in the footer that reads from the sheet
- Cell colour format according to date
- Application.Visible=False
- "Update" calendar on userform?
- Send data to serial port
- No Subject
- Modify sub to work on cells with formulas
- Number of lines in the Immediate Window
- Set object with a function
- Open_Files_In_A_Directory
- To Simon :- Adware problems
- match two conditions to return value from pivot table
- Macro to sort, format, sum, a dynamic set of data
- VBA to check omissions and show/hide form
- Save as cell reference then email
- VBA Workbook Open Function
- Not sure what to call this
- Re: Deleting a Command Bar 14May
- How to display a macro generated menu in Excel 2007
- How to update .xlam file (add-in) while it is in use?
- use Excel Now() in VBA
- Option group controlling objects
- Sheet change event to return sheet name just left
- Insert Page Break After Partial Text Match
- Excel ODBC driver created table/inserted data lost on application
- Re: Track and write the number of times that sub is run into a cel
- File folder info. in Excel workbook?
- Custom validation rule - must be 15 increment of time
- What does Compile VBAProject do
- Autofit row height in only some rows
- Conditionally count unique values
- Bug Report: VBA runtime Access Violation
- VBA in IE window
- Re: formula needed to extract data from another file
- retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file
- Convert number to letter 123 to ABC
- Search Option
- Application.OnTime - Macro Cannot Be Found - Internet Explorer
- UserForm_Terminate problem
- loop through all worksheets
- stop VBA in solver when maximum iterations reached
- save(append) to an excel file
- Change Pivot Table Page Value
- Tracking an email when sent directly from Excel
- Creating a common starting point
- .PutInClipboard
- Help with VBA and SUM
- If no activity, display a UserForm; 10 seconds later close Workboo
- UserForm1.ComboBox1 to initialize
- Copying a sheet fails
- XL 2007: How to find out what keyboard shortcuts I've assigned tomacros?
- Special character in Input Message - Data Validation
- Run-time error 1004
- Kill Open Read Only Message on Open
- Array Sorting problem
- Re: Handling the WorkbookAfterSave Event in VBA
- Data entered in several cells before proceeding
- Lost horizontal scroll bar
- Probelm with Code !!!!!!!!!!!!!!!!!
- Browse to select a folder
- USE THE "IF" STATEMENT IN EXCEL
- VB codes
- Pasting Variable cell info into a macro
- How to code it in macro?
- Dynamic VBA for dynamic Forms
- Macros Menu in Excel 2007
- Runtime error 1004 application-defined or object-defined error
- RE: X = SHELL
- Nested If Function to be converted into a user-defined customfunction
- #ref error
- Problems with Read Only Workbook
- Macro to merge workbooks onto one worksheet
- Get Standard CSV File
- How to enable "enable automatic update" security setting by VB cod
- Replace more characters using replace
- Differences between VBA in Excel 2007-2010
- cell formula question
- Pasting
- Converting digits to characters (123 to ABC)
- VB code to open other applications from templates
- Opening Files on other User's Desktops
- SEARCH IS NOT WORKING
- Re: Opening and Naming Files
- Re: 32 bit DLL with 64 bit Excel 2010
- Re: 32 bit DLL with 64 bit Excel 2010
- Resize a password protected page
- Re: Handling the WorkbookAfterSave Event in VBA
- Exporting from Excel to Access DB
- How To Clear Drop Down Selection
- Help With A Variable And Functions
- understanding
- Summarizing multiple workbooks to other multiple workbooks
- How do you programmatically hide/unhide a command button in Excel?
- Marksheet
- Re: Save a backup file
- Getting data from a closed wbook
- Check row above for information if it has contents copypaste empty
- Test variable range for 'Delete'; then delete the row
- DTPicker control - Initial date
- Re: Basic Looping
- Re: Stop my timer
- Find and replace
- Type Mismatch Error
- button for saving all workbooks
- Help revising slow code
- Export Only Values
- Find and replace
- Solver for Inventory Control
- Re: drop down fill in
- Re: Opening and Naming Files
- Re: Call a subroutine from ThisWorkBook
- multiple 3D equations in one excel surface chart
- Excel 2007 "Protect Sheet" option not available
- OPEN WORKBOOK
- Controls in protected sheet don't response!!!
- Controls in protected sheet don't response!!!
- Event Triggered in Wrong Sheet
- userform validiation
- ThisWorkbook.Name returns a wrong workbook name
- ThisWorkbook.Name returns a wrong workbook name
- Can I refer to a sheet in another book by its codename?
- Upload data on sharepoint automatically.
- Excel
- streaming data into excel
- how to print autocad dwg's from excel vba
- Help with this code please !!!!!!!
- How to select a workbook?
- selection.copy = "picture too large"
- Return cursor to proper place
- missing Application.FileSearch excel 2007
- Negative to zero code
- Would like to locate a text box based on a search string and copy
- Help to find and replace between sheets
- Going through Named Ranges in only specific Sheets in my WorkBook
- Get a list of open workbooks and choose one
- Converting a “Delete Column” Macro to a “Delete Row” Macro
- How do stop a 30 MB Excel file from freezing, while I am working i
- Sorting help !!!!!!!!!!!!!!!!!
- delete rows
- See if cell is in Range
- EXCEL
- challenging sumifs?
- validating dates on a userform
- Print all tabs to a pdf file
- help with a sub
- Combine 2 spreadsheets by parsing from one to the other
- LOOKUP function help
- Before Cell Exit
- Can I call a macro from a specific book
- Userform Help Please
- MAX Function in VBE
- Error of "application-defined or object-defined error" in Goalseek
- Run Time Error 1004 in Loop
- Altering Paste Data
- Merge data by macro
- how do i make excel pick words i start typing
- MS Query problem
- Copy data into multiple workbooks
- can i sort certain entries from a big excel sheet
- Can I open a combobox from my code
- How to Lock VBProject Programmatically without SendKeys (Note:- Idon't want to Unlock or crack the VBProject. Just want to Lock itProgrammatically)
- Find and delete rows
- Scrolling Caption
- .Seriescolection(n).formula - size limitation?
- Copy/Paste problem from another app to Excel
- growing excel database
- Find Length and Format and Compare
- Getting rid of the green triangles in XL 2010
- Identify when Excel is displaying ### in a cell? (contents>width)
- runtime error code 1004
- runtime error code 1004
- Using c# object in Excel VBA
- Update Directory Path in Code
- Run Time Error '1004'
- Force increased width of GetOpenFilename dialogue box?
- A macro to authorize a user to run another macro.
- Pull out lastname
- Run a macro upon saving
- Change Picture
- Call List Macro
- Issue with expired digital certificate ..
- Open workbook without running Workbook_Open Event
- Finding a range and performing a function
- SumProduct in VBA
- treeview control problems
- What kind of workbook function should I used?
- Custom Function for Pivot Table
- Add-in doesn't load properly
- macro based on text or number
- Renaming tabs
- Personal Macro Workbook
- How to define the default value?
- Macro for adding rows if two different columns have a value
- Move columns of data from one worksheet to another in open WB
- macro open tabs
- closing file
- macro to automatically send an excel spreadsheet by email
- Count Timer Pause and Stop button
- Count Timer Pause and Stop button
- sendkeys
- row striping with VBA
- Alphabetize Macros in a module
- Skip condition if cell is blank
- Skip condition if cell is blank
- Macro to delete entire row
- SendKeys with enter
- copying the objects from a sheet
- Insert a function through a command button
- Startup files open while login.
- How to ???
- Open files while login, Pls help
- Figuring out MAX LEN in a given column
- How to map a shortcut key to a routine in COM AddIn for Excel 2007
- Sort by one column then another.
- How to redistribute microsoft.office.interop.excel?
- Data Validation AutoComplete Help
- Please help with Custom Views
- Concatenate Macro
- Hide subsequent rows based on pull down list choice - macro
- Excel 2007: UDF can't reference row below 65536
- List Box + Sharepoint Navigation
- Case format for getting cell value from a worksheet.
- Running code from userform
- MsgBox; if 10-seconds, assumed 'No' Clicked
- Trying again for an answer.
- User selection of charts
- Unhide/hide based on drop down list
- MACRO TO COUNT ALL OPEN WORKBOOKS and print
- require cell input before macro can run
- Macro puts text if keyword is found in cell above
- Open Save & Close Macro
- AdvancedFilter property?
- Looping Macro - Run Time Error
- FOR EACH NEXT Multithreaded !
- Can not show scrollbars using listview on a userform
- Excel, How do I make column A renumber itself if I remove a row?
- Subscript Out of Range Error
- Display a filtered list in a "rolodex" format
- Passing Array to function
- Vlookup
- if else if...
- How to close excel worksheet after 15 mins? once it opened
- Comment in every 10 the row
- Conditional formating of cells
- Copying a variable nuimber of rows
- How do I check error result occurring by filecopy function in VBA
- Worksheet "slideshow" in Excel
- How to turn off standard control functions
- Copy range if column N is empty
- fraction udf
- Copy range based on input
- RE: Workbook sizing
- Excel Data Validations
- Pivot Table from 2 worksheets
- Macro help
- Itemize a colum and fill down
- data file size increase
- Data aggregation with multiple workbooks
- Find matches in different spreasheets then copy and paste to new s
- Copy Sheet to Desktop
- WebBrowser Navigate Path
- Custom Menu Bar in Excel 2007
- Text to Column and Transpose?
- formatting of txt file
- xlFillDefault, based on values in ColA to ColZ
- Adding/changing registry keys
- How to count drawing object (text box) in vba
- 2003 toolbars problem
- Comparing
- Exporting to text file in multiple lines
- UserForm Delete Sheet Columns
- Control-Home key behaviour
- How to copy a workbook
- Can I stop the footer from indenting?
- Remove Excel addin completely
- Prevent user input, if adjacent cell text is identical
- WordMerge
- BUY PORTUGUESE FAKE PASSPORT/GREEK FALSE PASSPORTS,ID CARD SALE/MALAYSIAN FAKE PASSPORTS SALE ONLINE
- copy row heights
- Unable to assign macros to a new button in the current worksheet
- Choose which cell to paste data
- Getting compile error on WorksheetFuntion.Sum line
- find largest column width and ...
- extracting data from one workbook to another
- Declaring Range
- Workbook Macro
- Private Sub Workbook
- How to run a macro if I don't know the name in advance
- Adding a decimal place
- Display currency as calculated
- Speciefie table and not cells to sum
- Dynamically Create and ID OptionButtons, then insert Row; Loop
- VBA troubles
- Array to copy columns
- Sendkeys
- Can I tellthe difference between 'Save' and 'Save As'?
- Set objListObject
- How to programme this??
- File Attributes Function
- Worksheet protection
- please help about handling "#NUM!" error !
- Search a sheet for a word
- Macros on Windows 7
- Select first cell in active row?
- List words starting with a specific letter
- Excel formula needed to round up a value to a whole number
- Loop in Excel
- Loop in Excel
- how to perform function (e.g. Sum, Average) on VB 3-d Array
- Delete Columns Macro
- Apply formatting through code
- Any help with inserting, copying and transferring data.
- How to copy ActiveX Controls which are locked on a sheet
- Combine two cells without losing data cell formats
- Referencing Merged Cells in VBA
- Selecting multiple sheets to print to PDF
- Checking Cell Value for a Date
- Excel 2003: Printing a worksheet and setting properties
- VBA for All cells in workbook
- Running Excel 12.0 Application on Office 2003
- Help with function VBA existing code.
- Any way to use "standard" Excel functions inside VBA functions
- copy and paste from workbook to workbook
- Linking Large Text Database to Excel
- Find percentage of sums
- Fire event code with Hyperlink and copy/paste RadioButtons
- Lost X-axis after resizing charts using VB - not sure why...
- Any way to show / hide sheets
- To determine the font of a cell and change it if required
- XL2003 to XL2000 code converson
- Macro that delets rows if keyword is found
- Display Math Symbols in UserForm
- Worksheet protection prevents Data Validation code from running...
- copy and paste data from different sheets
- use formula on external data range
- how to close Read Only file without prompt to save copy
- Windows key and keycode
- Code to save Word-document do not work properly
- Copy worksheet, trying to paste to new workbook error assistance.
- Re: Microsoft Responds to the Evolution of Online Communities
- Cell referencing in Macros
- how to get DateLastModified name with wildcard
- Limit due to selected cells
- Run a sub every time a function is used in a sheet
- Sub to freeze cols up to extent of data in col Q
- shortcut keys
- Possible disregard formatting in exception match code?
- Linking Large Text Database to Excel
- Excel 2003 and Gantt Chart
- VBA used to resize objects?
- Call Macro
- Sum - to end
- Non-matching cells
- Create employee attendance db using personal.xls?
- active window on top
- AfterUpdate/BeforeUpdate and SetFocus
- Trying to Modify Excel code; Pointing to SQL Server Instead of Acc
- remove duplicates
- Removing Command Button
- Lookup Table
- ScreenUpdating
- insert a dash
- range calculate in vbe
- Problems executing commands on one file from another
- Create Tab delimited file with no quotes in Currency fields.
- MACRO BASED ON A NUMBER OF CHARACTERS
- Last Column With Data
- With Sheets("wildcard")
- transfer data range from criteria in 2 combo boxes
- I want to format lines in my footers
- Need Help! Need to Change Linked Source on Several Workbooks.
- Parsing thru columns to find the last number
- Referencing Defined Name in another workbook
- using VLOOKUP in a text box
- Screen repainting issue
- Copy varaible no. of rows to another woorkbook
- vbe command for making excel in the active window on top
- Locked problem when using .Clear
- remove crlf
- How to delete numeric characters in a cell with alpha numeric char
- Why is Excel 2003 changing the names of my macros??
- Find value in a column and insert rows above
- A generic "find" function
- Get Column Header Value
- Updating another workbook
- When extracting from column A no data
- "fixed objects will move" warning
- Autocomplete doesn't function properly
- Process all cells in a (user) selection - vba
- splitting names from one cell to two cells
- Re: Microsoft Responds to the Evolution of Online Communities
- Concatenate then Fill Down
- pagesetup.printarea cannot getting infos from .xlsx file
- Web Query Multiple Variables on a Mac
- create a macro with the match lookup_array is changing everyday
- Automatically control the font of a cell when a function is used
- Re: Microsoft Responds to the Evolution of Online Communities
- Problem formatting date as "dd/mm/yyyy"
- sumproduct in UDF
- Displaying the arguments of UDF in the spertip
- Macro to "find" the next empty cell in a range
- How to bypass MkDir when that Dir exists already
- Re: Microsoft Responds to the Evolution of Online Communities
- Run-time error 91 Object variable [2003]
- Help with activating window from Application.GetOpenFilename
- Worksheet Change Event macro fails intermittently
- Arbitrary data to Textboxes in UserForm
- Can this be done?
- Insert copied cells above hidden Named Range
- changing a cell to different colors
- Color change for Column Chart
- limit range to unique values
- Date question
- Problem converting script from Excel 2003 to Ecel 2007
- Excel Heiarchy and Highlight rows where certain data lies
- custom color for font color and or background shading color
- trouble using checkbox26_DblClick
- SUMIF criteria
- potential bug in copy method
- Update Multiple Charts then Print to One PDF File
- Using the FIND function in a loop
- Z order problems
- dsget
- Working With Multiple Source and Destination Ranges
- identifying text boxes
- Select statement or me?
- Range References in vba
- To attach file to a workbook in a addin.
- Cell context menu in XL2007
- Drop down-list translation
- copy several rows
- how can i apply a footer in every .exl file
- Save excel sheet as html then save to web useing ftp
- Macros
- running Excel 2007 macro in Win7
- List details in another sheet
- Challlenging COUNT IFS?
- Amnesty Bill
- VB to delete columns except these...
- Cannot search forum
- Formula that checks balances
- Deleting rows
- RE: Cannot search forum
- finding unique values and removing all duplicates
- Unknown object in the Project Explorer in VBE
- WEIRD - Excel is Changing the name of my macro
- Referencing cell range in another workbook with a formula
- Array again limit
- Get column of named cell
- conditionally formatted list
- Chart events
- copy range
- populating neighbouring columns based on drop-down choice
- How do I access a sub in a New Class
- move item in multiselect listbox
- Change fill color of cell
- Get column name and data type from closed workbook
- copy the data to all the columns
- Macro executing twice??
- Help in VBA code
- import Excel worksheet to SQL Server table
- When recording
- need to sort 2 column "" as a dictionary ""
- Help with Regexp, please
- Ratio ??.
- Freeze the Title in Excel
- Two codes in one set.
- Column Width
- not enough resources
- How to look up each Excel workbook raw in another.
- How to close file and hibernate?
- Splitting a string into columns
- Array Limit
- refresh linked query
- UDF
- what besides displayalerts statement
- Picture Orientation
- Prevent copy and paste in one column
- Which textbox am I in?
- Problem Copying Charts to PowerPoint
- Web Query
- The VBA IDE will discard changes without warning
- Minor puzzle: some UDF calls respect mixed case, others insist on lower case
- Error message on opening Excel after deleting add-in file
- message "fixed objects will move" HELP!
- Shape.OnAction stops working after workbook closed and re-opened
- DO Until Loop
- Porting a macro to 500 users
- Accessing the Data Connection Strings and Command Text (SQL) in VB
- Lookup based on reference
- Macro Help
- Addin UDF Registration/Declaration
- Use UDF In Conditional Formatting
- Create CSV
- range loop? help
- Help with error on PasteSpecial
- Textbox Validation
- XL2007 (or 2003): Triggering SelectionChange event
- How to copy specific number of rows from cells to cells?
- Does IsMissing only work with Variants?
- Excel VB application
- Printer PaperSize returned as a String - How
- Simple code to find the empty cells in a range and cells with number
- Limits in SQL query
- Drop Down Box
- Drop Down box
- Search within a single cell for a character
- Critique a function to convert time, please
- Excel 2007 Macro Security
- Copy the contents of a range of cells to a single comment(indicator)?
- arrays
- array values
- Enable Spelling Check
- Need VBA for Conditional Format of Row
- Apparent Excel 2007 chart HasTitle race condition
- Getting Data Validation to execute when using Paste Special... Val
- Checking if some cells are empty when file is being saved
- referring cell in macro function
- Is there a way to speed up Calculation !!!!!!!!!!!!!!!
- Setting up a macro that can be ran from any excel file.
- Count Images in an Excel Sheet
- vba project password
- Moving Macros to the Application Level
- Macro that searches for keyword and replaces it with ...
- Can I display an open file dialog from a macro
- Validating that named ranges exist
- Can you speed up this code?
- Passing a variable from sheet code to a module
- Help with code please
- Column Array
- Stop text to date conversion
- Hiding graphics elements?
- format a specific letter by code
- Converting strings to numbers
- Copy to Named Range
- Copy filtered data (Values only)
- Insert Shape Based on Cell Changes
- Sort bug on Excel 2007
- Click Excel custom menu item via MFC automation
- find a non-empty cell
- Check to see if subtotal is expanded
- Problem with file links changing
- copy multiple rows
- Array problem? List comparison?
- Compare two lists and get differences
- Case Method & Range Object Problem
- Tweak to display autoshape
- Insert character using Regex
- How do I create a hyperlink with a macro?
- Pop up message asks if I really want to edit the live office data
- Sort Worksheets Numerically
- names in file name
- Who is in a network shared Excel file
- Using iserror with greater than
- Check for other open wokbooks
- complex formula
- Excel Export to Access via VBA
- Excel Export to Access via VBA
- Sorting question sort of
- Copy a Sheet to an AddIn
- Help with sorting data
- Textbox (Object) Right Click Menu - Disable Cut
- Pointing specific textbox
- Count the Colorindex of a cell with a conditional format
- Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
- SUMPRODUCT is not working
- Using vba find
- VBA to open a PDF, print, then close - Stumped
- A macro for converting formulas to formula results only
- Macro to save a workbook
- Insert character in a cell using a keyboard shortcut
- Checkbox values
- Hide Columns Based On Date Value
- Color Definition
- auto copy and paste to another workbook by using specific titles
- force recalculation of function
- quicker cell concatenation
- Find date in row and move to cell
- Detect macro in excel file without opening it
- Save as vba excel
- Evaluate VLOOKUP in cells in column
- Selecting a cell according to the cell value
- NetDDE
- HOW: Click Formula Hyperlink To Trigger Macro
- Go to Date on multiple sheets?
- moved macros to new book now they don't work
- modify formula
- modify formula
- Autofit
- Calling one UDF from another in a different module
- How to find all UDF calls in all workbooks
- Establish if Offset RANGE contains text
- Application.ScreenUpdating = False doesn't work
- declaration help please
- Insert an autofiltered range into another tab
- hours / minutes
- hours / minutes
- programming 33 tabs with 1 chart on each, 9 series lines per chart
- automatic replacing of a VBE sub in all open workbooks
- Insert Formula based in cell user clicks
- Copy problem between worksheets
- Turn a range of cells into 'read only'
- Ignore Blank Cells
- VBA code to protect cells Outside a given range
- Loop Through Range
- Print Wide html reports using Excel
- Print only the used sheets in all open files
- 2 codes in one sheet
- Change cell font color when cell is clicked
- Wrapping entries in a ListBox
- VBA Code for Pasting Contents
- VBA Code for Pasting Sheets
- Call a Sub from another Worksheet
- Counting rows and inserting blank lines
- Macro not saving as
- Insert Pagebreak in Word document
- MSGBOX Run-time Error '13': Type mismatch
- Excel VBA 2003: subroutine to reorder conditional formatting rules
- Excel VBA 2003: how do I call an Analysis ToolPak function within
- Protecting range limits
- ADO connection Problems between excel worbooks
- Avoiding #N/A result
- Filter by error
- Inverse Matrix
- Column Coding
- Copy image in excel to publisher document using vba
- Comparing two worksheets
- auto_close give me additional information?
- is it possible to run code written inside a cell
- Formula- to create drop down down list based on diff criteria
- Combination to Two formulas with the Help of AND / OR / IF Functions
- Auto closing UserForm
- LoadPicture() error XL2007
- Fill Down based on count in another sheet
- Search multiple columns
- Save all codes in a plain text file
- Is the MSFT online help offline?
- Combo Box question
- Autoadjust range declaration coding when inserting rows
- moved macros to new book, now not working
- Worksheets and Events
- Slope from a range of cells
- Print all open files
- Autofilter question
- Open Multiple Files At Once
- Find and Replace using a Loop won't stop
- Can I get Excel to recalculate just one cell?
- lock first row and first column WITHOUT selecting Cell "B2" first?
- Show Application via Automation
- Repost - Updating Links on a network (original 4/9/10)
- Collecting data for MPG (miles per gallon) calculation
- Before right click:
- Lessons Learned
- VBA to export large tables from Excel to SQL Server
- Edit Query
- Open Workbook to Specific Cell
- How to limit number of Message Boxes on Validation Error?
- Add Information Box to Macro
- assigning variables
- Compare Names in a column and create single list with adjacent vla
- Color Variation
- Unlock cells based on colour
- Unlock based on cell colour
- Multiple reference locking/unlockng in formulas
- Automating a copy from Excel to Word
- Help, help! desparate for formula help!!
- Cannot write the contents of an Object to file
- Menu Add-in
- Initialise the registry values in a array and retrive the values asrequired
- Range Vlookup
- loop thru cells to find matching record
- moved code to new book - some doesn't work now
- Loop in Excel
- Adding to the cell value with a macro
- macro trouble
- Excel and Windows Live Mail
- C application connected to Excel
- Delete contents of cells in a range based on value of a cell
- Tagging formatting (cells with mixed formatting)
- Determine if the Excel Version is 2007 or previous
- Formula ?
- loop VBA request
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.