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