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 174

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