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

  1. Trial some VBA CD burn code
  2. Fill combobox from different worksheet
  3. Solved: Color banding
  4. scrolling text on a form
  5. Solved: referencing a tab name in a sumproduct formula
  6. Solved: Excel 2003 - Something faster than a Loop to check the used range surrounding Border
  7. Solved: WorksheetFunction.Match can't find date
  8. Create workbook from template, enable link updating
  9. VBA Forms - Passing a Variable
  10. Solved: Select Case with multiple criteria
  11. Office clipboard as datasource
  12. Archiving weekly data
  13. HELP with VB/HTML code.
  14. Solved: Check cell string in column
  15. Not able to get HTML text including formatting
  16. copy
  17. Solved: multiple Application objects
  18. Solved: copy cell data
  19. find/place based on cell but absolute reference issue/macro mainting sequential order
  20. Solved: LOAD only visible cells to combobox in userform
  21. Stuck in OFFICE12 folder after SendMail
  22. Solved: Slow Down On Running Code
  23. VBA Help
  24. Solved: COPY/PASTE OR JOIN
  25. Numbers from strings
  26. How to create one button for locking/unlocking all sheets
  27. Solved: Using Variable Cell in IF Statement Formula
  28. Show/Hide button - Excel vba macro - List
  29. macro for workbook source change
  30. indirect address + skipping cell
  31. Solved: Word to Excel
  32. Asking for VBA help
  33. code from snow
  34. Search
  35. [SOLVED] ListBox on a worksheet from Forms Controls Toolbox
  36. formula to vba
  37. Open text file and write to excel file
  38. end(xlup) cant work
  39. Solved: Select Collumn based on Cell Value
  40. Selecting Blank Cells with in the selection
  41. getting values dynamically from cells A1 t0 A100
  42. insert figure end of formula
  43. Copying Columns from One Sheet to Another
  44. VBA for Find & Replace
  45. Changing Tooltip size and color
  46. Updating fields on external input
  47. Input restriction
  48. Solved: Number Formatting
  49. Solved: Import Module via VBA code and delete existing Module with same name
  50. Using Index Match across multiple worksheets
  51. Solved: Excel 2003 - Need to clean extra commas from string
  52. Solved: Excel 2003 - Need to determine if any text has been entered into a numbers only cell
  53. Solved: Print different sheets - Print area does not clear - Print_area already exists
  54. Solved: Drop Down List
  55. Copying Contents from one sheet to another
  56. Automatically copy cell contents
  57. insert control Toolbox failed
  58. Solved: Autofill till cell left of it is empty
  59. Classic 2003 Excel Menu add-in for 2007?
  60. Control Internet Explorer using active URL
  61. Powerball Reconciliation
  62. Solved: MsgBox Item
  63. Excel-Copy worksheet and timestamp
  64. Solved: Change Event not triggering with "Tab" key
  65. userform cancel button
  66. Solved: Response Time Formula
  67. Excel 2003 - Need to detect Cell Insert shift left or shift down or Entire Column
  68. Connecting oracle and excel sheet
  69. Solved: Design Time Vs Run Time
  70. Modifying The Code to Check if the entry exists
  71. Different pivot charts 'different windows' in the same worksheet
  72. Returning Values
  73. Solved: Copy values to Empty cells below filled cells in selection
  74. UserForm Trouble
  75. Solved: Exporting word data to Excel vba
  76. Excel VBA - How to Create Read Write Edit Del by ADO - Jet.OLEDB - Access - MDB
  77. Solved: Excel 2003 - Delete rows with no values in Columns A thru E
  78. Solved: Macro with launch button
  79. VB Inserting image to specific cell in excel
  80. Excel 2003/2007 - AutoComplete is inconsistent
  81. Create "Save As" button on UserForm
  82. match/copy/paste
  83. Solved: countdown timer
  84. How To Do Relative xPath In CustomXMLNode?
  85. Application.Run (RptObj.Name & "!Main") vs Application.ExecuteExcel4Macro "RUN(""Main
  86. Solved: How to display information in other columns with missing information
  87. Solved: combo bug in userform (it makes roller)
  88. Tab from specific cell to cell
  89. display negative number if greater then 0
  90. File on hard drive or network drive
  91. Chart/picture location problem
  92. Solved: Data Collection
  93. open Microsoft windows mail and attach
  94. Solved: Populate values multiple times date wise
  95. Solved: Renewing data upon opening workbook
  96. Solved: Find values and distribute in cells
  97. How to count nbr of QueryTables in workbook
  98. How can I read a text file and write values into an excel sheet
  99. Reduce macro code size
  100. Solved: create the button on file A, but use it for file B
  101. Optional argument in a function error
  102. select a sheet from list
  103. move worksheet to end
  104. Solved: How to input data from a text to excel using Excel VBA?
  105. Controlling settings in Publisher from Excel
  106. Solved: Use Advanced Filter In Excel 2003
  107. Looping the String in SQL Statement
  108. Macro to paste a picture in Word
  109. Solved: Loop In VB Code
  110. Solved: How do I adapt this code to export Multiple Charts?
  111. Unlocking Options Buttons, Forms and Checkeboxes
  112. Solved: Unprotecting Cells
  113. Solved: Global Unknown Size Array
  114. Automation of an system issue.
  115. VBA Code (Excel) - Please Help
  116. Solved: Should be a simple sort, but is it?
  117. Solved: SUMIF or vba workaround
  118. Cleaning out pivot table and then using same pivot vache
  119. Solved: udf: countif for multiple ranges and sigle or multiple criteria
  120. list all items
  121. Using a loop and time delay
  122. Solved: Delete Column and Row
  123. how to check a given input is a String
  124. Safe save file in *. xls
  125. Solved: display 100% maximum
  126. Solved: Not to highlight when selected
  127. Solved: CountIF using two criteria
  128. clearing text without removing color
  129. Am stuck! how do I force exit a macro?
  130. 2003 vs 2007
  131. Excel:VB Sum up value in specific field
  132. Solved: Word to Excel Copy
  133. Sort Pivot Table based on value of Drop Down List
  134. Solved: Compare cells contents (VBA)
  135. Solved: Userform not opening with a Button
  136. Solved: Fill blank cells with date using a criteria
  137. Solved: remove the repeated words/numbers in a cell
  138. Check pivot table for value fields
  139. mail cc
  140. Solved: Extract Data for specific columns - Formula
  141. Change Chart Source Range Using Drop Down Box
  142. flashing code
  143. Protected Sheet and Data Validation
  144. Solved: Need help with a macro!
  145. handler for external event
  146. Solved: How To Set Global Parameter for macros based on the userform check box clicked
  147. Solved: Spell Check an ActiveX TextBox?
  148. Export a range of data From Excel to Access Database and check for duplication
  149. Copy Excel workbook without formulas??
  150. Solved: Holiday tracker - suggestions?
  151. Solved: Import sheet from closed work book?
  152. Copy Rows based on cell value!
  153. Problem with Union function when opening multiple datasets
  154. Command Button To Expand / Collaspe Subtotals
  155. Solved: How to reference an option box in a checkbox?
  156. Solved: Populate combo box
  157. Help! Prompt User for Pivot Table Sort Criteria?
  158. VBA Project password
  159. Sleeper: Consolidate files
  160. Solved: Help with replace [a-z][A-Z][0-9]
  161. Combine text using loop
  162. Solved: Sub arguments (simplifying code)
  163. Macro to Display Certain Items of a Pivot Field
  164. Solved: Remove Zero Calculated Rows from Pivot Table
  165. Macros crash Excel
  166. Solved: How to get an age from a DOB header with a Stop date?
  167. Automating Userform Mapping to worksheet
  168. Excel 2003 - Clean Up Formula Error Values and other
  169. Solved: Transposing Data with Non-Standard Fields
  170. Solved: Copy a Sheet,delete a range Then save the org Template
  171. Open PDF file
  172. Dislay an asterisk after a number
  173. When I type a word, a formula will be entered in the cell in column D on the same row
  174. Solved: Excel 2007 _Can I store a HELP .txt file inside and .xlsm file?
  175. Solved: insert letter into blank cells
  176. How to get International formats?
  177. Solved: extract specific data into the sheet
  178. Adding a functionality to change the color of ASINS
  179. SUMPRODUCT help needed!
  180. Solved: Lookup / Sumproduct Issue
  181. Creating a new worksheet with appropriate "(name)" attribute
  182. Solved: Private Sub Help
  183. display negative values as $0.00
  184. Solved: Automatically Importing CSV Files into Excel.
  185. Solved: compare two columns and delete matches
  186. mimimum length for a textbox
  187. Assigning a null value to an Integer
  188. Solved: Possible Index/Match formula
  189. Solved: Generate a random List of names from table
  190. Error 1004 when selecting a range of cells
  191. Solved: Iserror + Vlookup to color cells where value is present in a list
  192. Different ways to share an Excel Workbook
  193. run-time error 1004, microsoft office excel cannot paste the data
  194. Log in web querry
  195. Solved: One Question?
  196. Solved: How to call a macro in for - next
  197. Solved: Irregular Sum
  198. [SOLVED] Only numbers in a texbox
  199. Total Open Positions
  200. Solved: Stop Form Closing "X"
  201. Update Formulas to Reference New Cells Instead of Deleted Ones
  202. Window of my workbook becomes inactive.
  203. Solved: Code To Compare Data in two sheets and highlight differences
  204. Solved: specific lentgh for a textbox
  205. Solved: Vlookup on todays date
  206. Using Calendar Control to fill in dates
  207. Solved: is it possible to disable xl2003 file open in xl2007+
  208. userform.print problem
  209. Autofit Merged Cells / Autosize Formatting
  210. Runnung JavaScripts as a button.
  211. Solved: Looping through Dynamic Array
  212. Solved: Which sheets are select in a workbook?
  213. extract specific data from a txt file
  214. Calling other macros
  215. Insert row on value change and copy values from above
  216. Solved: how to determine the trimester of a date
  217. Looping a solving procedure?
  218. Can anyone help with an IF formula
  219. Issue Selection Data Validation List used to Filter Pivot Table Field
  220. Issue Selecting Unique Date: Data Validation List used to Filter Pivot Table Field
  221. Solved: User Id/Password
  222. Using Excel and VBA
  223. Incorrect Field Types in ADODB Recordsets
  224. Significant digit issue
  225. VBA E-mail Open Workbook as Attachment in LOTUS NOTES
  226. Import text file into spreadsheet
  227. Help writing a VBA code!!!
  228. Filter Sheet With date
  229. Code Error: object variable not set
  230. Solved: Excel 2003 - My for ea loop is not looping per inputbox number
  231. Solved: Excel 2003 - Need the numer value at the end of a string
  232. if..............in
  233. Solved: How to open a Specific file MsWord( example C:\MyW.doc) from MsEXcel...
  234. activating a window in the taskbar
  235. Displaying Images from Folder on Network in Excel Based on Cell Value
  236. Excel 2003 – History log file of new row inserted and any data added into it.
  237. Excel 2003 - Can I notify user that I'm waiting for read/right access to a workbook?
  238. label right-click event
  239. Excel VBA to add/delete windows scheduled task
  240. Solved: remove the repeated words/numbers in a cell
  241. show numbers with commas
  242. How to fill all filenames into array without for-next or do-loop...
  243. Solved: Vba to Okay Digital Cert and Signing data?
  244. VBA Cond. Formatting, two sheets
  245. Solved: Excel 2003 and 2007 - Cannot make selection in Listbox2 if click Button twice
  246. Variables declared with 'New' cannot be made Nothing!
  247. Solved: Restrict Text Box
  248. Pastespecial xlvalues
  249. Couple days of work - now lost
  250. user form textbox issue