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