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: Printing Zeros. 1.000 Zeros disappear, why?
  2. Solved: Redim Preserve
  3. Solved: How To Re-edit The Sheet Names In VBE Project Window?
  4. Seemingly impossible replacement task.
  5. Solved: Using an array as a parameter in an ADO query
  6. Using Arrays to Populate Listbox
  7. Solved: Stubborn Styles (How To Remove Them?)
  8. Solved: copy cells from many .xls files to master file
  9. From KBase
  10. Solved: Creating a log file help required
  11. Explanation of Cell Comments?
  12. Insert Row when cell Value differs from above
  13. Can Excel Transparence UserForm Show Only Control in Form
  14. Hide Rows if the Value is ZERO
  15. Solved: Copy results to sheet2
  16. Solved: Is it possible to set a bit in a long integer ?
  17. Email from excel
  18. Solved: How Do I clear leading spaces from a column?
  19. Automatic Updating of Functions in Excel
  20. Solved: VBA to set print area on several worksheets to 1 wide and N tall + Landscape
  21. Show Menu Bar
  22. Solved: Dumping data from AD If statement issue
  23. Solved: VBA To insert File Path Footer at bottom of each sheet
  24. Import data from Access to Excel
  25. Solved: Look up Values in Access
  26. [SOLVED:] Copy open event to active workbook
  27. Getting username for last update on closed xl wb
  28. Solved: Userform events for dynamic controls
  29. Solved: Remove Hyperlinks
  30. Change Row into a Column
  31. Need to use VBA to send email using Lotus Notes From Inside Excel
  32. Solved: Alert before delete a record
  33. Solved: Timer for code execution
  34. Solved: Difference between 2 count last row/column command
  35. Show the time and date of when the code is being executed
  36. Export data from Excel to SQL
  37. Moving controls
  38. Solved: Printing multiple worksheets to a single pdf file
  39. Solved: nightmare fractions in formulas
  40. Selecting from a column and more...
  41. Exporting Drawing Objects from Excel
  42. [SOLVED:] Function to add/write cells
  43. Solved: How To Delete Column O/empty columns from all sheets in a work book?
  44. copying sheets without references to the original workbook
  45. Greyed Out Menu Items when Editing in Cell
  46. getting rid of all user form objects in a workbook
  47. Number ranges
  48. fill list box with txt file
  49. Solved: Unique Lists
  50. Writing to the next empty cell
  51. Solved: Recieving a "FALSE" in If function. Need Help!
  52. Strange Behaviour from Excel
  53. Solved: Index match with command button
  54. Date wise calculation
  55. Need help with macro to only unhide 5 rows at a time based on cell value
  56. Delete empty column in mutliple excel worksheets
  57. Open a simple email template out of excel
  58. Sub or Function not defined
  59. Help with highlight macro
  60. Rounding numbers with user defined increment
  61. Basic Question?
  62. Wrong number of arguments or invalid property assignment
  63. array.copy
  64. If...Then...Else - Help!
  65. Solved: Listbox With Checkboxes inside
  66. Solved: Saving output as a text file with pre-fixed space between columns
  67. Copy without using the clipboard
  68. Vlookup from another Sheet in the same Workbook
  69. Words in a String to Columns
  70. can't find project library
  71. [SOLVED:] Range selection and other questions
  72. Run another Sub from within active Sub
  73. Inserting Rows during Worksheet_Change Event
  74. Solved: Saving output as a text file with pre-fixed space between columns
  75. file (xls, doc, pdf, jpeg etc) adding to mysql database ?
  76. Solved: Assigning formula to a range of cells usign VBA
  77. Solved: User can extend 'RowSource'
  78. Solved: How to populate listbox
  79. How to update Office 2003 code to compatible with Offfice 2007
  80. switching focus from userform to spreadsheet?
  81. Can you use the min & average function with cells and not ranges?
  82. Solved: Email function on spreadsheet
  83. Variables not stored globally?
  84. Solved: Vlookup you helped me with yesterday not working again!!!
  85. Solved: Easy format Question
  86. Removing rows based on "0" Value but keeping Headers...
  87. Bar chart
  88. Solved: Copy data from all the sheets in a workbook into a single sheet
  89. Solved: Passing variable from access to excel
  90. Very large number: Mod operator
  91. Solved: Add cutom header to Top of printed worksheet
  92. Pasting Cells Into Word Chart
  93. Solved: Import File Using Browser
  94. Solved: Excel 2003 Subscript issue
  95. Changing code in runtime - why doesnt work
  96. Solved: Unable to Hide Columns ... Why??
  97. Solved: Help alter code to pickup extra info.
  98. Solved: Returning a Value from and "If Then Else"
  99. Solved: Protect sheet except for new inserted sheet
  100. Solved: ListBox Headers without .RowSource
  101. Solved: Edit in ListBox & changes made to RowSource
  102. Solved: Hide zero rows
  103. Solved: Template??? Conference Matrix
  104. Solved: pROBLEMS....!
  105. Search Listbox Problem
  106. Range behaviour after delete
  107. Solved: Finding repeated values/cells
  108. Solved: Save Sheet to a user defined location
  109. Solved: Control the execution of macros
  110. Solved: Copying a range from one sheet to a new sheet in the background
  111. using variables in "Find Function"
  112. How to copy sheet with dynamics chart?
  113. Select network printer for printing Word doc
  114. Solved: Copy Range Names
  115. Dynamic Chart
  116. Solved: Show Width Of Selected Columns...
  117. Solved: Columns Alighnment
  118. Add consecutive numbers
  119. Word doc in email body
  120. Loop Problem
  121. SUBSTITUTE FUNCTION
  122. Show All in PivotTable
  123. Macro To Start An External Tool Process?
  124. Pivot Field Have I Just Clicked On?
  125. A few small problems...
  126. [SOLVED:] Assigning password to all files
  127. Copy all sheets to new Workbook
  128. Unprotect Excel Worksheets
  129. Solved: Update Links
  130. Add-in sheet
  131. Execute Access Module within Excel
  132. Enabling Mouse Wheel for a Scroll Bar
  133. Solved: Replace error types with string
  134. Genetic Algorithm
  135. Solved: Single Event Handler for Multiple Checkboxes
  136. Solved: Identify .csv attachment in LotusNotes Inbox
  137. Array of objects
  138. Solved: Search 2nd ListBox Column
  139. Solved: use a cell reference to name a save-as
  140. Solved: Getting rid of the glimpse of opening/closing file
  141. Solved: Date Saving Problem
  142. Sorting order please help!
  143. Solved: Clear all within range
  144. Solved: Len function problem
  145. Show only Current Contracts
  146. Solved: Auto Export cells to pop message and text file
  147. Solved: Sort of dynamic drop down list
  148. Solved: Import Macro help
  149. Hexadecimal to ASCII UDF
  150. Automatically populate cell based on validation list
  151. Solved: Efficient way to store/retrieve data of large UDT
  152. Bingo anyone? How to cross check a list of numbers & letters
  153. Record data from a dynamically changing cell
  154. how to put tabindex for rows of data Grid?
  155. Help: how to insert pic, textbox to chart automatically???
  156. NumberFormat of Now
  157. Solved: Sorting Question
  158. Range & Cells Property Prob
  159. Solved: Changing position of Chart XValues
  160. Compare 2 spreadsheets with conditions = Macro?
  161. Split date into part
  162. Application Object Error- Range(Cells(
  163. Google Translation Issue
  164. Going over formula length limit
  165. Solved: File Import Browser Filter Failure
  166. Pivot Data Question
  167. Excel 2007/ Outlook 2007 Mail Problem
  168. Tab key issues in form (inserts tab rather than moving to next control)
  169. Stop userform from loading
  170. Solved: IF/THEN Copy macro
  171. Solved: Can't get my XLA auto installer to work...
  172. Solved: How to clean up data
  173. Delete rows of other sheets also
  174. calling subs from conditional statements
  175. Online spreadsheet?
  176. Solved: Add array items to multi column ListBox
  177. Solved: Figuring out a DATE from a Number
  178. Controls on the fly
  179. Solved: Brainstorming - Querying data
  180. Solved: Save As powerpoint that reference a cell in Excel
  181. Solved: Search a spreadsheet
  182. Solved: Unique values from date range
  183. Solved: Maxif UDF required
  184. Solved: page breaks question
  185. First Step in VBA
  186. Solved: Relative Links
  187. User Input for Formula
  188. Setting text box values to currency
  189. Passing Array
  190. Solved: Self message to save file before closing it
  191. Newbie to VBA:how to define a very long string?
  192. Excel 2007
  193. Results did not write to Excel timely.
  194. Solved: Multiple attachments - email
  195. how to get today's date in text format?
  196. Using Scripting.Dictionary with UDTs
  197. Referring to lots of Text Boxes on a userform
  198. How to start from active cell
  199. Moving & copying between two workbooks
  200. Solved: Password formated cell
  201. Solved: What's the difference?
  202. 2 excel questions
  203. When to Use ?CutCopyMode = TRUE???
  204. Harddrive Id
  205. On line date for setting expiry period
  206. setting Print Area
  207. Solved: Need Help with Protection Scheme
  208. tool bar nad connectors and ...
  209. Using Excel to post HTML form
  210. Combining selected work sheets into one
  211. could not load an object because it is not available on this machines
  212. Adding worksheets
  213. how to distribut a form project?
  214. Solved: Run Calculator
  215. Solved: Change event
  216. Solved: Navigate Controls
  217. [SLEEPER:] Activate Esc key in Calendar userform
  218. VBA Evaluate function not working in arrays - Need alternate
  219. Updated time on Cell
  220. Recover variable value after saving document
  221. [SOLVED:] Array problems
  222. Help - activate sheet
  223. Button in Excel to open a New Contact in Outlook
  224. More showed up and Repeated Data!
  225. Computer Hangs
  226. [SOLVED:] Avoid unwanted messages
  227. Solved: Logging previous values in series of cells
  228. Function or not?
  229. Looping formula...
  230. Solved: Scroll Bar
  231. Master broken into week 1, week2, etc...
  232. [SOLVED:] Adding Next Line Character in a Cell
  233. Extract numbers only
  234. Solved: Onkey
  235. Solved: Move to next cell
  236. Help: How to get function return result in the cell next to it
  237. Editing Initialize Procedures for Dynamic User Forms
  238. Abstract first 6 characters from a column
  239. Workbooks.Open ... AddToMru:=True
  240. Solved: VBA Evaluate function not working in arrays - Need alternate
  241. Solved: Import data from text file
  242. U.K Can any one recommend a VBA course?
  243. Solved: Image instead of Comment
  244. VBA simple step
  245. replace code in VBE with values on worksheet
  246. Attach ActiveSheet to Email
  247. Formatting a Cell
  248. Name definitions lost after import
  249. Forcing user to accept macro?
  250. Use worksheet functions in VBA w/out opening sheet