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 168 169 170 171 172 173 174

  1. Sleeper: Error message pivot table is not valid
  2. [SOLVED:] Slow calculating
  3. [SOLVED:] Prompt Box
  4. [SOLVED:] How to Switch from Worksheet to VBE Screen
  5. Sleeper: Function Speed testing..
  6. Sleeper: Launch Word to Merge with "This" Excel File
  7. Sleeper: Supress All Excel Messages
  8. [SOLVED:] Please wait... Message box
  9. Sleeper: Open txt file on website
  10. Sleeper: The Case of the Disappearing Continuation Symbol
  11. [SOLVED:] Create Folder
  12. [SOLVED:] Formatting EXCEL
  13. [SOLVED:] Add static line to XYScatter graph
  14. [SOLVED:] Sort listbox and select with combobox
  15. [SOLVED:] Code Efficiency
  16. [SOLVED:] Getting a VBA-Created Date to Format Correctly
  17. [SOLVED:] Issue with large multiplication on code
  18. [SOLVED:] Can I shorten This
  19. [SOLVED:] Need help with hiding row under the following circumstances
  20. [SOLVED:] Need help to shorten The DeleteEdsMenuItems
  21. [SOLVED:] I tried to run a macro and it gave this error
  22. [SOLVED:] Need help to create macro
  23. [SOLVED:] Run/Test Code Without Printing
  24. [SOLVED:] get latest?
  25. [SOLVED:] Rank
  26. [SOLVED:] Easy question
  27. [SOLVED:] What is equivalent to "or" in VBA?
  28. Sleeper: Poker discussion / odds
  29. Solved: Force string array to return text, not numbers?
  30. [SOLVED:] Error I recieved!!
  31. [SOLVED:] How do I put insert Linebreak
  32. [SOLVED:] Error: AutoFilter method of Range Class failed
  33. Sleeper: Update list from a ranges input
  34. [SOLVED:] Copying a range of cells of active worksheet to a new workbook
  35. [SOLVED:] Follow up on code provided by C. Paleo
  36. [SOLVED:] Search list with Vlookup
  37. [SOLVED:] What's Wrong With This "WhatIf"?
  38. [SOLVED:] Can This Expression Be Simplified?
  39. [SOLVED:] Break at First Number in String
  40. [SOLVED:] How to create a drop down list.
  41. [SOLVED:] Invert numbers
  42. [SOLVED:] Assigning a macro a shortcut from the desktop
  43. [SOLVED:] Remove duplications
  44. [SOLVED:] Updating blank only cells
  45. Sleeper: Any way to fix the scale ( inches / mm / cm ) of chart or excel sheet ?
  46. [SOLVED:] Solved: Tell Me About VB Script
  47. [SOLVED:] Examining the Formula in a Cell
  48. [SOLVED:] Run a macro from info on another sheet
  49. Sleeper: Array formula
  50. Sleeper: Charting Hell
  51. [SOLVED:] Converting a database from Excel to Access
  52. [SOLVED:] Norton alert with vbs
  53. [SOLVED:] Check mysheet is active
  54. Sleeper: Using part cell to lookup refs
  55. Sleeper: Running Multiple Macros from a command button
  56. [SOLVED:] Print report from Listbox
  57. Sleeper: SQL and Excel
  58. [SOLVED:] Color cell dependant on other cell value
  59. [SOLVED:] How Do You Make the "Beep" API Work?
  60. Sleeper: Click Button to select Button's Cell
  61. [SOLVED:] If I want to change the contents in the cell
  62. Sleeper: Remove duplications
  63. Sleeper: Problematic queries
  64. [SOLVED:] Print Preview
  65. [SOLVED:] Protecting an excel file
  66. [SOLVED:] What is the code for the current date?
  67. [SOLVED:] Estimate End Result
  68. [SOLVED:] Insert row based on string
  69. [SOLVED:] Help - A question from Ella.
  70. Solved: Procedure "Sheet_Activate_1()" Does What?
  71. [SOLVED:] Sumif a weekly total
  72. [SOLVED:] Gotta be a better way
  73. [SOLVED:] Inserting new slide in PP from Excel
  74. [SOLVED:] Automatic re-sorting of data
  75. [SOLVED:] Extract data from one workbook and copy and paste it to another
  76. [SOLVED:] Move Macro buttons to a new sheet then sort
  77. Sleeper: Shift Columns Down
  78. [SLEEPER:] Question about links
  79. [SOLVED:] Properties of Named Rectangles
  80. [SOLVED:] Unique values
  81. [SOLVED:] Mass Change Of Cond'l Fmting Variable Names
  82. [SOLVED:] Add New Sheet and Copy over data
  83. [SOLVED:] Is the name found in both lists?
  84. Sleeper: Merge dynamic array list
  85. [SOLVED:] Delete sheet without prompting
  86. Sleeper: Linking a Hyperlink (info inside)
  87. [SOLVED:] Simple question about strings?
  88. [SOLVED:] Tabbing in a user form
  89. [SOLVED:] Sleeper: Control Range Scanned
  90. [SOLVED:] Delete Range With Condition
  91. [SOLVED:] HLookup without sorted data?
  92. [SOLVED:] Saving as .csv with parmaeters
  93. [SOLVED:] Excel Userform List box question
  94. VBA question
  95. Sleeper: Link updates
  96. Sleeper: Looking for a data validation-like function
  97. [SOLVED:] Loging invoices/quotes
  98. [SOLVED:] Insert a value into a cell after a row has been inserted.
  99. Sleeper: Pivot Table Too Large
  100. Solved: Erasing a link
  101. [SOLVED:] deleting rows with zeros
  102. [SOLVED:] Sort new record after add
  103. [SOLVED:] Help with error
  104. [SOLVED:] Drop down list excel 2000
  105. [SOLVED:] Remove asterisk symbol
  106. Solved: Naming rows according to data in column A
  107. [SOLVED:] Enable/Disable Macro POPUP question
  108. [SOLVED:] Removing password on excel file
  109. [SOLVED:] Goto a specific part of a list
  110. [SOLVED:] Create a Mailing List from unformatted data
  111. Sleeper: Hyperlink issue
  112. [SOLVED:] Doubt about Hlookup
  113. [SOLVED:] DisplayAlerts
  114. [SOLVED:] working with named ranges & automated labelling
  115. [SOLVED:] Easy sort question
  116. [SOLVED:] Search a worksheet
  117. Solved: Pls HELP!! w/ email a worksheet
  118. Sleeper: Simple Print Word doc from Excel
  119. [SOLVED:] Fill in data from Search routine
  120. Solved: Protect/Unprotect Cells with VBA
  121. [SOLVED:] Need a macro to change font in unique cells
  122. Sleeper: Help with Excel and reflection script
  123. [SOLVED:] Does knowledge of Visual Basic.NEt help with VBA?
  124. Sleeper: Setting VBA Project Password in Code
  125. [SOLVED:] Shared Workbook - How can macro work?
  126. [SOLVED:] Counter
  127. [SOLVED:] Scrolling multiple sheets to the same row
  128. [SOLVED:] Add new line to .txt file
  129. Sleeper: Help with Zip Codes
  130. [SOLVED:] Protecting Page SetUp Properties
  131. [SOLVED:] Counter, part II
  132. [SOLVED:] Perform a "Find" on 2 criteria on an "or" basis
  133. [SOLVED:] Div/0! Question
  134. [SLEEPER:] Printing in VBA
  135. Sleeper: Memory Issue
  136. Condional format
  137. Sleeper: Create a Fixed Table
  138. Sleeper: Updating Links from Files with Passwords
  139. [SOLVED:] Compare two columns to two other columns
  140. [SOLVED:] Counting Cells
  141. Sleeper: Changing Print Range with Protection
  142. Sleeper: Blank Cells with Formula
  143. [SOLVED:] Blank Cells with Formula
  144. [SOLVED:] Determining "Local" Directory
  145. [SOLVED:] Help with excel macro
  146. [SOLVED:] Any Extra Execution Time?
  147. Disable Insert Worksheet Command from toolbar
  148. Sleeper: How Can I create a Pivot table using VBA?
  149. [SOLVED:] Excel / Word / E-mail
  150. [SOLVED:] Is it possible to display the highlight text in VBE
  151. [SOLVED:] Formula to match non case sensitive text
  152. [SOLVED:] how to move a selection area?
  153. Sleeper: Range Names: Good or Bad?
  154. Range Names : Good or Bad programming practice?
  155. Disable Password/Login Request on Web Query
  156. [SOLVED:] Automatically change Lowercase to Uppercase
  157. [SOLVED:] Insert lines in two or more sheets at the same time
  158. [SOLVED:] VBA code: FILTER DATA
  159. Sleeper: Display data in UserForm
  160. [SOLVED:] Range all sheets to cell "A1" before closing file
  161. [SOLVED:] Values Adding
  162. [SOLVED:] Return path
  163. Sleeper: input values in appropiate textbox on first userform
  164. Sleeper: VBA problem activate window inside a window
  165. [SOLVED:] The Quest For How to Insert a Line in a Macro
  166. Sleeper: Looking for guidance on saving file
  167. [SOLVED:] Protect sheet on idle
  168. [SLEEPER:] Extract file using vba macro
  169. [SOLVED:] Balance Forward Method
  170. Sleeper: Problem Pivot table &VBA
  171. [SOLVED:] Conditional Format Cells
  172. [SOLVED:] Function average using VBA
  173. [SOLVED:] Assigning a Macro to a VBE Toolbar Button
  174. [SOLVED:] Range Address
  175. Sleeper: How to sort my data using VBA?
  176. [SOLVED:] Working with "time"
  177. Sleeper: VBA - sort data
  178. Sleeper: UserForm Error from Thin Air
  179. [SOLVED:] Advanced Filter
  180. Solved: Add an item for MACROS to the Excel menu bar
  181. [SOLVED:] Can't Find Shortcut Notation Using Prefixes
  182. [SOLVED:] Metmorphisis of a Variable Into an Array
  183. Sleeper: Cell References & Links - Please help
  184. Sleeper: How to change automatically the format of a range of cells?
  185. [SOLVED:] Sorting drop down box output
  186. Sleeper: Two comboboxes update puzzle
  187. [SOLVED:] Counting like cells to determine coverage
  188. Sleeper: SQUARE of the difference from two columns
  189. Sleeper: Compare Actual vs System
  190. [SOLVED:] Testing multipe counters
  191. Sleeper: 2 Projects
  192. [SOLVED:] Values Adding
  193. [SOLVED:] Divide a value by a cell
  194. Sleeper: VBA - "group by" function
  195. [SOLVED:] Auto update Excel Charts
  196. [SOLVED:] Prompting to Save
  197. [SOLVED:] Showing a dialog box during saving
  198. [SOLVED:] Delete characters if matching
  199. Sleeper: How to obtain the value of the last row?
  200. [SOLVED:] Solved: Get file location in textbook upon clicking button
  201. [SOLVED:] Run time error 91
  202. [SOLVED:] Loop thru worksheets and run macro
  203. [SOLVED:] Line break within a cell
  204. [SOLVED:] Code to organize sheets skipping hidden or specific ones
  205. Sleeper : Function SQRT, SUM...
  206. Solved: Embedded swf
  207. [SOLVED:] Check the creation date of a file and delete a file when older then...
  208. [SOLVED:] Delete a sheet IF sheetname doesnt contain the string 'rules'
  209. Sleeper: How to delete the 'grand total value' in a pivot table?
  210. [SOLVED:] Check Month and Day
  211. Sleeper: Linking protect to enable=false
  212. Sleeper: Discount Cash Flow
  213. [SOLVED:] Rows Repeat at Top
  214. [SOLVED:] Parameters
  215. [SOLVED:] Repeat Rows at the Top
  216. Sleeper: Header Drop Down Box
  217. Sleeper: Do Not Update Links - On WB Open
  218. Sleeper: Stumped.....Phase calculator
  219. [SOLVED:] Change color and text of an Autoshape
  220. [SOLVED:] Help needed with counting formula
  221. [SOLVED:] Help to complete a code
  222. Sleeper: File Exists issue
  223. [SOLVED:] Failure Using Logical Operators in Cond. Fmting Formulas
  224. [SOLVED:] Combining Excel Chart Types
  225. Sleeper: Compare 2 workbook
  226. [SOLVED:] Open next file if not found the one to open
  227. [SOLVED:] EXCEL to ACCESS
  228. [SOLVED:] Search that loops through inputs
  229. Sleeper: Workbook and Forms
  230. [SOLVED:] Populate a Listbox from an Access database
  231. Sleeper: Excel cannot complete this task with available resources.
  232. Sleeper: Problems with Solver.XLA
  233. [SOLVED:] Rename sheets
  234. Sleeper: Copy all workbook contents into a new one
  235. [SOLVED:] Visual Basic Editor only saves the modules/project sometimes
  236. copying to XML from excel
  237. Solved: delete all images from spreadsheet
  238. [SOLVED:] Compare Sheet1 with Sheet2
  239. Sleeper: Excel and mysql
  240. Sleeper: Can't interface vb to excel with autosave on
  241. Solved: Counting sort for multi-dimensional arrays?
  242. Variable string for cell reference
  243. [SOLVED:] disable/enable controls
  244. Sleeper: ChartSheet Generates Bogus External Reference
  245. [SOLVED:] Hiding rows if the linked cells are unused
  246. [SOLVED:] Autohiding Empty Rows. VBA code
  247. [SOLVED:] Factorial sub
  248. [SOLVED:] Find the last used column
  249. [SOLVED:] Open UserForm from an Add-In
  250. [SOLVED:] How to fix last row in a worksheet