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