View Full Version : Excel Questions
- Creating a string from a "log"
- Problem: Macro cross over btwn different Excel?
- Text to number in VBA
- converting vertical data list to horizontal data list
- Workbook already open Error
- Code to enable Excel Addins Analysis Tool Pak + VBA
- I need a formula!!!!
- scroll bar Control
- Control home multiple tabs
- converting existing data into Excel's version of time
- Chart problem
- Should be easy...Auto Date Fill
- Need help with a simple formula!
- Access Toolpak functions in Visual Basic
- Muliple Year Depreciation Spreadsheet
- Beginer If-Then Problem
- If Statement cell reference
- Open specific sheet based on date
- No Pictures Will Show Up
- increment every other column by one (+1)
- Number of Days Between Two Dates
- Easy pivot table question
- ARRAY FORMULAS IN ADVANCED FILTER ("CRITERIA")
- Formula help
- Runtime error 28
- SUMIF Question
- Select rows if row number is in array
- Two IF satements in one cell
- First day of week
- inserting unique data into a validation listbox
- exported Function returns 0
- sort data and calculate average and stdev
- Project on Excel
- concatenate with varied spacing
- Open Excel Through Webpage and Run Macro
- How to enforce data validation list?
- Fit Form Button to Merged Cells
- Exiting a userform
- Question about links and updates
- Conversion of PDF File in xls file
- Macro needed to change the case
- WBS CODES (WORK BREAKDOWN STRUCTURE)
- COMBINE TWO MODEL
- Protecting Cells causes VBA to fall over
- Link to Open Workbook and view a particular sheet
- Change cell to color, just need little help
- Question RE: Looping
- Code to select worksheet
- Calculation by date
- Searching Arrays
- =If Command with AND
- Shift Cells Based On Date Condition
- Autoshape querey
- use of condional formatting to match a date
- A macro that will auto select the range
- Sumif uniques wildcard
- Open a custom menu when clicking a button
- Macros
- Category Labels using multiple cells..
- Macro to merge & combine the texts of two or more cells
- Is the clipboard empty?
- Deviations from the mean
- Listbox in a UserForm
- Convert "First Name Last Name" to "Last Name,
- Can I mass print all VB Help to a file?
- Textbox orientation
- pivot problem
- CountA worksheet function stops working.
- Display summary of which filters applied in autofilter?
- Format - Minutes, Seconds, hundredths
- Match values in 2 columns return value from 3rd
- overwrite read only file
- Easy ?? regarding Buttons for you GURU's
- Print Preview
- Naming a range in VBA
- Select Case As A Function
- Multipage issue
- turning off update function from other worksheets
- Using Formula Different Data Sets
- Data Validation
- Stop MTD Lines on graphs at the current date
- Comparing Multiple Sequqntial Data in a Column
- Combining nearly duplicate rows
- Excel Inputbox conflict with Conditional Formats: Unresolved
- Multiple Condition Sum Range spanning multiple columns
- Code needed for a teachers Gradebook
- Disable cut/copy/paste only on certain ranges?
- advancing selection to next availible row column A
- Hyperlink ? I think
- How to write numerical figures in Words
- Open and closing forms
- Can events work with run-time-created Forms-controls?
- Sumproduct/Sumif ????
- Form Button Security
- How to Add Alternate cell
- Random Selection
- Multipage Forms
- Cannot Empty Clipboard?
- Count Form Button Depressions
- VBA Userform Check Boxes
- Vlookup using VBA
- Finding a record using more than one criteria
- NEED VBA CODE TO SORT DATA-URGENTLY
- I have a macro which I need to pause on a particular page...
- copying data from multiple columns into one
- Data from another wroksheet... in a different way ?
- Copying cells in a row and paste special automatically?
- RE: REPLACE
- Rotating list
- User insert picture
- External Data Query
- workbook close
- If statement
- can I auto activate another shhet without the user knowing?
- how to list folders from Windows Explorer into Excel?
- This should be simple
- This should be simple
- Acquire comment from Inputbox
- How do I reduce the amount of .OnAction Subs?
- Deriving a formula from a chart
- Repeating row data (x number) times
- Search C-column for 3rd instance of # and return B as result
- select case help
- Adding Quotes and Commas
- text to excel
- save history in csv and seperate sheet due to event change
- Automatic date in excel
- searching spreadsheet online
- For Each Sheet in a range of Sheets
- Hyperlinks behaving strangely
- Alarm Description
- Hiding group box lines - can I do this?
- even column number
- Remove alert while running a macro
- Charting Negative Numbers
- Slow Sheet: But no calculations are being accomplished
- Named Ranges in Formulas
- date / macro help needed
- Setting MultiPage Tab to be on Top
- pivot table problem
- select value closest to...
- creating a work schedule that adds hours
- macro help with referencing multiple cells
- Totalling combo box entries...
- Up and down arrows not working with sheet protection
- VLOOKUP weirdness
- VBA
- VBA
- How to transfer from one account to another?
- Day date to month date?
- Using return from Formula is VLOOKUP
- Show date 17 / 07/ 06 entering 170706 and/or 17.7.06
- DATEDIF #NUM!
- Vertical Scrolling bar trouble
- Chart Name
- Changing date&time to just time
- Formula To Show Contents Of Several Cells Vertically...
- Problem with finding last row - code erratic!
- import from excel to access????
- dates/'paste special'
- Date format
- Vba to input data
- Real Time Date Fields
- VLOOKUP referencing a scorecard with between values
- HOW DO I??
- Very simple question involving population data
- Office 2k message box compile error
- Disable resizing of shapes
- coditional formatting
- Copying data into sheet
- macro code help - hiding rows
- Goal seek
- Is it possible to Insert a comment to a protected work sheet
- Removing non-numeric formatting from a cell
- Help with a Macro that works like VLookup
- Code to Delete Old Files?
- Graph...Plz Help...
- Variables and Queries with an OR statement.
- search,copy,paste,search,copy,paste
- Substitute/Replace
- Automatic links
- Question on using "Workbook_SheetChange " code
- VBE format colour schemes
- If Statments
- Block If without End If
- Pivot table not working when Data is increased
- Converting XLS to PDF using docudesk deskPDF 2.5 and VBA
- Absolute Cell references
- How to write 14 IF conditions together?
- Macro question
- Autorun on cell selection
- VB Code to display entire workbook
- removing colour in excel rows
- How do you make time in just minutes?
- Erase data in cells with a certain color:SOLVED
- Sorting question
- Activate Chart Tab?
- Two queries
- Calculating the Number of Workdays Between X and Y date?
- Vlookup and multiple criteria
- print to pdf
- Wrapping selections in a dialog box
- Combining countif and frequency functions
- Excel Macro to function in another webpage
- Deleting repeated data
- Format Date w/no space
- How do I report the most recent value?
- recently used file list
- delete an empty worksheet otherwise leave alone
- Code to delete the first space in active cell
- Time Sheet
- Issue with formula replace!
- Help with IF formula (probably easy for most)
- Forcing a string to be recognised as a date-time [resolved]
- why doesn't this FOR/EACH loop work?
- Adding numbers within a cell
- ADODB
- Too large macro?
- array based MAX func
- Find All Combinations
- Emailing from excel
- Sorry another IF formula question
- grabing data from pivot
- Date difference issue - dates spanning more than 1 month
- Displaying current date automatically
- auto-resize columns for all worksheets in a workbook
- need some userform help
- Use the selection of a list box to run a macro?
- Problem with restricting scroll area
- filesearch object question
- Data referencing across worksheets in XL2003...
- Look up values in a table based on matching x and y labels
- Unlocking a spreadsheet when password is unknown
- What am I missing with this simple SUMPRODUCT?
- Data should me entered only once in cell or row of the excel
- comparing columns and adding matched values
- Closest point
- Changing Sub names Based on Criteria
- Pivot Table Data
- if formulas
- store workbook name in a variable to use later in the Sub
- Using Macro to create Charts with Data from different rows
- 2 Macros 1 Checkbox, Can it be done???
- Using Macro to create Charts with Data from different rows
- ActiveCell.Replace??? to be more specific...
- problem dealing with dates
- how to use Filter in execl 2000
- VBA code to turn on and off frame controls
- Index Formulas in VB
- another question about dates
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.