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

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