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. Solved: compare value of two cells to value of two columns in dynamic array
  2. Solved: Workbook Directory path
  3. User Input
  4. Solved: Clear cells where using a certain font
  5. Clearing extra characters from imported data?
  6. Solved: using countif in code
  7. Solved: Export/Import data to multiple workbooks?
  8. Input mask
  9. [SLEEPER:] Which function uses Minimum Resource, Minimum Calculation Time?
  10. Creating Arrays within Pivottables
  11. [SOLVED:] Log on to a password protected website to view info
  12. [SOLVED:] Deleting rows based on criteria
  13. Solved: cell is not emtpy even if no visible value
  14. Solved: Adding form data to two sheets
  15. Adding radio buttons and counter on excel test sheet?
  16. Copy and Offset??
  17. Copy data from Excel to Word with gif image
  18. next iteration in loop
  19. Dynamically look between Paranenthesis
  20. Solved: links
  21. Poor efficiency: Code runs too long
  22. Trying to import data from one excel sheet to another
  23. [SOLVED:] Inserting columns late - hours of regression testing
  24. Solved: Autofilter problem
  25. Solved: Any tutorials about adding items by typing into a Combobox?
  26. "Create a unique list and count of items from an unsorted list" Help
  27. file size
  28. get Column Letter
  29. VBA Excel Helper Subprocedures;Homework
  30. How to find row from address
  31. Solved: If Cell Value is Worksheet Name Copy Row
  32. Solved: Incrementing a cell that has a forumla in it
  33. [SOLVED:] Trig help
  34. Solved: Treeview & Imagelist relationship
  35. Find a word and extract data to another sheet
  36. Copy data from Pivot Table
  37. Password protect the macro coding
  38. Solved: Simple Encryption
  39. dynamic formula help
  40. changing ctart titles using VBA
  41. [SOLVED:] Changing chart titles using VBA
  42. Solved: CREATE 2X1 MATRIX IN EXCEL AND PULL FROM THIS
  43. Solved: Displaying cell data in inputbox text
  44. Copy preferred row to same named Sheet
  45. Problem with codes on different machines
  46. Solved: Writing a formula in another sheet. Should work but I get #NAME?
  47. [SLEEPER:] Loop through cells values on each button click
  48. Match headers when importing text files
  49. Assigning cell values
  50. Excel sheet focus problem
  51. Solved: Splash Screen
  52. Importing data from another workbook causes error 9 message
  53. Solved: PasteSpecial and Selection Areas
  54. print and name PDF file
  55. Help me creating files index
  56. Trying to Split a long string in same cell
  57. Workbook_Open executes after a pop-up box
  58. Problem with my vba code
  59. Solved: Worksheet Copy creates new Workbook
  60. Solved: find max in multi dimensional array
  61. Solved: excels analysis tools
  62. Solved: Named Range Across Sheets
  63. Solved: Conditional Deleting of Rows
  64. 'CurrentRow' Expression & Skipping through records
  65. Unexplained Error with code
  66. Get Last Accessed Date/time
  67. Countdown timer
  68. Funny: Excel 12 Help file!
  69. Chart axes setting problem
  70. Why is my alignment vba code not working.
  71. How 2 ntermittently pause recalculation process & read the dispalyed statusbar text?
  72. Solved: Auto update data fm one Worksheet to another Worksheet
  73. Solved: reformatting spreadsheet
  74. Vlookup for user form
  75. Solved: creating Chart using Dynamic ranges..
  76. Changing cells' format
  77. Solved: Data Validation -- Combo box VBA
  78. Solved: Copy bookmarks to Excel
  79. Solved: Search row for text and delete column if equal to a value
  80. Login Secure site
  81. Exporting to c:\test.txt problems
  82. delete row if column f is blank
  83. Solved: Adding days when checkbox checked
  84. Solved: Compile error in hidden module
  85. Solved: Moving to London: Is anyone interested in hosting my duplicate master webpage?
  86. [SOLVED:] 2007 compatibility
  87. Solved: Copy sheet to new workbook without copying the code?
  88. Copying multiple column data in multiple sheets to one column in Master sheet
  89. Solved: Problems Distribute Excel Add-Ins in a high demand environment
  90. Solved: Using two commands in Excel 2007
  91. Solved: Using Start and End Date via a form?
  92. placing a floating combobox on top of a cell in OWC11 spreadsheet using VBA
  93. Solved: Hiding & Unhiding Columns base on a Data Validation or Cell value
  94. Solved: Disable Web site auto linkage to Excel
  95. SUM VISIBLE COLUMNS ONLY
  96. Solved: How to create listing in Combo box of User Form
  97. Solved: Zipping files in a folder using VBA
  98. Contingent row copy (make duplicates)
  99. Solved: If Without Block If
  100. CAll a macro on entering data to a cell under a column
  101. Solved: issue with using DATEValue in VBA, with VLookup
  102. Combining Macros
  103. Solved: How to discover repeat text names in Range array?
  104. How to copy files into a current user profile folder using Excel VBA macro?
  105. How to create a .xls file on a remote server
  106. How to use the Connections.Add method
  107. Solved: Filter data and count unique
  108. custom function error.
  109. Audit trail macro on excel?
  110. [SOLVED:] Alternate shading via conditional format with a twist
  111. Solved: Automation Error 440
  112. Solved: Update Value from one column to another column under 1 row
  113. Solved: Vlookup or not?
  114. Wrapped (R)
  115. Multiple log in & update a file that contain Macro
  116. Solved: Calling a Macro from an OPC linked cell
  117. Short code to set caption on labels based on cell values
  118. Solved: Remembering entries
  119. [SLEEPER:] Check which cmd buttons is clicked
  120. Solved: comments object, placement property
  121. Scaling Values in a Chart.
  122. Solved: Open pdf or image file from predefined folder
  123. How do i save as *.xla in VBA?
  124. Protect Sheet
  125. formname.PrintForm disables msgbox
  126. Solved: Combobox popup window without scroll bars
  127. Solved: INCLUDE SIGNATURE IN AUTOMATED MAIL SENDING
  128. VBA Formulas
  129. Byte Comparison for Strings
  130. Solved: strings add a zero
  131. clipboard
  132. Solved: Moving all files from one folder to another
  133. Solved: macro to add FileName and currentdate to an existing worksheet
  134. Combine Certain Data From All Worksheets in All Workbooks in a Specified Directory
  135. Loop through hundreds of files in a folder using select CASE
  136. Looping timer
  137. Formula to distribute a number in forward years with the cond. it is equals an amount
  138. [SOLVED:] Vlookup - Im completley confused
  139. Solved: Calculating Week Ending date based on Sunday week end?
  140. Ribbon control mouse click detection
  141. Solved: Another sorting problem
  142. Pull Data from range
  143. Solved: Date from textbox to cell
  144. Solved: VBA Calendar problem
  145. SOLVED: Disable Custom Buttons when no Worksheet is Loaded
  146. Permutations in a class modules
  147. Disable msg SaveAs
  148. Solved: Prevent "This workbook contains links" window from popping up
  149. Editing Chart Data Labels in Excel 2007 using VBA
  150. [SLEEPER:] Value find help
  151. Pivottable macro - ManualUpdate problem
  152. Solved: Copy/Paste from HTML Spreadsheet to Excel
  153. VBA or In-Cell functions for Duplicate handling?
  154. Save as .txt
  155. Solved: Better Code for Textbox
  156. Solved: Paste to next empty row
  157. Solved: Zip / Rar thru VBA
  158. [SOLVED:] Keeps crashing on this code
  159. Solved: finding Strikethrough font
  160. Extracting value from 1 of three columns where value exists
  161. Searching for cell value in another spreadsheet
  162. How can I Run Macros In Other Excel File?
  163. Turn off custom functions
  164. Solved: Show MsgBox if autofilter results in zero
  165. Solved: Dynamic Pivot Table
  166. Solved: Macro to create a "Draft" Watermark stamp for workbooks
  167. Delete a Name Range that references a spreadsheet that does not exist
  168. Solved: Open new application in maximized position
  169. Extract various data from Worksheet into one column using certain criteria
  170. Sleeper: Inserting flash animation
  171. Dynamic protection of data
  172. Does anyone use VSTO2008?
  173. Get Sepcified Detail From Worksheets
  174. Solved: Things That Happen When A Workbook Is Closed
  175. Referencing Worksheets from Macros
  176. Sharing An Excel Workbook
  177. Datestamp + Calculation
  178. [SOLVED:] Compare rows from two sheets and highlight non matched rows
  179. Max length of textbox with multiline property.
  180. Mailfunction - Send mail when document is updated.
  181. Format Function with Numbers
  182. How to make userform/wizard remember value even after it is closed
  183. Solved: Colour format cells in each row with highest values
  184. Solved: Worksheet formula to convert text date YYYYMMDD
  185. How to Use a Class Module from an Excel Addin in VBA
  186. Separate Parts of a Name String into Different Cells
  187. Solved: got upgraded and Files functions dont work
  188. Application.Calculation
  189. Locking Excel 5.0 VBA
  190. Solved: select and copy cells through VBA
  191. Solved: INCLUDE NAME/MNEMONIC IN MSGBOX
  192. Solved: Automate Answers to vbMsgBoxResults using a macro
  193. [SOLVED:] Moving Excel files into folder based on filename
  194. How to stretch some range, if in contains some protected cells?
  195. Sort ascending with expand selection
  196. Solved: Checkbox correspondence
  197. Any way to rename Sheet1 to the name of the Workbook when you save?
  198. Solved: Error recovery when there is no worksheet
  199. Problem with Colors?!
  200. Have Excel identify last entry in a range
  201. Solved: Run Access Macro without Reference
  202. Variable names to refer to column and row
  203. Create a button and asign Macro from VBA
  204. Testing connection string and SQL statment
  205. CSV File
  206. Extended use of VLOOKUP function
  207. Edit Function & My Checkbox
  208. identify dates in a cell using macro
  209. SUMIF function
  210. Solved: .UMAS file extension
  211. Solved: Excel Sheet Protection
  212. Sleeper: How to create table of missing items?
  213. Need help comparing worksheets
  214. Solved: Send both html signature and body of email together
  215. Solved: activewindow.panes(i)
  216. Using Comboboxes to Update a Worksheet??
  217. Solved: Run macro every day automatically?
  218. Conditional Formating - Based on the Originator of Document?
  219. How do I require data entry in a cell before moving to the next cell
  220. Solved: Create a database from info coming from tabs
  221. [SOLVED:] Extracting Row Number using VBA Function..
  222. Solved: consistant data in different table same workbook
  223. Solved: Testing the sheetname
  224. Need trim to include leading space
  225. Solved: Macro to keep data in tables in order
  226. Create automated form excel
  227. Getting <Title> out of HTML source code
  228. DisplayFormulaBar Problem
  229. How can I put Multiselected files (not one) into listbox?
  230. Solved: carrying over sheets
  231. [SOLVED:] Totaling manual subtotals
  232. Excel VBA 2003 Out of Memory Error
  233. Solved: Check Date From A List
  234. Prevent WB Open if Macros 'Disabled'
  235. Auto generate Excel File Name?
  236. Display Charts
  237. How to add References to a VBA Project?
  238. Solved: Adding sourcedata to Pivottable
  239. In macro how do i go to last worked cell
  240. Solved: How to get CompId in UserForm
  241. Solved: Selecting used range of each row in loop?
  242. Solved: Is this possible
  243. get value of cell for pivot table
  244. Solved: Dependent Validation Lists
  245. Solved: Add button to bar
  246. customize menus
  247. Solved: Parse Method
  248. [SOLVED:] Pivot Table Error
  249. Live Data over network
  250. Setting Current Position equal to Last Position: Homework