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

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