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

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