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