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 161 162 163 164 165 166 167

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