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