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

  1. Solved: Numeric calculus for Matrices
  2. converting .ps to .pdf
  3. chart base on category
  4. Copying from cells on same row selected by user
  5. Solved: beginning with userforms
  6. Active button coding
  7. Create a Letter and Label from Excel
  8. Send email notification when conditions are met
  9. Creating buttons is very slow
  10. Creating Addin that will work regardles saved folder location
  11. UserFrom if can edit
  12. Solved: Excel Add-IN
  13. how to optimise sumproduct function
  14. Broken macro - can't transfer from excel to access!
  15. Compare, Copy and Paste using VBA
  16. Solved: LOOKUP function not Functioning!
  17. Solved: Check if data exists, then copy
  18. delay between codes
  19. Solved: Updating Excel Chart
  20. How to replace Access data from EXCEL instead of adding to it?
  21. How can I create a Vlookup to certain columns in a closed workbook?
  22. Applying Template to Power Slides via Excel
  23. VBA: If Date (range) Then (do this)
  24. Enter Formula in Cell Based on Heading in Another Cell
  25. Solved: hiding columns
  26. beforeclose, saving the workbook
  27. UDF Returns circular reference...?
  28. Please help me to write the code for this Excel-VBA problem?
  29. A Userform to enter data on a new line
  30. Produce charts with range containing formula
  31. Solved: Referencing UDF from another workbook; Evaluate?
  32. Getting Error Message in Excel 2007
  33. making a "Formula like" userform
  34. Solved: x dimensions array, combobox and loop...
  35. Increment upper bound of loop
  36. Solved: function match : error in vba
  37. Delete Sheets
  38. Delete Rows if Value in Column A
  39. import large CSV file(more then 80k records) to MS Access table
  40. Solved: Change font characteristics depending on value
  41. Solved: Function/Sub with Parameters assigned to a Button
  42. Receiving variables from a batch file
  43. Split range of cells into individual numbers?
  44. Need Help
  45. Solved: Uhh... Corresponding number detection and copying
  46. Solved: Counting different values
  47. Use Find Across multiple workbooks/ multiple worksheet
  48. Solved: Chose last of identical data from a column
  49. UserForm help, assigning variable from option button selection
  50. Solved: Redim Preserve
  51. ComboBox can't typing the value ?
  52. Solved: Delete if matching colour
  53. Solved: Match function in Vba
  54. Display DownTimer in the UserForm & at the same time User should work with UserForm ?
  55. Even or odd week?
  56. Creating fields
  57. VBA help
  58. Solved: Insert blank row below set value
  59. Solved: Choose data for use in control limits
  60. Solved: VB code for greater than 1 or less than -1
  61. Using Excel type formulae in VBA Forms
  62. Solved: Update buggy workbook links with .Activate
  63. Ftp Folder
  64. advanced find and replace loop
  65. How to Retrieve the Last Search Term from Find()
  66. Disable comments on mouse hover
  67. Solved: Run macro in another workbook without its name
  68. For...Each Loop Backwards?
  69. Solved: Conditional formatting not working unless I step into a cell
  70. Folder referance ?
  71. Solved: Compile error in hidden module: distMon
  72. Using form to editing
  73. Generate file name with date from cell (not current date)
  74. Solved: Copy Paste in arranged manner
  75. Solved: To check if to versions are identical
  76. How to copy contents of text file to tab sheet of another excelsheet
  77. Solved: Userform Commandbuttons query
  78. Button to unhide sheets
  79. Solved: Backing Up in a Macro
  80. Solved: Sort multi-dim array by one value?
  81. Automatically Insert Hyperlink When Text Is Typed In Column
  82. Solved: Return DAY of Week based on Date
  83. A Loop in a Loop
  84. Numbers Directory
  85. Search a range of columns for values?
  86. Combo box
  87. Excel 2007 Buttons in Print Preview Disabled
  88. Macro code to generate Email..help
  89. Environmental variables to get to ?My Docs? or "My Documents" location.
  90. Dropdowns and Zoom??
  91. pivot table and MS Queries
  92. Solved: pivot table: sum column is incorrect
  93. Sending mails
  94. Solved: Creating Dynamic Validation Lists Based on A Selection from Another List
  95. Solved: Validating Excel data entry
  96. Solved: Need Macro to pull data from Web
  97. Solved: Compressing files
  98. Select or msgbox last cell edited by code?
  99. VBA if..then comparison not working ???
  100. Solved: Copy rows selectively
  101. Solved: Form-Filling GUI: ComboBox problem
  102. Solved: Trying to uninstall addin when closing file
  103. Update Checkbox across workbooks
  104. Create a consecutive character array?
  105. Excel - Email Groupwise HTML
  106. Image as Multipage Caption
  107. Solved: sum values based upon 2 or 3 conditions
  108. Refreshing data from multiple large workbooks
  109. Solved: Save specific cells in Excel with a Macro
  110. Solved: How to find the first and last row of merge Cells???
  111. Need help to get rid of unwanted " in text output file from an excel macro
  112. User Forms behaving strangely
  113. Print ranges on worksheet
  114. Macros Paste Special to another Workbook
  115. How to write a formula with a bunch of 'IF' statements
  116. Copy row from workbook if...
  117. VBA Code for mail merger & Printing
  118. Autofill not working
  119. Charting an array as a series
  120. Why does .address put $ in value
  121. Why my program gets slow down after running for a while
  122. Solved: Using IsInPlace
  123. Solved: sort without worksheet?
  124. Excel Chart Lists
  125. BO reports (rep files) need to be refreshed from Excel Module
  126. auto filter
  127. Solved: Image to Excel
  128. Copy Paste toggle not working
  129. Why is this chunk of code freezing
  130. Alpha Testers Wanted
  131. Solved: Multiple 'On Error' commands in function doesn't work?
  132. Solved: Worksheet freezes up
  133. How to automatically trigger a VBA code to respond to expected msgbox
  134. Putting variable values in a second sheet
  135. Solved: swicthing between formulas
  136. vba if statement
  137. ERROr while running a macro
  138. problem with combobox
  139. Solved: pb: if condition = true then go to next iteration
  140. Solved: Excel Charts again
  141. Solved: Help Alter Code
  142. Enable paste
  143. vlookup in Vba + preventing tabulations in a form field
  144. Linked Picture; Add to Comment
  145. Solved: Preventing N/A# in Vlookup?
  146. Solved: vlookup non-contiguous ranges
  147. Using VBA to copy and paste the content of multiple worksheets to a new files
  148. Solved: Returning an array from a function
  149. Excel File Sharing Communication Tool
  150. getting a Macro not to call another macro ??
  151. Copying values
  152. Solved: Combine H and V lookup or better idea?
  153. Solved: Run-time error '53': File Not Found
  154. Use text from embedded object
  155. Excel 2007 template - issue with vba macros (emailing)
  156. Adding multiple entries to Time Sheet
  157. Convert to PDF on Legal Size Paper
  158. Solved: Returning data based on multiple criteria
  159. Dynamic Form CheckBoxes Controlls
  160. Date format
  161. Solved: copy contents of one workbook into another
  162. Solved: SUBTOTAL COUNT
  163. Help! Excel User prompt for data input
  164. Solved: Writing to a word file from within excel
  165. Fix data position
  166. Solved: 2D Arrays
  167. Conditional Formatting with command button
  168. Solved: Insert blank row, NOT "insert copied cells"
  169. Solved: Check cells in an AutoFiltered Range
  170. Solved: Copy and Paste - File to File (All files are Password Protected)
  171. Running a User Defined Function in VBA
  172. Solved: sumif feature needed for multiple criteria using wildcards
  173. A reminder please, copying range from one ws to another
  174. Shared Workbook Woes
  175. Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell
  176. UserForm: Initialize a ListBox
  177. Number of Objects Limitation in Sheet
  178. Solved: Creating A Shortcut Key
  179. Solved: UDF to convert long date to "mmmyy" String
  180. Solved: VBA hide columns or rows based on certain criteria
  181. Solved: Sub to Open workbooks, and update named ranges
  182. Solved: PLEASE: Chart Help
  183. Solved: Extracting only part which is within brackats
  184. Solved: What is escape character for quotation marks?
  185. Checkboxes and Sheet Protection
  186. Multi Tracker Entry Help
  187. Extracting information after B/C
  188. Solved: sort ascending leaves blanks at the top
  189. Row & Column Indicators
  190. Solved: Days Difference between text box
  191. Solved: I want to go to "File Save As" as soon as openned
  192. How to write a VBA-Excel code to find geometric mean?
  193. Dynamic Range over extending issue
  194. auto print
  195. Appends the contents to the respective columns
  196. add extra step to macro
  197. Solved: insert code to show progress
  198. Problems with FileCopy and Wb(name).close
  199. How do I keep a Custom Menu attached to a sheet?
  200. auto fill
  201. Solved: How do I get excel to change the colour of cells dependant on values in other cells?
  202. speed macro using array
  203. Solved: get the name of the selected file.
  204. Iterating through an array, and omitting results
  205. Help with wierd way of doing things
  206. Solved: Combobox - Dynamic Named Range
  207. User function to solve Polynomal equation
  208. Solved: Trouble with Inserting Rows
  209. Polynomal trend line
  210. Solved: Insert a new row after finding text "total" in a cell
  211. WorkBook Log-in Access
  212. Look up and sum across sheets?
  213. Change line color for new series programatically
  214. easy vb help
  215. Solved: Easiest way to check/uncheck all checkboxes?
  216. Page Header: Always 1st Row of ColB of that particular page should appear
  217. Cut Paste macro
  218. Solved: Stop user accessing worksheet "Administartor"
  219. Solved: clear data in data based upon a condition
  220. Color column A if another column equals 2
  221. Solved: Consolodating totals for duplicate rows
  222. Check for a particular value and formatting the cell in another sheet
  223. Help - Range Values Selection
  224. Solved: Two arrays and one set of code
  225. Compile Error
  226. Solved: Double Click, Insert Character
  227. Solved: Matching Multiple Cells
  228. Useing a variable to control a combobox
  229. VBA Script to open macro dialog box
  230. Help With - For Next Loop & Possible Inclusion of If Statement
  231. VBA script to download data from a url
  232. Solved: How to detect multiple cell selection
  233. Solved: Filtering issue
  234. Solved: Function to Return Offsetted Values
  235. Simple Question, Hopefully
  236. Solved: Sort by two criteria
  237. Solved: Dates Screwing up!
  238. VBA script to copy workbook contents
  239. Formatting issues: copy/paste & Ctr-F
  240. Help with Find program
  241. Solved: Check if cell begins with number
  242. Tricky worksheet Problem....
  243. Sub or Function not defined - switch off
  244. Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts
  245. Copy range in new sheet by criteria
  246. Assign Macro Shortcut
  247. How to make a range reaonly or locked or non editable???
  248. help with a message box on error
  249. Solved: Msg box - if password is wrong
  250. Solved: Trim the fat