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