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