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

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