PDA

View Full Version : Excel Help



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

  1. Solved: Dependent Validation Lists
  2. Solved: Add button to bar
  3. customize menus
  4. Solved: Parse Method
  5. Solved: Pivot Table Error
  6. Live Data over network
  7. Setting Current Position equal to Last Position: Homework
  8. Solved: Unwanted Connection to Macros in Another WB
  9. ShowDataForm and data validation
  10. How to make Hyperlink which will change with cell number?
  11. Solved: userform error 424
  12. Conditional formatting
  13. setting "trust access to visual basic project" programmatically?
  14. Solved: Showing Male and Female Ages on the same chart
  15. Changing Date Format
  16. macro to copy and past into mulitple worksheets
  17. Solved: Using forms and form data
  18. Get value from workbook closed
  19. Solved: Macro is really slow
  20. chart title as grid
  21. dynamic chart layout
  22. Excel 2003 Convert to 2007 xlsm file
  23. Solved: Lookup Dates & Times
  24. Solved: Multiple replace slowing macro
  25. Chart multiple ranges from userform dropdown
  26. Spreadsheet inside a Userform
  27. Solved: Making a Collection of some Form Controls
  28. Solved: Popup Window
  29. Solved: Maximum size of String Variable
  30. Calculating automatically with matrix
  31. Solved: Disabling a button for specific worksheets
  32. Solved: Excel to Access Database
  33. Solved: How can I simplify my pivot tables
  34. Case Statement?
  35. Not filtering by given criteria
  36. Solved: Web page closes itself then opens a new IE... How can I track?
  37. How to add paste special in contex menu and make Hotkey on it?
  38. Solved: Compare Values from two sheets
  39. Can VBA do = camera to scan paper image:check marks ABCD = auto grading in classroom
  40. A command that clears all data stored??
  41. Chage background colour
  42. Scan lists and shade row with lowest number
  43. Solved: set print area problem
  44. How do i access Excel training?
  45. Save excel in temp
  46. vba with web application
  47. Solved: help in indirect function
  48. Error while sending mail
  49. Solved: Cells format
  50. Delete invalid filename characters
  51. Solved: Change background colour if cell is blank
  52. Solved: Review Code
  53. "Save As" for Excel file with Internet Explorer
  54. Solved: links in formulas to other files problem
  55. Solved: SOS !!! File/Send To
  56. Solved: Protect based on cell colour
  57. Solved: colorIndex change event
  58. Correspondance search between sheets
  59. Excel and Mainframe apps
  60. Solved: Coverting table data to flat data & delete empty rows
  61. Solved: How to correct hide sheets when more than one workbook is closed?
  62. Using Excel to Tab through IE
  63. Center Userform/splash son monitor
  64. "Application OnTime" Questions
  65. Solved: Take time difference
  66. Correlation Matrix through relative refrances
  67. Solved: Opening the Edit Links Dialog
  68. Procedure needed to group sections of data?
  69. Sum of column
  70. Formatting text cells to use in a formula
  71. Solved: deleting rows matching criteria from a column
  72. Change picture based on cell value
  73. Print tables with variable height and same heading
  74. Calculate Retirement Age: I Failed!
  75. Solved: Changes in all Workbooks in One Time
  76. Solved: Speeding up routine
  77. Solved: Splitting all addresses in a formula
  78. Solved: Alphabetically reverse text in cell
  79. Solved: Select case for conditional formatting to build heat chart?
  80. Pausing a macro...
  81. Solved: how to protect/unprotect column depending on cell value?
  82. Help to populate listbox via vba
  83. Solved: How to Chart two different data ranges
  84. Solved: Join Two Codes Together
  85. Solved: How to automate Excel Tools-> Options
  86. Solved: copying rows matching criteria from a column
  87. Solved: Need to add a sort command to macro
  88. Opening Excel from Powerpoint
  89. Snap view upon cell click
  90. Solved: Offset Macro Needed...I think
  91. Jumble Word Game
  92. Alternative to late Binding?
  93. Copying single values instead of range
  94. Solved: Amend vba code to add and extra step
  95. Solved: Changing Names to Numbers
  96. Fill PDF form from Excel
  97. VLookup and column indicator
  98. Solved: Calendar
  99. Pull Access cells into Excel
  100. Solved: using a worksheet function in VBA
  101. Want to have a static column referring to a dynamic range of data
  102. Creating a lagged correlation matrix
  103. Solved: Textbox formatting question
  104. Solved: Excel Macro Help - Hyperlinking
  105. Solved: Disable Cut, Copy, Paste Macro for One Column
  106. Deleting headers between two found variables?
  107. Solved: Macros men?
  108. Array Formula (sum of ranges)
  109. Solved: Can't Find Project or Library
  110. Solved: getting rid of a "If" + improving my code
  111. Solved: Create folders and filename
  112. Solved: Check conditional format colour?
  113. Solved: Autofilter for multiple condition
  114. Solved: Add a count variable & increment it appropriately in this code
  115. Data update does not work from VBS initiated open
  116. VBA search through workbooks to return answer help
  117. How can I disable the links and query alerts
  118. Solved: Need someone to discreetly look at my code
  119. Pivot table to NOT summarize data?
  120. Multi Text Criteria
  121. Solved: how to copy value with criteria to other worksheet?
  122. Solved: ActiveSheet Printing
  123. Looping and shaking
  124. Solved: UserForm turtorial
  125. Movies and scales
  126. Solved: Loop to Get and put values
  127. Get Tenor - Bucket Function
  128. Solved: Locking Merged Cells
  129. Solved: Time and Date log using VBA
  130. Solved: Autofilter OR function
  131. Solved: xlCellTypeVisible question
  132. How to Parse a string with VBA
  133. Deselect range after Macro runs
  134. Compare two columns to two other columns
  135. Solved: Pie chart data labels percent formatting
  136. Help with ADSI spreadsheet
  137. Solved: Merged Cells Null Value
  138. Solved: To copy part of the table data
  139. Solved: deleting an asterik
  140. Saving
  141. Can you help me?I want code
  142. Solved: What to do when executing a code freezes Excel?
  143. How to close the dialog with Excel VBA
  144. Solved: Deleting Unwanted Rows
  145. Email several sheets in one workbook password protected
  146. Solved: Add sheet & name
  147. Find Major Lows and Highs in Series
  148. Solved: Search through range and fill corresponding offset?
  149. Getting Month and Year from a date cell
  150. Solved: double case statement
  151. Internet Explorer dialog pop-up from Excel
  152. Error Popup
  153. Solved: Copy only filtered rows
  154. Solved: unchecking checkboxes
  155. Solved: Textbox format
  156. Solved: column loop
  157. Scripting.FileSystemObject
  158. Solved: Choosing random samples
  159. How Can I save data in incremental way-Help needed
  160. Saving data in incremental way in dat format-Help Needed.
  161. Solved: conditional formatting by color
  162. Regular Express
  163. Solved: Insert comment pictures fill down.
  164. Spreadsheet maintainance automation required?
  165. Solved: Formula help for odd money calculation?
  166. User Defined Function - Write value to a range
  167. Delete row if cell does not contain a particular value
  168. MS Excel 2007: what is wrong with standard colors when constructing a chart?
  169. When to Use "Application.CutCopyMode" Statement
  170. Solved: Single click on cell should store value in another cell
  171. Help to Modify An macros to compare
  172. Add another call function to an exiting macro button
  173. Solved: Prevent numeric or symbol and if function in userform
  174. Remove Duplicates in ComboBox
  175. Solved: Open User Form in specified range
  176. Saving Excell Data to File (More complicated then the title says)
  177. Solved: Amend vba code to apply same font and styling
  178. Excel VBA Variant Variable Assigned a Number Tests as Number when assigned to ??
  179. Solved: Redirect save when given drive is not accessible
  180. Solved: Convert a number into a string with a leading zero
  181. Solved: Display if Found, if not edit???
  182. How add new table ellement faster?
  183. Solved: Adding Second Symbol
  184. generating emails from excel fields
  185. Challenging Macro
  186. Range copying issues
  187. Solved: Define Name from a function
  188. Illegal Characters in Excel File Name
  189. Solved: Adding More Cell Ranges to BeforeDoubleClick and BeforeRightClick Macro
  190. Sorting - data in columns - arranged finally in one column
  191. How do i add the custom toolbars programmatically
  192. Solved: Delete row if meet the criteria
  193. Transpose Row into Combobox
  194. Accessing Web page from Excel
  195. Unknown Symbols keep appearing!!
  196. Improuvement af this macros
  197. Solved: Glitch in Macro
  198. Combobox.value reference
  199. change the defined name range names to correspond to workbook (book1.xls) -
  200. To show multiple contacts pick one
  201. Permutation with a handicap
  202. Solved: Filtering Pivot Items by value
  203. Solved: Copy format Range into another Range
  204. UserForm
  205. Multiformat Lookup
  206. View/Print Non-empty columns only
  207. Error when deleting
  208. saving changes to xlt doc
  209. Excel bug?
  210. Solved: Print information from rows
  211. compare records
  212. Print selected rows to labels
  213. Solved: how to use variables with rows selection
  214. How to do Unit testing in Excel as part of Test Driven Development?
  215. Data Validation: Listbox
  216. Autorun externally held macro without opening external file
  217. Combobox Selection Problem
  218. Solved: Trying to work out which userform has been opened
  219. Problems with calculating hours worked
  220. Solved: eliminating blank spaces inside string
  221. Solved: Dollar symbol in formula
  222. Swapping multiple cells accross a row
  223. Problems grabbing hrefs in HTML docs
  224. Solved: non-modal userform to reflect values with Worksheet_SelectionChange
  225. Copy between Excel applications
  226. Solved: Add a extra step to current macro button
  227. Range assignment in chart
  228. Solved: selecting and copying a range where a variable is found
  229. Grouping Cells + Printing
  230. Solved: A function as a variable? Pass function as parameter? function pointer?
  231. Solved: VBA Hyperlink from a Cell ?
  232. Solved: Conditional Print Preview
  233. Solved: Sheet name in formula instead of caption
  234. Solved: how to skip no dates data in chart
  235. Solved: VBA VLOOKUP error
  236. Solved: Getting 2 pieces of data from one source (cell)
  237. remove corrupt excel names - programmatically?
  238. Solved: Macro hangs and need an extra step add to the macro
  239. Solved: Code to automatically enter data update date
  240. Solved: Condition with StatusBar based on Row number
  241. Solved: Painfully slow Copy & Paste from Web onto a sheet.
  242. Solved: DTPicker1 in Userform help
  243. Solved: Matching two sheets help needed
  244. Solved: combine mulitple columns
  245. Solved: Disable 'Save As' dialog
  246. Test if vba password is set.
  247. Solved: How find the empty column immediately after the data column???
  248. Solved: How to insert values in rows through for loop
  249. Set trial time limit on workbook?
  250. Solved: If value in a row = value in another column store in another cell