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

  1. function variables show on sheet
  2. Multiple criteria, one value
  3. Object Required
  4. Indicating calendar
  5. Solved: Sort and search on a table
  6. Excel Template mode
  7. how to combine GetItems() - syntax
  8. retrieve data from web
  9. Solved: Combine Few Sheets to one summary sheet
  10. Worksheet Calculate Question
  11. Delete freeform from spreadsheet
  12. problem with if, then, else
  13. Simple input and data problem
  14. Module to Delete rows by multiple column criteria
  15. Batch File Renamer
  16. Skipping Cells on a Loop
  17. View Calendar
  18. Solved: Get selected Date
  19. Solved: Delete freeform positioned over chartobject
  20. Solved: Msgbox if Something is Entered Different from Values in Combobox
  21. Passing user defined range into function?
  22. Solved: blink cell
  23. Solved: Lookup and use left characters
  24. Better way to copy text files to a daily report?
  25. Workbook being deleted
  26. User Form Question
  27. Moving sheets in a workbook
  28. Check for Empty Controls in Userform
  29. Solved: Replace function
  30. Excel Date formatting problem
  31. cdate type mismatch
  32. Solved: is there a limit on expressions in IF Conditions in Excel VBA
  33. Solved: perfect weight
  34. AutoFit Columns
  35. Clean and Proper difficulties
  36. help to decrease processiong time vba
  37. Solved: Multiple output function
  38. Solved: changing textboxes' properties programmatically in a userform
  39. Class problems
  40. Modify sheet2
  41. Solved: Multiple force entry
  42. VBA code to convert Excel file(including hiddenfiles)
  43. Last visible row or column in a worksheet
  44. vba
  45. how to copy data (some of them) and copy in an other sheet)
  46. Solved: Convert to function
  47. Solved: Display currency value in red
  48. Solved: Filter problem
  49. Solved: read text file question
  50. Graphing help in excel vb
  51. populate cbo box
  52. combine cells with VBA
  53. fill cells with vba
  54. Make dictionary
  55. Synchornize Excel sheets
  56. Solved: Process Summary Report from Array of Data
  57. Solved: Help on environ validation before opening file
  58. Solved: Excel Crashing Problems HELP
  59. Break for next loop
  60. Problems making VBA code to create start, pause & resume command
  61. Formula problem
  62. Formula problem
  63. Insert rows using a macro button.
  64. Solved: Cells highlighted during selection.
  65. Long hyperlink bypass
  66. Searching and autofiltering the result on the same worksheet.
  67. highlight all text in textbox - only fix
  68. Solved: hlep to create a back up workbook vba
  69. VBA code to create list of conditional formatted ranges
  70. Finding multiple words up to 10 different columns
  71. Blank Userform?
  72. Solved: Paste Range Of Cell Values From Formulas ??
  73. Solved: Autofilter and Copy Data to new workbook
  74. Solved: Count words equal between 2 cells
  75. Open email template files based upon combo box values
  76. Conditional formating based on Value = Range
  77. Solved: A variable within a variable (within a variable?)
  78. How use same code in other excel workbooks
  79. Solved: Dynamic Custom Header/Footer
  80. Code to loop through cells and find component of Formula
  81. Formula R1C1
  82. Name a Range
  83. Excel only runs my sub procedure once?
  84. Solved: Delete all the tabsheets with their names
  85. Solved: Sum or Sumproduct help
  86. Copy and Paste Macro
  87. Solved: Table of Contents
  88. How to randomise looping of variables
  89. Activating a column based in the other column value
  90. Unhide specifc row based on cell
  91. Redundancy search and paste
  92. WinHttp.WinHttpRequest question
  93. Copy and rename named cells in a sheet to another sheet
  94. Time limit
  95. Excel 2000 textbox help
  96. Search for a string and then sort by that column
  97. VB Macro?
  98. Need Help
  99. Solved: Change overall chart font
  100. Compare values of two range of cells and copy entire row
  101. Solved: Update dynamically created controls?
  102. Deny Access to the VBE?
  103. Solved: Need help to save file at User selected folder
  104. Using Excel macros outside of Excel
  105. VBA Delete Entire Rows Based On The Value Of Single Cell
  106. Delete rows in spreadsheet that are not needed
  107. List codes with the same conditions
  108. help to check several conditions on sheet
  109. Editing Data from web recorded Macro
  110. VBA Run-Time Error only on program close
  111. Solved: Problem with listbox and date
  112. Solved: Recognize mutiples and add rows
  113. Solved: Date format
  114. Speed up macro by doing calculations in memory
  115. Assigning values to ComboBox items?
  116. Filter data and copy to another worksheet
  117. Solved: VBA to copy general spreadsheets from one workbook to another
  118. HTML table into Excel
  119. Solved: script to highlight autofilter header
  120. Time limit
  121. Reaching into word from excel
  122. Solved: Shared Workbook: Check for another file
  123. Solved: creating custom toolbar
  124. Viewing The Same Workbook on Two Computers
  125. Call Sub 'GoTo' Point?
  126. index if VBA
  127. move sheets without links
  128. Solved: copy rows on criteria
  129. copying worksheets to workbooks
  130. Automate Getting to MS Query Wizard
  131. Excel keeps calculating - Table:1, 2...
  132. VBA Find question
  133. Suffle array and
  134. code modification needed
  135. Solved: I Need to Restrict The number of worksheets in Excel
  136. Solved: Advanced consolidation help!!
  137. Solved: Paste on exact conditions
  138. Combining Multiple Workbooks and creating separate workbooks with multiple tabs
  139. BeforeDoubleClick compatibility Excel 2010
  140. Solved: lookup date
  141. Do until you no longer firnd "#"
  142. VBA error
  143. Solved: Why this code not works?
  144. UDF with text as input without quotations?
  145. Solved: Save Options
  146. Solved: Copy/Paste
  147. Print Sheets In Time Order
  148. Activate other file
  149. the macro will stop automatically when the time it spent exceeds 3 minutes
  150. Another - Combining Multiple Workbooks Into One Workbook w/ Mutiple Tabs
  151. Solved: Help on deleting previous pict before placing new one vba
  152. split cell value ( Name & Number separately)
  153. Inverse Percentage
  154. Problems in a simple billing tool!
  155. change columns title name
  156. Creating multiple workbooks based on naming scheme
  157. Need Help coding a Dropdown List in a Cell
  158. Query information from certain records
  159. Multipage Active Tab
  160. User defined function does not maintain input ranges from proper worksheet
  161. Solved: Determine if file is run remotely?
  162. Excel 2007 Vba Question
  163. Cell text as pivottable filter
  164. Convert 5-sec period data into 5-min period data
  165. Solved: Remove Data from Pivot Table
  166. Simple VBA operation
  167. Solved: Creating new worksheets with same cell size
  168. SOAP Calls In Excel 2007/2010
  169. Solved: VBA To Unwrap Text In All Cells
  170. Solved: Wrap text in a VBA text box
  171. Locking Code to a Specific Machine
  172. Date format
  173. Solved: IP address
  174. Solved: Shift cells right?
  175. Solved: vba to filter report based on date/month
  176. Copy Spreadsheets with a specific name to another workbook
  177. Autosum unfixed range above
  178. locked cells
  179. Auto-filter and select row
  180. Trying to consolidate spreadsheets
  181. Macro for WS/WB comparisons, and copy/paste two cells based on matches
  182. Solved: To insert formula in specific cell with VBA
  183. Solved: Macro: copying across several worksheets
  184. add rows
  185. no blinking when running and progress bar
  186. Solved: Copying a sheet from a different workbook
  187. Code function
  188. Solved: Open CSV website?
  189. Import historical stock quotes
  190. Searching contents of a Visual Foxpro Database from Excel
  191. World clock excel
  192. VBA Loop using solver
  193. Solved: Import column c !
  194. Remove duplicate rows and retain the first duplicate row
  195. Creating a master Data sheet pulling information from each sheet in book
  196. Send Outlook Email from Excel
  197. Looking up data in a price file
  198. Question on creating a shared spreadsheet with user login and password
  199. Picture input via VBA in Excel 2007
  200. Passing values to a Font object
  201. Solved: Help Writing VBA code
  202. Solved: Need to get Part# from string
  203. Solved: Use data in closed workbook
  204. Solved: Excel Formula to determine calls
  205. Solved: Call the sheets double click event in another workbook
  206. VBA Code to perform inner join on 2 worksheets.
  207. Solved: overflow and failed vlookup
  208. How to create a Dynamic List on a Separate Worksheet
  209. Solved: Get rid of single rows
  210. Solved: Only run this command if Excel version is above 2003
  211. data of pending transactions
  212. Unable to read formula cells value
  213. Compare Monthly, Quarterly, YTD, Prior Year, etc Financial Statements
  214. Cannot paste anything in module
  215. [help]Change from Unicode to word
  216. Hide two rows at a time!!!
  217. copy-paste data from multiple files ( .xls ) from multiple folders
  218. Newbie charting help
  219. Solved: sum specific data
  220. Solved: dont save a window
  221. Comparing the string in excel vba
  222. Question with Forms in VBA
  223. Data input into Internet Form with Frames
  224. File Organizer
  225. Solved: Basic TOC
  226. Solved: Combining VBA Code to an array
  227. Search workbook as you type
  228. Need a Macro to do Daily task
  229. Loop Help
  230. Solved: VLOOKUP REFRESH
  231. Solved: Changing date from day to Month
  232. Create Excel Object 2003 or 2007
  233. Solved: Prevent Workbook from closing
  234. VBA / Macro -- Retreiving Unique Records
  235. Solved: Recognizing quarters
  236. Solved: FileSearch
  237. Time and #div/0 error.
  238. Solved: How to make Userform input data into a specific (hidden) sheet?
  239. How to stop opening a dialogue box?
  240. How to write VBA code to Link to another workbook.
  241. formula in the end of the page
  242. Solved: ActiveWorkbook.SaveAs xlsm help!
  243. set print area if needed over multiple pages
  244. Solved: Listbox Loop in Query update
  245. Addin auto run
  246. execute macro in another workbook, only works when interactive
  247. Best (and smart) way to do ListBox Filter
  248. VBA code for pivot-filter
  249. Cell format verification
  250. Name and row count for every .xls file in a directory