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