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