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. Solved: Disable "X" button
  2. Solved: subtracting 1 row from a range
  3. Solved: Fill down just paste special format
  4. PivotTable Dynamically Selecting the Last Six Items
  5. Function Tips
  6. Solved: Alter Code from a KB Entry: Table of Contents
  7. add pagebreakes every 50 rows
  8. Solved: Referencing ListBoxes
  9. Graph Help?
  10. Run macro if date has changed
  11. Solved: Select Case
  12. Solved: Protect and Specify to Allow Autofilter
  13. Solved: Run Once
  14. Solved: Duplicate cells across sheets upon update
  15. Solved: Timer
  16. Solved: PageBreak Macro Slow
  17. paste after copy
  18. Solved: Help with SIMPLE string-matching loop
  19. Call Macros in other worksheets or selection change event?
  20. macro listbox
  21. Solved: Conditional Copying Of Cell Value
  22. Solved: Is It "Round" or "Application.Round"??
  23. Solved: generating random mumbers
  24. Solved: Count if on VBA
  25. drag and drop
  26. Solved: Find next row
  27. RTD function/Add ins?
  28. Run time error "13"
  29. [SOLVED:] If statment to refer to a blank cell
  30. v lookup problem
  31. why the value are out the header...
  32. double click on listbox
  33. Solved: Protect vba
  34. Solved: Copy and paste
  35. Solved: Return Autofilter to All upon sheet deactivation
  36. Get values on sheet2 from sheet1 data
  37. Get values in sheet2 from sheet1 data
  38. Solved: Bar Chart code, help please
  39. Solved: random but unique running 4 digit pin
  40. toolbar mishap
  41. Re-populating cells
  42. Solved: Display Send To Recipient
  43. Solved: Sum condition
  44. Solved: ActiveSheet.Paste error
  45. change text colour in outlook message
  46. Solved: Remove all modules.
  47. IF STATMENT
  48. Solved: Combine multiple workbooks from various locations into one master workbook
  49. knowledgbase item problem - in excel 97
  50. Solved: Move Row(s) to Another Worksheet
  51. SOLVED: Add-in .xla w/ toolbar not finding assigned macro
  52. Solved: I added a function and now it's slow and nonfunctional
  53. Hide/ Unhide Column Through Listbox
  54. Solved: Return data from Userform to a specifik worksheet cell
  55. Solved: Send a copy of Excel file.
  56. VLOOKUP: 2 Conditions
  57. Solved: Distributing Color Palette Changes
  58. Solved: Goto a cell and ensure that cell is in the middle of the screen
  59. Solved: Macro to unprotect and protect in shared workbook
  60. ADO CopyFromRecordset to Multi column Listbox
  61. Solved: UPPER CASE DATES AGAIN
  62. Solved: add or subtract depending on format???
  63. Solved: Save CSV as Excel file
  64. Find a string through textbox and display the result in worksheet
  65. Solved: someCell.activate and then showing up on screen
  66. statusbar indication
  67. Deselect One Item in Pivot Table
  68. Opening workbooks in several Folder
  69. Solved: Comparing-Matching-Copying-Deleting Cells in 2 WKBooks
  70. Solved: Copy sheet from closed workbook
  71. Solved: Problem with Combo Box
  72. add record to first free row in all sheets
  73. Solved: Call a macro stored in Personal.xls
  74. Solved: Sending arguments to macro in Personal.xls
  75. Validating Sheet
  76. Create a Powerpoint pps file.
  77. macro do not work
  78. Solved: Delete (not hide) Excel Window
  79. Open a workbook that refering to a cell
  80. vba-match and copy data
  81. line number in module
  82. Saving Cell Address by selecting It
  83. Solved: Change filenames according to a list
  84. Solved: VB solution to conditional row formating
  85. Solved: the SUMPRODUCT formula
  86. Solved: Creating Ranges
  87. disabling a toolbar when no workbook is active
  88. Solved: Auto Save as help
  89. Interaction between Excel and Word
  90. Solved: Hide Unhide Columns - But Not Certain Cells
  91. Solved: Hidden Worksheet and Macros
  92. Excel Employee(r) Tests
  93. VLOOKUP or MATCH?
  94. Solved: Creating a Button For A Workbook Macro
  95. Help needed! VBA form
  96. Formula to look in range
  97. Solved: Code testing appreciated
  98. Looking for Possible Web Query
  99. Solved: Setting A Range In VBA
  100. Solved: Working With Dates
  101. Solved: Multi Column Listbox - Need 2nd Col Item
  102. Solved: When find text insert formulas vba
  103. Handicapp help?
  104. Solved: Array Constants
  105. Option Buttons To Command Buttons To Sub Routines
  106. Solved: Insert columns by using a criteria
  107. Audit trail
  108. Solved: Merge Cell Autofit (
  109. Solved: Create, insert, arrange sheet.
  110. VBA code Tracer
  111. Validation data entry in multiple fields in userform
  112. Solved: Merge Workbooks ...
  113. Solved: Distributing to foreign users
  114. Solved: Opening Files
  115. retrieving in a textbox
  116. find out which control type being used
  117. Solved: Passing an array to a sub
  118. Solved: Subscript Out of Range Error
  119. Solved: Changing Range in comboBox
  120. Solved: Covert dates into true dates
  121. Solved: renaming files using excel
  122. Pivot Table Fill Blank Cells Add-in
  123. big dreams.. high hopes.. alot of questions..
  124. Macro not referring to current worksheet
  125. Solved: Rotating pictures
  126. Solved: Copy a row from sheet to sheet
  127. [SOLVED:] Can they marry? (Word / Excel)
  128. Form tracing around screen
  129. Stop macros
  130. Solved: Lookup ?? Problem!
  131. Solved: dual lookup problem
  132. conditional format
  133. Solved: Sorting by Code
  134. Solved: Separation by comma
  135. Solved: How can the Task Pane active in Thisworkbook
  136. Solved: update pivot table
  137. Solved: Email from a range within spreadsheet.
  138. Solved: OWC Spreadsheet: Disable Right-Click menu
  139. Solved: Autofill formula across to the last active column
  140. Changing the from: adress from an email send within Excel
  141. Formula solution required
  142. Solved: All-in-One: specialcopy/attach/close
  143. Solved: COUNTIF
  144. Solved: Conditional Number Formatting
  145. Solved: Copy and Paste row to another sheet
  146. Stop code without ESC key
  147. Solved: Login / Password validation - limited attempts?
  148. Selective Filtering
  149. Look up results across workbooks
  150. Solved: Copyright Symbol
  151. comment time
  152. Print all pages
  153. Solved: Macro to put a pacticular text to the first balnk cell
  154. How to return the sum of variables which change in a loop
  155. Sorting by number in non-numeric field
  156. Error when running histogram in Analysis Toolkit
  157. Solved: ready to try functions
  158. Solved: Populating treeView
  159. Solved: What formula to use for getting ur moneys worth
  160. Can this be done in Excel or other application
  161. Solved: What's wrong with my code?
  162. Solved: excelv ado as400 speed issue
  163. Finding Spaces Equivalent to a Constant String
  164. Solved: Left -Right -Mid functions not available
  165. Overrule ForeColor of disabled textbox
  166. Solved: Clearing Column Contents
  167. Solved: Excel 101 "Show me how's"
  168. am I seeing pastespecial limitations?
  169. Absolute and Relative references
  170. Solved: Sorting
  171. return cursor for manual cell selection in excel vb macro
  172. Sleeper: Create a hyperlink in email text body
  173. Sort + Rank 2 columns with formula
  174. Using code within Excel to change the from mail adress within outlook
  175. Solved: Copy sheets but without the code..
  176. 3 Part VBA Excel 2003 Problem
  177. Trobule inserting a row through VBA
  178. A Counting loop required
  179. Auto Update excel form textbox from database
  180. Solved: How to count Cell Style used in a workbook
  181. Adding to the Character Map
  182. Disable / Enable controls in VBA ?
  183. Searching for text in a list
  184. Hiding worksheets based on one cell
  185. Solved: Fixed length strings in text file output
  186. Ending a form
  187. Sort Worksheet with a wild card
  188. Finding Value on sheet and inserting row under it
  189. Graphical Adjustment to Chart Curves
  190. HELP: CHECKBOX
  191. Solved: Lookup, Concatenate & Format Date
  192. Solved: Persistent VBE Window
  193. Microsoft Query
  194. Help Needed! Automatic incremental replication of forumlas
  195. Carrying forward minus time
  196. Looking up and Pasting Data
  197. Running total
  198. Worksheet_Change Event Won?t Trigger
  199. What determines a good code library?
  200. 2 ways table lookup
  201. [SOLVED:] Sum Lookup
  202. Solved: VB code
  203. Is it possible to call Macros depending on cell Value?
  204. Solved: How to "unselect" a cell or range
  205. Select cells around active cells
  206. Solved: Where to Store Universal Name Definitions
  207. What type of control is it?
  208. Auto opening excel
  209. Solved: Cut and paste a row to another sheet depending on cell value
  210. List Sort - Pulldown Names
  211. Copy and Paste issues
  212. Solved: Progress Bar help - method not found
  213. Running out of stack space....
  214. Autorun question
  215. Edit Form and update them in xlsheet
  216. UK course recommendations
  217. Solved: Delete Lines of Code
  218. selecting variable to declare a format
  219. Save inputed text in new sheet and clear input cell
  220. For Bob (XLD) I think
  221. Picture and Fax viewer
  222. how to display names of subjects taught in cells if specific teacher name selected ?
  223. Gathering and formatting data from worksheet
  224. Delete all worksheets but exclude ?
  225. Sleeper: Copying specific data selected with Filters
  226. Handling multiple delimiters
  227. Solved: Global Find and Replace
  228. put code into the on_open event of 250 workbooks
  229. Do we have some functions similar to Dialogs(wdDialogFileOpen).Show to open .xls file
  230. Excel Not responding
  231. Adding total and trasfering in other sheet....
  232. Conditional If-then help
  233. Cut&Paste breaks EnableEvents
  234. (Solved) Goto the first page on a multipage userform
  235. SetFocus then lose Focus
  236. Autorun Macro/Select Tab
  237. how to edit recordset through ADO
  238. Solved: Answer No to Alert When DisplayAlerts = False
  239. Paste doesn't work when module is created
  240. Attachments
  241. Timer & Decimal Places
  242. 2-letter DAY format
  243. Automatic update of links
  244. Protect cells, Copy Entries
  245. Find X Value and Past Y in column Beside
  246. Using symbols
  247. Automatic download
  248. Deal Or No Deal
  249. Customizing Font Color
  250. WorkbookOpen & double-clicked .XLS file from explorer...