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