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 |
- Rusty at excel, could use a hand with a macro
- looking for any summary formulation program
- exel xlsm - line argument for automatic allow modify and contents
- adding if then statement in the formula below
- VBA delete certain cell contents if condition is met
- Formula to determine the number of work hours per month
- Save file with date from cell
- @ operator inconsistency in VBA .formula
- Undo all changes
- Delete range with formatting
- Activate the cell which was found by vlookup formula
- How to suppress a message box from popping up during a macro
- Date conversion
- Trapping an Excel crash
- Creating track on map from position data
- Rich text box control
- Activex component cannot create object Excel 365 for mac
- Overflow error
- Extract text from text string
- Extract segments of an array
- Multi-column listbox help
- Insert into presorted list
- Split up or delineate data
- VBA Script for Radio Button
- Listbox with dynamic strings
- Changing workbook name in named cell
- Path string has spaces
- Handle keyboard events
- Compare two Columns , and if is it a Match , copy
- Worksheet_BeforeDoubleClick subtract sum of cells below top cell
- Problem with hlookup formula
- Avoid ,,Select" and ,,Selection" in a few lines of code
- CRviewer14.dll - Crystal repotrs wiht VBA
- VBA Does not recognize cell contents
- Copy paste different size problem
- Help with named-cell referencing
- Eliminate duplicate words from string
- Step() Function
- Script Runner Pro
- Why this tooltip works ?
- Converting Numeral to Time equivalent
- Converting a Number to Time
- Deleting rows when Worksheet_Change active
- how to error-check text box values
- UserForm triggers File Corruption
- Moving a number
- Enabling/Disabling ActiveX Command Buttons
- VBA
- File Extension
- Converting three calculators in a workbook into one with a dropdown box (hardcoded)
- Copy paste in last row
- VBA for Selecting Last Row in Range
- Identifying PERSONAL.XLSB macros
- Express Array Function as VB
- Help pasing cell reference to user-defined VBA function
- X Y Scatter Excel Graph X Axis Customization
- Coordinates of a grouped line
- Excel VSTO: Selecting range according to properties
- Determine the end coordinates of an Arc and then add textbox
- Adding code behind newly created chartsheet - subscript out of range
- Skipping sheets when copying
- Syntax?
- Array formula for lookup a max value cost too much time
- Mark the first Unique Record in a list with VBA
- Reserve the Horizontal line numbers and information , but the calculation result is c
- Select identical column/rows based on the active cell and copy datato another sheet
- Can I put buttons on a sheet without selecting?
- Regular expression problem
- not sure but think sumif problem
- Fixed Pivot Table Row Headings
- Row by Row Comparison & Deletion
- Row by Row comparison
- Macro needed for identify relations between rows.
- Counts unique values based on 2 criteria in other columns (200.000 records)
- Dynamic Sheet & Range Page Setup & Printing
- Nested For statements
- microsoft 365
- Problem with class variable and Personal.xlsb
- Re: Odd or Even numbers (VBA for Excel)
- populate and list and sumup
- I need help with a formula
- Need help formatting a cell
- Importing multiple .txt files in a directory
- Macro to Find and Replace in a loop for a long list of rows
- how use SheetActivate in vba code
- auto load call vba in sheet excel
- countif sum for column
- same function edit vba excel
- My own text using right click "New note"
- Programmatic alternative to SendKeys
- Vba excel one colomn one colomn
- Shortcuts pinned to Excel on taskbar cannot be moved up and down
- vba excel copy paste 1 column to 1 column
- Extraction of emails based on criteria.
- Using registry for data storage and transfer?
- Web query and script errors
- ISNUMBER function
- Excel print object?
- Cell to be activated, which is a result of a vlookup formula
- Variable reference to noncontiguous cells...
- Copy multi-line variable to first empty row
- Get operator of a formula
- Running macros from UIeditor ribbon - Strange Step Into behavior
- VBA code to change numeric value to string
- Getting a variable's contents onto the clipboard
- After made a filter selection, hide to select visible rows based onthe registration in the visible cell related to the visible row above
- Using PowerShell instead of VBA, to automate Excel
- Excel 2007 VBA Book
- Help with VBA script for Excel
- Excel VBA Add-In - How to sell
- Problem loading Solver
- Simple Macro to Delete an Excel file at a specific Folder Location
- Excel Help
- Getting Office Version Number from Excel VBA
- Extract digits
- VBA "=STEP" equivalent
- Need to create custom function of this formula
- Recording a VBA Macro from keystrokes
- VBA Get operator in a formula
- Counting and unduplicating values based on the date
- Early exit from function?
- Parse substrings
- Count number of tab characters in a string
- Find position of date in string
- ByRef argument type mismatch
- Double-click event for cells?
- Unable to open Word file from Excel
- Sorting columns
- Copy a complete modulesheet from file to another file
- Search specific columnheading and copy/insert this column to locationcolumn A
- Application.substitute
- Use ADO to open a Word file from Excel?
- VBA time conversion
- Determine clipboard data type?
- Copy rows as many there are 'slashes' in the cell and split out thecontent of that cell in the copied rows
- Fixed length padded string
- Adding photos to command buttons
- Best way to load an existing spreadsheet?
- Load iexplore in a new window?
- Save rich text somewhere in Excel?
- Paste text into Notepad?
- Report within a row the Last used ColumnNr minus ForeLast Used ColumnNr
- Reporting the maximum date within rows with the same keydata
- only one of 2 xlsm files shows up in vba editor
- Re: Excel is Waiting for another Application to complete OLE Action......
- Re: Code need to be changed
- Set column width to fixed size if there's no data in it at all(except heading in row1)
- IF/AND statement with a Countif included
- Mac Excel 2019 XLL add-in
- Mark cell with a color based on 2 values setup in a text with a signin between
- Rollup/combine data from several below rows into the TopRow based on keys
- Cell Display
- Sum product formula with conditions
- EXCEL VBA Caching GET request?
- API Call Caching?
- Identify rows if in the row one of the cells within a range is colored
- Check row for conditional formatting (color)
- Using the red X (Upper right hand corner) for another purpose.
- Why the heck doesn't this work?
- Count the sum of multiply values in one cell, registered as part of atextcode, combine them per column and show the results in the next sheet
- Copy data of records to a templatesheet and save this template as pdffile (and then the other records one by one)
- Error during file read?
- 64K line limit still in excel 2010?
- Array Logic Test
- microsoft.public.excel.programming
- Questions
- Tricky regular expression
- Converting dates
- VBA for Adjusting Range of Named Area?
- How to Use QuestionToMessageBox with Input for Cell
- Error message: "Bad file name or number"
- Question... Marking the unique- and the first one of the doubles with1 or 0 in the column next
- Loop for text check in three colums and set a text code based on thisin another column
- Question; Combine datafields from different rows into one row and onecolumn if the data in column A is identical
- Code needed to populate a message box during a macro
- How do I add a column on 3 worksheets. and get 1 total
- the incredible shriking font
- creating a text prompt
- executing VBA macro in Excel from OLE
- Macro to find/report text in several files at once needs translationfor finding colored cells on the same way
- Pick up specific marked text (one or more then one) out of a cell andcombine them into another
- Split row into multiply rows based on combined values in a cell andthen make the values unique
- Dynamic Pushbutton caption
- populate or summarize data
- Userform textboxes not allowing input of any kind
- Searching cell with zero value and delete their content
- Update numbers
- Print Setting in a sheet for specifc area.
- move values from top of column B to bottom of column A
- covert data from text file into columns
- Cells(1)
- How to access API from excel VBA coding
- Delete rows depending on time value
- delete data in an execl from c++
- a button to add 1 to a SPECIFIC cell
- Code does not select
- Problem encountered with Debug.Print message being passed to subroutine
- Loop for updating data from sheet2 to sheet1 based with some rules
- Unable to 'Change Data Source' on Pivot Table
- ThisWorkbook.Save is suddenly slow
- Change a Search/report code for text into search/report color
- Enable Outlining / Workbook_Open / Auto_Open
- Remove leading zeros from string
- excel vba number of days expressed in weeks and days
- How to determine the name of a macro ran from the quick links menu
- Test request on Excel 365 for the Mac
- Re: Load bitmap on a button?
- Removing Words from Cell
- Relative reference problem
- Email: Establishing Primary Cell vs. Ranges & Matches
- Step thru Row No & Array Match
- screenshot window and send via whatsapp to contact
- Counting & Summing Multiple criteria over variable row range
- For each c in myRng insert 6 rows
- A unique ID for each row, also automatically after inserting a new row.
- cleanup if and sumif in worksheet/workbook
- Displayed results
- select one of 6 cells down in column
- Save and Close
- Help required for macro
- Run time error: 1004 General ODBC Error
- select rows that has particular number in Col D
- Data missing from chart
- Data in cells missing from chart
- Copy/Paste problem with =Proper function
- rows.count property returns 2 even though only 1 row was imported by querytables.add
- Excel VBA Code for Old Value New Value
- Range.Style code gives Run-time error 450
- Problem getting a pointer to a User Defined Type (UDT)
- Check how date is entered
- Task pane suppression
- Copy data from multiple sheets to new workbook
- Compute duration and miles-per-hour and total miles
- Time formula
- Pivot Table run-time error 1004 (PivotField class)
- footer character limit issue in Excel
- Pop up message needed dependend on certain conditions
- ActiveX ComboBox not working
- Installing and loading AddIns in multiuser environment
- Reverse Vlookup?
- File Path Issue in Excel 2016 for Mac
- Compute time differences
- XL2016 Form Controls OptionButtons - moving and/or graying option buttons
- Performance lag issue
- Prevent printing of certain sheets
- Change cell if wrong time entered
- Impossible to move a window with VBA 2016 for Mac
- Enter value in compute cell location?
- move data from a worksheet to another worksheet "form"
- Find Text, Then Return the Sum of its values in Col D
- date format
- Code Count the items in a named range
- Is it possible from VBA to run excel as administrator?
- How to proceed after crash with message: Microsoft Excel has stopped working
- VBA - Importing Access Query into Excel using ADO
- returning current date in form
- Code to replace specific text
- Copying many columns into one column
- Putting multiple rows of data at the top of each sheet
- Copying and sorting with some twists
- IE ActiveX Settings Launched from Excel
- Split and transpose cell value
- Help with my quicksort function
- Background color in cells
- How to do an auto sort on sheet2
- Including date in SQL Where-clause in Excel 2007
- Registrate date/time in a specific column for multiply selected rows
- Expanding range
- Help with removing Time from Date
- Code to show how to insert an in-cell drop down calculator and insertvalue of calculation
- Excel printing FOO
- Run Time Error 1004
- Formula required for Month wise calculation
- Count of time (attendance)
- Select the highest Date/Time stamp in a column, Show it in a MsgBoxand delete those after confirmation
- Select case target.address
- Changing plot color
- Incremental counter for change across multiple columns
- Macro for Copy PAste from different Workbook
- Re: Number of leap year days between two dates
- Formating cell from a specific text from a drop down box
- Comparison of Time
- vba Index Match Match
- Assistance in transposing multiple sets of data
- Case Select with 2 string conditions.
- Help on code to sample data
- Empty cell?
- Sequential variables (no array)
- Subtotal use macro to Sumif
- Calling operators in formulas
- Remove duplicates
- How to include meta characters in forms
- Recursive To non-Recursive Procedure
- Login to intranet and download excel file using vba
- Best practice sheet Change/Calculate?
- Clear some columns but not all columns and keep headers in all columns
- Code works okay, minor adjustments wanted
- New and Exciting Excel Content
- Turn positive values to negative values if condition is true
- How To Find Data Between Two Dates In Excel Vba ?
- extract number from a cell
- Excel Vba Class Modul Examples
- message box error trapping issue
- VLOOKUP formulas only set to values
- Delete CheckBoxes
- Data Cleaning Macro Continues to generate Error
- Copy one cell and merge into another
- Retrieving records from closed Excel workbook
- Input box, find number and go to cell
- Error Executing a Macro on Opening Q
- Breaking apart email addresses that list more than one on a row
- Incorrect number entry on Excel for Mac 2011
- Code to filter a pivot table
- list 2 cell values in saveas filename
- Help with adding hyperlinks to images
- Macro Required - 13th April 2017.
- Excel and VBA calculate the same formula differently
- Call subroutine based on combination of Option buttons (two groups)
- Re: Embedding Existing Excel chart into VB6 form
- Using timer to refresh webpage
- Change active cells - Excel 2010
- New Newsgroup
- Formatting multiple sheets within workbook.
- use chrome as ie
- Intersect operation
- how to use ADO to get sheets from closed file and the excel tab order(figured out with DAO)
- I need help getting spreadsheet names from closed file using ADODBwith tab order
- help with loop code
- need help with this send email micro
- Help with Counting Multiple Criterias
- Array list writing to an Array of 'scattered cells' ?
- Customized Inventory Software Required in Excel VBA
- VBA- Finding texts built from regex patterns
- Syntax for Cell type
- Excel Help!!
- Delimiter(?)
- Excel export to Outlook:- Missing Microsoft Outlook 16.0 object library
- Help condensing 2 step process
- separating text and numbers into different columns
- Create an array based on the subroutines in a module
- Controlling xlTiled windows arrangement
- Several issues
- Formula to extract certain texts
- Simple alpha numeric sorting
- Change event for all sheets in WBook
- Comparing two columns in different sheets
- Populating Publisher document from Excel using VBA
- close adobe reader window
- Running Word to Save as PDF
- Change the Values in a Column to 'Minus' If Q
- Split data in one cell like ALT-Enter
- Web reads - synchronous and asynchronous - long
- grouping cells within a column for a chart
- Conditional selection and printing of sheets
- Copy Row Above, with a Twist Q
- conditional formatting, bleh
- Claus
- select case help
- close a pdf file opened via shellexecute
- FreezePanes is a window property
- data connection table date help
- SQL help? group? anything?
- User-defined type not defined
- replace() funciton with multiple tests....
- Select rows that are 'blinking'
- MsgBox if within selected rows a specific column is not filled in
- sheet specific desktop shortcut
- Insert 5 Row if a Certain Value in Column A Q
- posting this here cuz the outlook programing group is very inactive...
- Out of Memory
- Count and report the number of red colored cells in a row
- Compare 2 Lists and Take an Action Q
- Sheet names in a drop down
- Fill Cell with Colour if Q
- Multiple Sort Ranges via VBA Q
- Autofill VBA Q
- Complicated VBA report... help
- Complicated VBA report... help
- Cumulative Column when using Sub Totals Q
- Copy of coloring format, now in diferent files (change of earlierrecieved code)
- activating activeX objects
- Re: FileDateTime(path) - doesn't work across network???
- File cannot be accessed
- Sort isn't working correctly
- Sort isn't working correctly
- suspending code execution
- Convert date/time to serial number and compare serial numbers
- Convert to serial numbers and compare serial numbers
- Convert dates and times into serial number and compare serial numbers
- Huge data set Find-Replace
- Watchdog timer issues
- Macro to Insert Picture
- Re: Earliest date & time
- Copy from workbk & Paste to project window
- Copy Active Sheet
- Simple array macro works on one sheet only
- Earliest date and time
- Macros to Refresh all filled Cells.
- Search Word document based on text in Excel cell.
- Interior.ColorIndex of a field based on filled colors in other fieldsin the same row
- Which activeX control currently has the focus?
- Check of related records in a column have data filled in in the next colum
- Copy format based on identical datafields
- Compare cell contents
- VBA to delete link to inserted image
- Copy a by macro special selected nr of rows into another file
- Camera picture resolution or sharpness
- Colormarking of fields based on colors in another sheet (difficult !!)
- How to different value from duplicate selection - macro help
- please help in VBA or Formula
- Stupid Excel tricks
- Save Excel VBA as tab delimited text file without quotes
- subroutine stops running unexpectedly
- tracking table data
- find different value from duplicate data - macro help
- loop ends unexpectedly before finishing loop
- Help with xPath - SearchNodes not returning any nodes
- ! exclamation point as pointer to active sheet with R1C1 reference
- Using very hidden macros (plus other macros) on a shared file
- for next with if
- Import Module weirdness
- VBA Code to find the Row Number of the last repeated row of aparticular date field
- vba code to send a filename to word without starting a new session
- Transfer data from one workbook to another workbook resident inNetwork, based on Date Filters
- Read (and parse) file on the web
- record counter based on column value
- ColorIndex count function
- Converting Excel Formula Arrays to Dynamic VB Array Code Help
- Inserting Rows based on cell differences and interpolating in between
- How to create backups of your workbooks as you open and as you close
- Worksheet_Calculate
- a twist on counting unique values in a range which contains blankcells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY
- Get data for matching headers thru macro
- Capture # of Button pressed to pass to another form
- Index and Match Help
- Error on paste
- Email on save
- ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly
- VBA - How to "execute" a dynamic variable assignment
- "Continue?" Message Box
- Number of records for last 7 days
- Need Macro help to stop repeating some info
- Convert Numeric Values in Column to Text via VBA
- Click on Webpage Box
- data filter via VBA
- Print, Save as PDF, Email PDF code
- Find and Replace Q
- Programing to save who and when someone update the file
- Multiple selections simultaneously from a data validated dropdown list
- Copying/cloning an object
- Error in VB Editor Coding
- Comments do not appear
- Active x control
- reverse of CHR function
- Writing formulae from array to range
- Clear Contents and Checkboxes Button
- VBA to read save messages on an Excel sheet
- Pivot wrt active sheet & current region
- HLookup/Needing Formula Question
- VBA to send Outlook email - stuck in Outbox
- using formula - extract text separated by 2 spaces
- .SpecialCells(xlCellTypeBlanks).Delete without going to the sheet
- Putting Focus into Textbox
- Why full path in the formula to an UDF function?
- Checkbox Quandry
- Temporarily Suppressing the Printing of Page Footers
- Excel Add-ins for 2010
- My code stops working
- Key press alternative for Ctrl+Break
- Critique my filter/copy/visiblecells code...
- Automatically (w/o macro or vb) dynamically mirror one excel tableonto another
- A tale of two tables
- Conditional Formatting
- Exit when Cancel clicked.
- Modify Code to loop back through table after its been updated and process it
- Memory Overflow issue (clear worksheet that has Worksheet_Change action)
- MID and FIND function in vba
- Loop through a filtered range and copy unique values to a second sheet
- Loop thru filtered sheet, copy unique values to another sheet
- [ NEED HELP ] Loop in VBA
- Run time error '49': Bad DLL calling convention - solved
- populate =IF(... dynamically in loop, possible?
- dynamically change IF formula in macro, possible?
- Need to get a Page Number for a Cell
- Need help in creating sum macro
- Sub or Function not defined - Call to a sub in and XLAM addin
- VBA Programming
- VBA assistance needed
- data validation using VBA, best practice?
- req. for ideas for numeric worksheet
- VBA: Can I Use Named Columns for Sorting?
- Set value from comparison of other cell values?
- Convert a Find/Loop to an Array macro
- Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats
- Embed drawing toolbar textbox or word doc in sheet, how to refer toit?
- Even larger fonts
- activeworkbook connections.delete not working
- Is it possible to copy vba macros into a workbook using a vba macroto do the copying
- Working from data converted from a pdf file
- VBA assistance needed, Grouping and Tables
- Can't find project or library
- Copy sheet name to same cell on each sheet, 50 sheets; run code onany worhseet beforedoubleclick
- Macros not enabled
- Upload an image depending on the value of cells
- Determine closest control to MouseUp event?
- Deleting rows from a structured table based on the value of a column
- F1 help in VBA environment opens sheet; send VBA to background. Howto stop?
- Trouble Counting how many times a Cell Value Occurs when Condition isin a Row and not a Column
- Getting #Value error on Sumproduct with non-contiguous cells
- VBA error 1004 on With worksheet.Paste
- Copying down conditional formatting alone
- Remove unicode characters from cell containing values
- Hide colums based on a value in cell A1 (refered to the number in thefirst row of each column)
- Hide rows without data in a column based on active cell
- Set the copy to column to a variable
- COUNTIF VBA
- Worksheet Change event question
- Conditional formatting activecell offset
- Columns I to Q range variable definition
- Insert from paint and resize
- insert from paint & resize
- Excel Experts
- Hyperlink usage
- How to get Next Drill Down Value from Pivot Table via VBA code
- Question about Macros in Excel
- Repeat values in a list x number of times
- Currency change via vba
- Currency change via vba
- is a database user a member of a group in active directory
- Writing array to a range
- Issues with Slow Print to PDF Program...
- Pivot table - VB code
- Possible resources issue after running macro
- range does not return limits correctly every time
- Help with VBA and Counting Conditionally Formatted Cells
- Question
- I need help cross referencing...
- global user-defined name (range) - or help with holidays
- Issues comparing the values of 2 input boxes to cells and have eithervalue be able to be text or numeric
- Concatenating strings into a variable
- Graphics quality degrading
- activex Control (ComboBox)
- Excel automatic mail (Gmail), with conditions (verify cell content)
- Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help
- Extract Data from Dataset
- Help Please - picture not embedding
- Median Regression
- Help needed: Conditional Formatting for 3 columns, any two of whichmust have data
- Need help with a slightly modified Internal Rate of Return calculation
- Help with a simple macro
- Date range in Data Validation foiled by "Today()" function
- Question
- Find And replace macro
- SUMPRODUCT throwing a #VALUE error when using range instead of single cell
- Calculating the average value with criteria
- Converting personal.xlsb to personal.xls
- object.CopyFile() has an error?
- Question about ActiveWorkbook.SaveAs()
- Excel to new database project
- VBA Code for Hyperlink 23rd Dec 2015
- Trouble sending email via VBA using specific account
- Help Required (19th Dec 2015)
- Basic question about dates
- Copy a folder's contents into another folder?
- Best place to find an Excel contractor?
- Select multipler folders?
- Text with stripes?
- New sheets from a Pivot Table
- Worksheets dilemma
- Query for Array !!!
- Write to other sheets cells and include Cells.SpecialCells(xlCellTypeComments)
- Query for Macro
- Change_Event macro dismiss table1 copy reinstate Table1
- VBA to stop if autofilter macro will wipe out all data
- For Each sheet in WkBook problem
- Can this code be optimized?
- A LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox
- Signature software Win10 linx tablet
- VBA to launch camera app, take photo & insert in a cell
- INSTR find copy sheet to sheet issue
- Office 365 Home Premium Excel VBA greyed out on Developer tab
- MATCH in reverse direction?
- Randomly pick/select cells in a range
- Repeat data on all sheets
- Logical based Horizontal Lookup
- Copy to sheet name in column 1
- Rearrange numbers in a range
- Date picker on a form?
- Tracking unduplicated clients
- Vlookup using 2 sheets
- IF statement with multiple VLOOKUPs
- list excel wookbooks and worksheets
- Update of two cells from a cell.
- Manage errors with multiple InPut Boxes
- For Each c In Range... is slow
- VBA to search for possible files in Windows Explorer
- Sheets(MyArr(i)).Range("L2:L20") to a variable range of column L
- trying to sum range in one sheet depending on the date in cell on other sheet
- Different criteria in the same pivot table or synchronized navigationin outline format pivot tables
- Calendar manipulation
- Re: Can you use VBA to toggle design mode on/off in Excel?
- Merging rows and data vertically based on first sno column
- Help with CopyModule coding
- VBA Rounding
- Re: ms antivirus started finding "trojan" in workbooks, any ideas howto narrow down what module it's coming from?
- Lookup in Excel from Table in Access
- identifying a cell with worksheet_change
- How to extract excel attachment from outlook email
- Code to add a comment and the text from a sheet range
- Delete Pictures in Excel 2010
- Transpose a column list to every other cell in a row on anothersheet, then center
- Resolving VBA reference error
- Bold & increase font size of inStr(...) character's position
- User Selection as to which Function to Run
- Calculate event to do what Change event does.
- Copy to the rows between 49 up to 29
- Macro to paste from clipboard
- Calling Analysis Toolpak.Regress (Regression)
- Application.Match problem
- Q to Automate Removal of Characters from Cells
- send temporary data without saving the workbook
- Use of MID function for Variable Extraction
- Extracting numbers greater than 5 digits from a string (variable position)
- If clipboard is empty..
- how to loop through textboxes
- Code to capture filter settings works but not for color filters
- Code to write to Index Match intersection
- pass value from combobox on form1 to a label.caption
- Macro to copy figures from Mainframe screen and paste at excel
- populate a combobox with filenames in a specific folder
- VLOOKUP to return value AND cell color
- Excel vba error when adding norwegian translated SUBTOTAL formula tolist - function name not recognized
- Quick and dirty function to test for MM/DD/YYYY value
- Combining VLOOKUP and IF formulas
- De-convert Dates
- Checkboxes and Captions Not Able to Return Value
- .Value "issue"
- Find Combinations
- Find multiple matches in other sheet column return row data
- Find Loop - not terminating
- Ghost Cells
- CheckBoxes and the Split function
- Code to do complete a Find and Replace on long list of values
- Referring a dynamic range in for Application.WorksheetFunction.Vlookup
- Excel formulas
- Loop for myRng for next set of 9 rows
- Excel Tables - extracting data
- VBA Sorting
- Unable to run excel via vbscript
- Excel 2010 Question
- Rearranging columns in a large spreadsheet
- generating e-mail w/ links to excel file
- Filter criteria in as a variable
- How to increment the k in LARGE(array,k)
- HELP! Private Declare Function won't go away
- Loop not quite working correctly
- Before_Close macro, How to...?
- Loading a unique list of names from a range into a combobox
- On Open macro not running correctly
- Dynamic range for Pivot-generating Macro
- how many rows since the last time this happened
- Iterate through all words
- Fast string comparison
- Open file in this document? (Word)
- Unique values in combobox2 in excel VBA
- DoubleClick worksheet macro to copy paste cell value to another sheet
- Paths and filenames
- Number and date
- Macro that repeats 4 relatively straighforward steps until end of list
- Delete the rows of the duplicates in a column, keep single entries only
- Application.GetOpenFilename
- Efficient storage
- Please explain copy/pastespecial issue
- Delete Rows on Conditions & Long Processing Time
- Deleting Rows on condition & Long processing time
- Worksheet for designing a garden
- Strange behaviour - empty cell being evaluated as numeric
- What is the proper dot.syntax to insert a select case within a With /End With Statement
- External links change values simply by opening workbook with commonexternal reference?
- Excel in dialy official use
- Add comment with author and text code.
- GPS Data from JPEG's
- A Boolean expression
- How do I Delete Rows on Range Criteria for Column A Cells Not Equalto specific values ?
- compare x to values in a range
- Auto Filter one short list vs another very long list
- A faster code maybe?
- Event codes don't fire with change or calculate
- The sheet name to copy to is in column H of the If Statement row
- chronological date selection
- Contains 29 February
- AccumulatedInterest Function
- how can i define x as 988 and then use x in several macros?
- Naming different ranges in the same column
- Table column in VBA
- Summing To Same Cell Reference
- Breaking down my macros into pieces
- copy row from one sheet to another if certain condition is met
- Modify this Array
- Deferred row deepening
- Dynamic sort
- Loop thru cells & isolate numeric string
- break out lines 8 times and apply a decimal to selected values
- Filter column A and copy column if cell in row has header
- ambiguous names
- CR LF problem
- Change column width
- Dynamic Autofilter using VBA
- Get_Cell_Number
- regEx replace
- ByRef argument type mismatch (repost)
- ERROR MESSAGE ON CONDITIONAL MESSAGE
- Access Query
- Array instead of loop I'm sure
- Fast string replacement
- Fast way to truncate string
- Re: Debug Macro Usiing Step Into
- Delete Pictures in excel
- Parse with newline "0D 0D 0A"
- Must add 1 to InputBox entry for code to work properly
- VBA to access data from closed workbooks
- Extend a macro rule for setting color and specific text
- Monthend Dates Extraction
- Please help in fixing my Macro
- Delete Object, not Working Correctly
- Get character code within string
- Remove newline char from string
- multiline inputbox
- Returning Value Based on Two Different Ranges
- Line Input is reading extra lines?
- Import multiple text files
- Code to copy header does not copy
- Use string variable as Object name
- Extract word after 3 spaces
- Listing of sales categories...
- Strange Condition on Date Value
- Cross reference 2 excel docs
- run time error 32809
- Split Monthly Forecast into Weekly Buckets
- compare text in cells
- Duplicate declaration in current scope, but not so
- vba worksheetfunciton.sumifs w/ nested array help
- excel 97 -Trusted source security tab now missing
- How to extract all numbers preceded by a dash
- Understanding Issues with INTERSECT function in VBA
- understanding issues with INTERSECT function in VBA
- Conditianl formating with AND formula
- Extract paragraphs from text file
- Ctrl's renamed from 2013 to 2010
- has Excel software updates disabled VBA functions?
- COM addin won't connect when workbook opened via another workbookfrom another instance
- My Never ending ARRAY code problems
- Supressing a #VALUE! error returned?
- Array coding type mismatch
- CommonButton was out of function since Dec 2014
- Paramterization in Excel using VB/Macros
- Cell comments
- Trying to find a way to calculate subtotals for different sections data validation
- Help with IF/And Function statements.
- Hide / Unhide each row from StartRow to LastRow for multiple conditions
- Progressive number in different sheets
- IF(AND(Complex Formula in Error in data import before I process it
- interesting take on knapsack problem
- using dhRichClient3 across a LAN
- Change Event code
- Re: Access to sharepoint via VBA?
- Custom class, Stack overflow error
- Clear a "moving" range offset from Target
- Re: Can you use VBA to toggle design mode on/off in Excel?
- Reference sheets named by DAY
- inconsistent dir() behavior
- Command Button Invisible
- formattig word paragraphs from excel
- Count latest number of continous not-empty cells in a row.
- Start Do/Loop within conditional statement
- writing excel data into word document
- If ActiveCell has a comment then exit sub
- Command button does not run code
- HOw do I create a rolling day excel sheet
- userform program keeps crashing
- Transfer array element offset value to a matched value
- Export range to new file (using classes)
- Need help with a stock spreadsheet
- can i use VBA in one XLS file to change VBA in another?
- Counting Criteria Values with For Loop
- Conflict
- VBA Countif across sheets?
- Arithmetic with Cell Dates
- Generate Check Digit
- xslt and .net
- Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the Evaluate method
- Weighted randbetween text list
- Need help with Macro sending data to different sheet
- Delete unused rows / clear unused rows
- Named Range maker code
- xml and excel
- Ambiguous Dates Crashing VBA User Forms
- Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is protected)
- ADO retrieval from close workbook-data type issue
- Re: Repositioning after hyperlink.....
- buy real/fake Australian driver licenses
- VBA Debug Issue
- Run macro from active workbook whose name keeps changing
- How to change add-in object from within worksheet module.
- Need Macro...
- array data type issues -
- Alt+Enter character
- Mid column sum formulas with varied ranges to sum
- vba array logic
- Cells with varying number of lines
- How to do this simple Excercise in Excel
- Problem with a loop and column references
- sloppy code help
- Macro to Update Conditional Formatting Formulae
- Printing full pages on one sheet
- Write to intersect of a row and column
- Mirror data in two sheets
- Save As text file
- Excel customization will not be loaded
- Iterative consolidation macro can't complete - memory overload?
- calendar spinbutton
- Excel is changing date format incorrectly
- ERROR 400 on identical codes different range
- How to hide password?
- vArray = Sheet2.Range("A1:A" & lr) troubles ahoy
- Re: Every 10 second autosave/excel macro
- ThisWorkbook.Close()
- Rows with cells of varying number of lines
- lastrow function help
- Cell's data fills out the rest of spreadsheet
- Multiple rows into one cell
- Userform textbox string to header causes unwanted double spacing
- textbox string to header causes double spacing
- Paste in column B using Last row of either column B, C or D.
- Passing data to an event handler
- clear all sheets code
- ADO sorting issue (repost)
- Scraping web data
- Efficient printing
- Excel spreadsheet to Word document
- Multiple SUM's in a column
- Advanced Filter Error - I cannot spot my Error
- i = row number of last occurance of duplicate string Column A
- Send numbers from textbox with multiline property to specific columnby identifying first 8 digits
- 4 alternatives to all questions need randomization
- Custom SaveAs dialog - need list of supported filetypes
- Make Macro Work On A Different PC
- Efficient standard to military time
- Intercepting data typed into cells.
- Extracting data from website onto excel
- How to Unlock Excel Workbook protected by MACRO Password
- Code for multiple select of cells
- Macro that will insert a simple text string in top cell of text file
- Range(sheet2) = Range(sheet1)
- Using XML in Excel
- Cancel Input Box error
- For next loop suddenly not working, any ideas?
- Copying a formula to a range
- Swiss Teams for bridge tournament
- Alternative to writing to a closed spreadsheet
- Using ADO to write into a spreadsheet
- Need to flag the lead ID of any contiguous ID's from a sorted list of ID's.
- Add to a "number as text"
- Runtime error 1004 when trying to insert formula in cells
- Vlookup with multiple FOR condition
- Excel and xml
- Multiple selection on dropdown in same cell
- Fill cell with value above it (with validation).
- When found add it to the last and display total in Msgbox
- Extract lines with regular expressions?
- pivot table macro with a filtering variable
- Eliminating Duplicate Entries in a Column
- Retrieving Data From Excel
- Vlookup result in a message box
- If Macro Run From Form Control Button/Shape, "Find" Command Not Working
- Send Mail From Lotus Notes using Client Mailbox via VBA Macro
- Copy value from changing cells without VBA
- Can UDF entered as a formula in names return a value to VBA?
- Find a value in a sheet and replace it with another value if it matches
- How to write a VBA code to check whether TCP port (e.g.3306) isblocked or not?
- Count cells containing text, multiple criteria
- Macro to generate powerpoint slides
- Datavalidation with shrinking non blank values
- Modify Claus code "Sub Array_Var_Column_Sort()"
- Macros to COPY pivot table selection
- ExportToExcel Macro
- Ado add an id variable to a table
- Resize to last entry in row and copy to sheet 1
- filtering
- convert this to Excel vba
- Date Modification
- Copy / Append values of a named range from Workbook A Sheet1 to aclosed Workbook B Sheet1 in same folder
- Copy data to all cells in group
- Applying Variables to SORT
- Send emails on behalf of a group - VBA - Lotus Notes
- ADO left join sorting issue
- Array code troubles
- Quick file overwrite script
- Combine IsNumeric & CountA in single If statement
- Read SQLLite3 .DB files?
- Porting from Excel 2003 to Excel 2010
- Array VLOOKUP lookup_Value does not increment
- Copy to a mid column range Row 10 - Row 20
- UnSelect the copied to range after copy...
- merging multple columns into one column (dynamically)
- Unable to Group in Pivot Table
- Post my named ranges in column A
- Run two macros for two different sheets
- How to write some text in textarea on a webpage using Selenium WebDriver
- Text color in textbox
- Excel VBA to Merge Word Documents
- Paste special syntax Book to Book
- ADO with mixed data
- Open a word mail-merge document from Excel VBA
- VBA Script to insert image
- Hide and show ribbon excel 2013 using vba
- Sum work hours to hours & nearest 10th of an hour
- Help with BVA code
- Re: Solution: Excel hangs on open, close & vba6.dll not found errors
- Transpose??
- Scattered array cells copy to scattered array cells another workbook
- need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
- enter key behavior - by sheet
- Find latest effective month and delete others
- If value occurs more than once then delete all of them
- Vba help needed.
- Find sometimes ignores Application.FindFormat
- On-sheet activeX component disables copy/paste
- VBA copy and paste data
- How to Disable/Enable hide entire row ability
- List found strings on sheet
- Path from path???
- Excel macros to plot data in a line graph
- Using Find as lookup method goes to semi endless loop
- Save As and new workbook new name used in existing code
- Calling module procedure from sheet procedure
- Ribbon, Backstage, getVisible
- Disable 'Save/Save As', Enable 'Save as PDF'
- Excel 2013 animation feature....
- Saving/updating an Excel(xlam) add-in
- How to add Row in Table in Lotus Notes
- Copy excel cell to webform (search box) and press enter
- How to add straight line from cell value in pivot table chart
- Excel VBA help: Text file formatting
- Dynamic Offset from an Application.Goto cell = Date or Time
- Need formula or VBA code to find integer
- Change_Event target either of two cells
- Expand and collapse
- Column number of last column that returns value ignore formulas
- Using Regression Function in VBA Macro
- FTP using CMD via VBA
- Code to name numerous ranges
- Counting Bordered Cells
- Code rounds to whole numbers, need it to stay with decimals
- Find dupes, list in MsgBox with cell.address convert ws wide code toone sheet
- Combine three InputBoxes into one?
- Read a range into an array
- Code Enhancement?
- MultiSelect Listbox Question
- Adding Worksheets to a Workbook using a MultiSelect List Box
- Ribbons depending on ActiveSheet
- Large Model Question
- Macro for all Excel Workbooks to print to PDF
- Deleting specific information
- ADO left join count matches
- Search an array of sheets for an array of numbers & return count of numbers
- Auto Copy Data from one worksheet to another
- Weird Behaviour of Compiler Directives?
- Placing the MsgBox "No ID found" statement in my code??
- Prgrammatically added OLE Listbox, now cannot select from it
- Cell Toolbar Dilemma xl2013
- Re: 'Save as' dialog opens despite Application.DisplayAlerts = False
- Array with many cells from a row but not in order or together
- Code character limit with Resize or Transpose or cell?
- Vlookup Function
- Excel - Cross Check
- Default browser?
- Get a color name from any RGB combination?
- Trying to calculate next sequential number using multiple columns
- Junp start my Select Case Macro
- Ubound for variant not working for some reason, can anyone see why?
- CSV files and having numbers and strings in there...
- Reference named range in closed workbook
- Where am I going wrong? Cells reference to a range appears to havestopped working!
- Code to Resize a variable number of rows including target
- Paste a range and shifting away existing data
- Color Scheme
- i to = column in Formula
- Excel 2013 Merge Data
- Macro Error
- To protect user's privacy
- Limit occurrences using VBA
- Command for calculate except datatables
- How to merge multiple .xps file into one via VBA Excel?
- Binary and
- modified date of the file
- Inability to add quotation mark around a variable by concatenation in VBA
- Second run of macro hangs on .show of application.filedialog object!
- Curious string error in named range automation attempt - just doesn'tseem to make sense!
- Re: adding scroll bar to a chart
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.