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

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