View Full Version : Excel Questions
- How to change size and location of Msgbox and Inputbox
- Move File to Different Directory
- Conceptual/Design Help required
- VB & Excel - Copying Selections
- Plot area
- Debug.print not working
- IF...THEN...insert row
- m2 after a sum equation
- formula
- I want CommandButton3 To Do What CommandButton2 Does
- Activecontrol in a Multipage
- I need for my charts to auto-update each month.
- Comparing 2 columns of text
- Help! I'm about to lose it!
- Visual Basic Excel Find
- Staff Rostering Tool
- Cancel exit event execution
- Adding hours, minutes and seconds
- Function key to input current time
- Hiding columns when a particular cell is empty.
- Gantt Chart
- One more question...
- Warning message boxes
- Excel macro. how to fix a column so that it could only enter
- Difference in months given two dates
- Sorting IP Addresses
- IF statement and "" syntax for leaving cells blank
- Ending a Macro at a specified time
- How do I set a function key
- I want my lookup to say 0 if it can't find anything - help!
- easy question - select and copy last row in spreadsheet
- COUNTIFS AND MESSAGEBOXES... HELP!
- csv file load
- Deleting blank pages
- compare to lists
- COUNT "INTERIORCOLOR" CELLS
- Charting
- Warning signs on message boxes
- Check this Code For Me Please- Can't Figure out what's wrong
- elapsed times
- Linking To Access Databases
- Saving Excel files without Marcos
- Conditional formatting on calculate
- userform textbox data validation
- Batch File
- macros!!??
- Search for a value then format a row
- Toolbar Positioning
- Novice Looking For Help
- FORECAST function
- Looping through a closed workbook
- Uprotecting VBA Project
- Saveas macro
- Can custom toolbar be non-global?
- Macro by Reference
- CountIf problems
- Adding months to a date range
- Please help?!
- sql.request
- merging duplicate information in a column
- Time and date stamp on a worksheet
- XP Macro Incompatibility
- Hiding forms with a timed event
- Formulas Do Not Work Automatically
- Input data
- Macro Question
- Two functions in one cell
- Rows
- combo box
- Can a Cell Formula run a Macro
- Set Print Area Dynamically for all worksheets in workbook
- can macro parse multiple excel files
- Can I have a message pop up when a control gets the focus
- Find and replace
- WEIRD behavior w/ range.interior.color property
- Input MessageBox / Msgbox to choose a location of a file
- Mouse Pointer
- Negative Percentages
- Change font color in Excel footer
- See through spreadsheets
- nearest neighbour analysis
- If row count is > 1 use subtotal else do not???
- Automatic Links
- page numbering
- Adding 1 month at a time to a date list
- Autosum Textbox in Chart?
- count empty cells
- Questions, Questions
- Using a cell to change the filename reference
- can't get rid of leading space in cell
- Excel Problem
- How do I insert a hyperlink for a worksheet in a workbook?
- formula problem
- conditional formatting being difficult
- Auto save
- PLEASE!
- Finding the next empty cell (Even if a formula exists)
- Trouble with DSUM
- Pivot table drill down
- changing from character to value format
- Help...again. Need a macro to delete all cells without @ sy
- This board's messages
- Counter
- automating print area
- NT, XP, or Win2000, etc. for power users
- save as read only
- Insert Comment Macro needed
- high & low relational numbers
- Custom MSGBOX Macro needed.
- Excel Size limits
- Business Days
- adding days to a date field
- "Auto_open" macro to select last worksheet used?
- i got this problem and would like to solve it, but i need yo
- Carpel tunnel hell! Please help!
- Searching for the lowest 3 numbers
- Sounds like a classic vlookup
- Run macro when 2 cells are equal
- Size of Objects in VBA
- Extract records that don't match
- closing a file
- Colored Cells
- pasting one sheet as an icon in word
- Changing Uppercase to Lowercase (but not all the way)
- incrementing worksheet names dynamically
- transferring links to another comp?
- how to do this ?? beside vlookup?
- LAN Network!
- Merging cells or adding to a cell
- New page
- Advanced filter and copy to a new worksheet , create a macro
- VLOOKUP within the same workbook???
- Can anyone tell me why...
- Newbie Question - Split an worksheet-pages or files
- Looking up a reference
- Leading Zeros
- 1 to 200 printing labels
- problem with dates
- Snap to cell
- Writing formula
- how come spinner does not work on the dialog sheet?
- changing font size
- relative cell increments
- Reloading Custom Menus
- Tab Trouble
- Userform Problem
- Floating bar charts
- workbook contains macros or does it?
- mail merge
- If ClipBoard Empty GoTo... Else Paste (How said in VBA?)?
- Charts
- Calculating split times
- pause to calculate before insert...please, help
- code in worksheet not working
- Inserting a value in visible column after an autofilter
- Keeping Constant Values in Formulae
- Name of month (easy question)
- problem calling excel addin via com
- Mysterious XLstart File: Help me kill it!!
- Deleting Rows
- Why doesnt this code work??
- nice easy one...how do you select multiple worksheets in a m
- totals
- Before Close Event
- Search rows
- Activating a userform by selecting a cell
- Password Protection and the French Standard
- VBA
- Run a macro when a cell changes on a different tab?
- Linking Worksheets...
- Adding carriage returns to cells from a userform
- grey screen
- change worksheet tab
- LOOP
- changing a formula from not Rounding Off
- Updating Pivot Tables in shared workbooks
- Email Code Module as a jpg or gif file? How do they do that
- Drop-down lists...or ARE they??
- Subtracting Hours
- a macro to name a sheet as contents of cell a1.
- Dynamic links into Word
- Lookup formula error
- concatenation of two ranges into one so that the resultant r
- Illegal Op error when printing Excel to .pdf (PDFWIN32.DLL)
- Move a sheet before the first sheet of a Workbook
- Scroll bar in merged cells?
- Averages / Floating averages
- Macro for modifying Page Setup - only part of it works
- "CALCULATE" appearing on bottom tool bar
- How do you get rid of Location messages
- MEDIAN
- Copy and paste behavior
- Sorting Problem
- Pass a variable to a userform
- It's a hard one
- Set up a workbook that 2 users can change all others read on
- repost...updating page fields on muliple sheets simultaneous
- radar charts
- Investing
- Custom messagebox that prompts user that worksheet will be d
- Macro Error Message - Subscript out of range
- Placing Excel Sheets into a Word Document
- Can you write Macro to update dynamically...
- Help With VBA Making A Chart Last Bit Of Help I Need Please!
- RANGES
- Formula
- Loop through data to copy to other sheets.
- Autofilling?
- Can A Control on a form in a worksheet be linked to another
- Newby
- Adding a row to a programmed worksheet?
- deleting rows based on one cell's contents
- Workbook access control
- COUNTIF problems... Has anyone else seen this?
- delete rows if
- Range formulas ( kind of )
- Nesting Functions
- Macro that automatically runs when workbook is opened
- Linking a cell from one workbook to another over the interne
- template
- I want to see drop down list
- Easy one
- HELP!! My spreadsheet dates are messed up!
- need specialist eye for the following macros.
- Compare cells within a range for a specific difference?
- CONDITIONAL FORMAT - green bar formula will not let other co
- crazy mayk with crazy email macro.
- FTP From Excel?
- compare columns for redundant text entries
- {Problem Solved, Thanks Duane} Parsing a text file
- Special Window Mode
- Advanced autofilter
- Shell function exposes 'File not found' error - but it's the
- How to programmatically get a chart to look the way I want
- Cell,
- VBA Macro to update or replace current name of file in code?
- Pasting Formulas Horizontally
- how do u do this simple IF statement?
- Launch non office application
- Cell Formating with VBA
- Freeze Formula to copy Column
- Indirect reference to external workbooks
- Pivot Table
- count function: won't see numbers as numbers
- This site is great--is there a similar site for Access?
- Indent
- View Worksheet Tabs
- changing column data to row data and vice versa
- Check for Values
- COUNT formula
vBulletin® v3.8.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.