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