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