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. Change Column Content
  2. How to populate array with collection?
  3. Excel Macro to delete rows if cell matches List of Values
  4. [SOLVED] find all combinations (no repeats)
  5. Excel 2007 VBA SOAP Web Services Integration
  6. Excel Edit Mode Bug?
  7. Solved: How To Sum Worksheets
  8. bar chart with stacked option
  9. Solved: how can i get labelname in graphic
  10. Excel/vlookup if statement confusion
  11. Slight modification needed - probably take most 3 minutes to figure out
  12. Solved: Vlookup if not match, find the first bigest value
  13. Solved: Multiple Page Sort
  14. Watch what a web page does in VBA
  15. macro to copy data based on criteria
  16. Solved: VBA to send mails based on cell value
  17. scroll through excel spreadsheet keeping both ends freezed
  18. FileSearch
  19. simple formating problem
  20. Unable to set FormulaArray property error
  21. Code to fill a column range with conditional formatting is using absolute reference
  22. Solved: listbox selection
  23. Creating a dynamic chart using the value of a data validation
  24. Amend Excel VBA code
  25. query to copy rows based on criteria
  26. code debugging
  27. Excel data to Word template
  28. How to create a VBA Module from Delphi Code?
  29. Solved: is it possible to make connection between vba and site on the internet?
  30. Run-time error '1004' Unable to get the Insert property of Pictures class
  31. UserForm w/2 listboxes
  32. Solved: How to test statistical signifiance of correlation in Excel
  33. chart change data series color
  34. Amend code in VBA function?
  35. API Calls or VBKey Commands in IE
  36. Solved: Debug help needed
  37. Solved: Error 91, Object Variable or with block not set
  38. How to pass parameters from Delphi to an Excel Macro function?
  39. chose the items (ComboBox) from web site using VBA-Problem
  40. Range setting incorrectly
  41. Solved: Formatting Data in Excel with Various Regional Settings
  42. Excel crashes using Force macros code
  43. Solved: goto a specific cell and insert text using vb
  44. Excel Help
  45. Solved: Extracting based on key from text file.
  46. e-mailing macro (with attachment) would like to modify
  47. Solved: Getting started on VBA project
  48. Solved: Text box instead of message box
  49. Create combo box with VBA in spreadsheet not form ?
  50. Loop through images in frame
  51. Disable one macro when saving a macro-enabled workbook while other macros continue.
  52. Read time 00:00:00 > 23:59:00 rather than <
  53. How to append Signature File in Lotus Notes??
  54. Deleting of duplicate values in worksheet..
  55. VBA to generate XML file to desktop explanation
  56. Macro for importing data from files - also insert blanks and only paste values
  57. Insert End
  58. clearcontents vs delete
  59. Solved: For Each Loop Problem
  60. Solved: Need help including subfolders in file list.
  61. Copy but delete
  62. Using remote desktop from VBA
  63. Solved: Chart needs data points transposed
  64. Solved: PasteSpecial on same sheet
  65. Page breaks
  66. Pivot chart - Full size
  67. Excel VBA code help - converting a date to nearest quarter end date
  68. Need help with MWE's Frequency Count of Selection
  69. Need help with List Validation cells and VBA
  70. Solved: Find Multiple Values in Column and Replace Formatting in Different List
  71. Batch Text Replace VBA from Control File?
  72. Solved: Strange formula problem
  73. Is there a faster way to do the following?
  74. Vba to include comments
  75. External Links
  76. Taking Printscreen-opened application(PuTTY or cmd) using VBA and pasting it in word
  77. Solved: (Strange?) TextBox Exit Sub Behaviour
  78. Formula in VBA module
  79. VBA Addin to Monitor Active Sheet Changes
  80. password protect folder
  81. Hotkey Addin Macro on the Ribbon
  82. CSV to Excel Date and Time issues
  83. Loop through active window applications
  84. Solved: Using timer to close workbook
  85. Overwrite or save as new
  86. v look up in vba
  87. Solved: input box filter
  88. Vba problem
  89. find and compare
  90. how to Avoid zero in conditional formatting?
  91. VBA Overflow error
  92. Excel USB Card Swipe
  93. Solved: copying slected sheets to a new WB then e mail the Workbook
  94. Solved: Formula Help - SUM
  95. How to unhide the hiden sheet
  96. Solved: Dynamic range table
  97. Colored Shapes based on cell value
  98. Help with macro to combine like rows
  99. VBA replace not working
  100. create e-mailing with excel and lotus notes
  101. [SOLVED] Excel 2007 charts - ErrorBars
  102. Moving contents of cell down one cell
  103. Solved: Copy / Paste produce different results each time
  104. Solved: Sub SvMe()
  105. Generate TEXT Files from a Control File?
  106. Merging Data
  107. Convert Table to Range
  108. Need Help....Formula
  109. PivotCache fails?
  110. VBA: Excel 2003 Macro OPEN command for RS232 input
  111. Debugging Question
  112. code to work on conditional match
  113. Solved: Search ListBox2 and Populate ListBox1 with Results
  114. Solved: Insert a row of data before the field headers
  115. changing chart title with vba
  116. Solved: VBA exporting data to fill up PDF field from Excel
  117. Importing data from another spreadsheet
  118. Solved: Mulit Point Lookup Formula
  119. Draw a Custom path on a map based on user input using VBA??
  120. add aorrowshape
  121. Disable Print Preview in dialogue box
  122. How to cut large string of digits into 2 cells with 0 at the begining
  123. scroll to an item on a list box
  124. Retrieve value from cell in next to last row of range
  125. Help with IF Statement
  126. VBA: Creating Macro to scroll to a Cell and move information
  127. What Does this code do?
  128. Sending mail via yahoo using CDO
  129. [SOLVED] Error Value
  130. Solved: Macro recorder does not record chart changes?
  131. Macro shortcuts dont show up in Ribbon
  132. for loops in vba ?
  133. Act on files in directory
  134. Filling out IE form with data from Excel - and some other stuff :)
  135. Solved: Scroll Bar Issues
  136. Solved: networkdays in excel 2003
  137. One line of code - what is wrong?
  138. Solved: Timer not resetting
  139. link to multiple workbooks
  140. how to select Last cell in Multiple Selections
  141. Formula Returning Tree With Largest Profit
  142. Break a cell down using VBA
  143. Problem with Data labels
  144. Finding text within exe files
  145. Duplication with criteria
  146. Solved: Sort and copy to another sheet VBA?
  147. Display Date & Time on Excel UserForm
  148. please help needed using checkboxes & vba!!!
  149. Solved: List box selection
  150. vlookup (not exact match)
  151. Looping calculation
  152. Array for months of the calendar
  153. dissable my own msgbox
  154. Filter Sheet by two columns on two text box values
  155. Solved: Need to truncate Cell to keep it under 250 Character's
  156. How to default resized screen resolution
  157. send email and cc another person in range in html body
  158. Solved: I'm not understanding why these loops are working in the opposite direction
  159. CSV filter
  160. ComboBox/ListBox Help
  161. ClearContents of a range of cells in on sheets bar 5
  162. Chart Question
  163. Solved: Need to prevent save or close if msoShapeCross exists in specified sheet.
  164. Excel VBA file breaks between computers
  165. Solved: Join RecordSets
  166. Userform-Listbox, Copying and Pasting form one workbook to another
  167. insert text into textbox
  168. Note pad VBA
  169. MS Excel to MS Visio diagram
  170. How to delete the usual way
  171. Excel Functions Tutorial
  172. No simple way to refer the object we are dealing 'With' while dealing with?
  173. Merged Cells :(
  174. Solved: Mystery Sheet. Not Hidden, but I only can see it in VB Editor
  175. RecordSet Slows VBA
  176. Stuck with Afterupdate
  177. Distinguishing the tabs on a multipage in user form.
  178. filter pivot table with list box
  179. Copy first data row and last data row below the heading
  180. Solved: VBA special vlookup function
  181. Solved: VBA RIGHT CLICK MENU
  182. Filter excel table from listbox
  183. VBA Code assigned to CommandButton
  184. Extract UID value from text files
  185. Weekday function
  186. Text files to Excel Files
  187. Solved: Data Validation - ListBox to look at another worksheets criteria
  188. Solved: vba macro code help :(
  189. Move data over using vba
  190. Looking for a Macro to merge data from mult sheets to one
  191. Looking for a Macro to merge data from Mult Sheets to one (Alt. Post)
  192. Excel not updating
  193. Copy Visible Rows
  194. copy data from one worksheet to another
  195. Solved: message above vba code
  196. Solved: List Files in Directory that Match a File Extension
  197. excel database
  198. VBA Excel Margin Problem
  199. Retrieving specifc cell value for loop
  200. Formula to assign resources
  201. Excel & MS Query
  202. Get MSFLEXGRID tooltiptext property for VBA
  203. Define Column/Listbox
  204. Help with Network based Excel VBA ADO connection string
  205. order cells under corresponding column
  206. Solved: set excel 2007 as default
  207. VBA to remove a comma if it's the cells first characters
  208. Is there a home command?
  209. Can this macro be simplified?
  210. Solved: Sum an unordered group of rows by a common String
  211. Handling really big nos.
  212. Copy and Paste Problem
  213. Application.Ontime is LATE!
  214. Remove char(13) in a range
  215. Solved: If formula to match numbers +1 -3
  216. target.address help.
  217. VBA IE Javascript Radio Select
  218. Help Creating A Calculator
  219. Solved: VBA Importing a sheet from a closed excel workbook
  220. Help...Excel Macro...
  221. FSObject Create Folder not creating entire folder list
  222. Solved: BAT file
  223. Solved: sumproduct freezing the file
  224. Sub only works when stepping in to
  225. Solved: Macro addition
  226. Problems in Outlook.Application object in VBA
  227. Solved: Display text &amp; background color in sheet textbox (variable)
  228. Solved: Rename Folder - Error 75
  229. Solved: Bold Text From a Defined Word to End of Line
  230. Help With "Email Activesheet in Body of Mail Using Default Mailer"
  231. Class Module unhooked after Userform shown
  232. Loop not working
  233. Solved: Reset a cell value on a certain day of the month
  234. File with a lot of links
  235. Solved: Saving Sent Mail to an Alternate Folder
  236. Extend the code up to row 21
  237. Filling a Two Dimension Array
  238. how can i paste only value with this code?
  239. import data from password protected website into Excel worksheet
  240. Infinite loop for a simple high frequency trading algorithm
  241. vba macro code
  242. Year To Date Sales Compared to Last Year To Date
  243. listbox value from excel filter
  244. replace macro from list to another sheet
  245. Export Excel data to Word table
  246. Picture blinking (flashing)
  247. Solved: macro to update chart axis
  248. Out of memory / resource - XML import
  249. dynamically created array
  250. Extract data from pdf to excel