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. Solved: Control Filter
  2. Code help
  3. Solved: vba autofilter
  4. Runtime Error 9
  5. Loopthroughsheets following code
  6. Extract to multiple text files
  7. Solved: PDF to Excel Data extract automatically
  8. Solved: Function to wait until a particular file exists
  9. Excel reversing cell value?
  10. Extract One column from multi-column array
  11. Solved: Pease help on CTRL-SHIFT ENTER on my VBA Formula
  12. convert xls to csv large number problems
  13. SpinButton
  14. Something weird with vba
  15. Solved: Get a line from a text file.
  16. Solved: Move numbers from DOC to XLS
  17. Solved: Find Duplicates
  18. Please help with my Pivot Table VBA Code.
  19. Solved: make certain cells visible
  20. Help regarding reminders about birthdays of employees in advance(2days)
  21. IF formula for identifying unique rows (quite confusing problem)
  22. Feedback form Help
  23. Excel save file - 2007
  24. Simple Copy and Paste Mystery
  25. VBA not working on both sheets
  26. Module to delete rows
  27. update data via listbox
  28. Conversion and Icons
  29. Solved: SpecialCells(xlCellTypeVisible) does not seem to work in range object
  30. Solved: Tabbing order
  31. passing FieldInfo value as a variable
  32. Solved: The magically disappering Excel Workbook.
  33. Using VLookup and Maximum statements or what will work
  34. Solved: Sumproduct - Summing
  35. Hiding Rows takes Time
  36. Solved: Removing a Item from Listbox.
  37. Self-saving workbook?
  38. Help with Create Hyperlinked List of Directory Contents
  39. VBA - Format with lanuage change
  40. Solved: Microsoft Internet Controls Library
  41. Help using Access as backend for Excel
  42. Solved: Copying an entire Letter from word document
  43. Solved: Formula to help identify specific words in titles?
  44. Solved: TIME DIFFERENCE FORMULA REQUIRED
  45. Solved: Help with value testing
  46. Solved: creating recap with macro
  47. Solved: countif - help required
  48. Printing daily log sheet with preprinted dates (solved)
  49. copy entire column and paste into another workbook
  50. Weird insert line problem...
  51. AUTOMATICALLY CLICK DEFAULT MESSAGE BOX
  52. Solved: Removing duplicates based on two columns
  53. Help with the Loop
  54. Help... What have I done !!
  55. Autofilter code not working
  56. Workbook Sequencing Only on Saves
  57. Solved: How to copy formatted number cells visible text?
  58. Solved: Sumproduct calculating total incorrectly due to date
  59. Searching within a pivot table
  60. Eventdriven XML Export
  61. need help with rounding formula
  62. Pointer to Workseet
  63. Solved: Form VBA
  64. Solved: Is there a way around using a tonn of ascii references......
  65. Operators in Arguments question
  66. Creat Pivot table by VBA
  67. Macro 4
  68. Loop through variables
  69. Solved: Search for cell values then sum scell to......
  70. Solved: parse and new column
  71. VBA code to enable autofilter on protected sheets
  72. Populate ListBox with Filtered Records
  73. Solved: lost vblf's
  74. Solved: Problem with date Picker Control
  75. Solved: Problem in Find & FindNext for a Function call
  76. Solved: copy worksheet to another workbook
  77. Code moves cells out of range
  78. Save to SharePoint Library w/meta
  79. Change 1 character in cell
  80. Solved: Call every X seconds
  81. Transpose or array?
  82. Change Customer ID
  83. Solved: syntax: shell
  84. ActiveX in Excel
  85. text box
  86. find and compare
  87. Solved: Command button colour change if file missing
  88. Solved: Active cell display
  89. Weird Type Mismatch Problem (Cell Formula vs. Cell Value)
  90. Runtime Error 1004 with working accross worksheets & string concatenation
  91. How To separate VBA application into file
  92. Get a Structure from a Pointer
  93. Button embedded in a chart, xl2007
  94. Solved: User defined function and copy paste
  95. Help with MsgBox Function
  96. What Does “Insert Names” Mean on the VBE Screen?
  97. Run a macro contained in an add-in using keyboard shorcuts?
  98. plotting a named range within a named range
  99. Solved: Find in 3 colums and list the result in a list box..
  100. Completely at a loss...
  101. Solved: combine from all sheets
  102. Problem with Excel - Access macro
  103. Solved: Cells showing as formulas...not results.
  104. Text to Columns Wizard - Way to save off positions?
  105. Solved: PRINT AREA VBA
  106. Animated Gif Help
  107. Solved: How to copy rows in different worksheets created on the fly
  108. Lock cell formatting but allow value input
  109. Solved: Remove All Comments
  110. Solved: multi columns selected
  111. Solved: Tracking changes with comments
  112. Macro to export cell values to Word
  113. Moving ExcelMacro to Access
  114. Get Data From Acess
  115. Solved: Cell reference in VB
  116. New landscape Word doc from Excel
  117. Open Publisher doc from Excel then edit
  118. Obtain version number of SharePoint document
  119. Solved: RecordSet and ListView
  120. Managing Duplicate Conditional Formatting Rules in Excel 2007
  121. Solved: Check 1st 4 chars & conditionally enter a string
  122. Scrolling issue, going too far
  123. Solved: vba to ID info in cells and find other cells with same info
  124. Pull data to new workbook with new sheet per workbook
  125. Search folder with a value in cell
  126. Button press effect in Excel Shape
  127. Solved: Seperate each recipient into own tab
  128. Solved: Excel match headers, append data
  129. Copy Folder to specified path...
  130. Automatic upload excelsheet (html) to web
  131. Solved: User Changeable File Paths
  132. Solved: Check if combo box is populated
  133. Solved: Limit character input in a textbox
  134. Solved: how can i change this code to identifiy the 2 digit no?
  135. comparision macro is very slow
  136. Solved: Problem with amended xld.sheetmanager code
  137. Solved: Deleting Rows based on criteria
  138. Solved: Buttons
  139. Solved: import empty column QueryTables thnks
  140. Solved: Condionally Formatting a Row Based on a Cell Condition
  141. Solved: Count unique entries that occur over consecutive dates
  142. Solved: Scrollbar
  143. Solved: Monthly to Quarterly Part 2
  144. Copy a table from an excel sheet to an Embedded Excel Chart Object's Sheet
  145. Runtime error '1004' Application-defined or object-defined error regarding if formula
  146. Solved: Can't get If,Or, to work
  147. Solved: Copying Named Ranges
  148. Solved: Changing time string?
  149. Solved: Adding a New Toolbar
  150. Solved: Formatting Dynamic Toolbar
  151. Solved: extend the border line
  152. How to acees server xml file
  153. Solved: Sum the distinct values under a specific criteria
  154. Solved: User Input With Options
  155. Library Not Registered error
  156. custom order?
  157. Copy Worksheets to a new Workbook
  158. Solved: faster way to delete row
  159. Save Data to a Closed Workbook.
  160. Solved: Cell value capture
  161. Getting Week Numbers to Display over Multiple Years without Resetting to 1
  162. Any of you guys familiar with web query...
  163. how to find last non empty cell in col and use it as input in a range
  164. Populate a field on a webpage and submit and record data
  165. Solved: Making CheckBox1 Selected By Default
  166. Preserving Objects and Collections
  167. Command Button Shrinkage
  168. Solved: VLOOKUP accross sheets
  169. Solved: Calling a Script From Another Module
  170. Changing CommandBars.Name
  171. VBA programming question on cell selection and optimization
  172. Help reg user form development
  173. Solved: Insert picture
  174. Interactive Drop Down List/file chooser
  175. Solved: If value found, copy range macro help!
  176. Solved: special sort
  177. Match columns linked to external workbook
  178. Solved: Colour change based on cell value
  179. Simple Copy and paste
  180. Using a click button to select data relating to checkboxes
  181. Sub routine isn't sending outlook message..
  182. Solved: Copy .txt file
  183. Solved: Sound alert
  184. VBA for batch upload
  185. Help with VBA code
  186. Solved: Error with Recorded Macro
  187. Solved: Time format in user form
  188. Solved: Format Chart Area
  189. I/O Excel to PicAxe Micro
  190. Solved: Looping through Worksheets and inserting a formula into a Range of Cells
  191. Solved: How do you create a quiz with microsoft excel 2007?
  192. How to escape characters in Microsoft Excel, such as an equals sign?
  193. Solved: Method "FileSearch" Problem
  194. Solved: Copy data from 1 workbook into another
  195. Solved: How to add new range in the VBA
  196. counting results from searchareas.
  197. Solved: Pulling Value Only (not equations)
  198. Macro To Merge Data from Different worksheets
  199. Solved: Please help tech wizards!
  200. Solved: listbox items as variables
  201. Solved: A list of distinct values
  202. Collection Class - Item Method
  203. Highlighting Duplicate numbers in excel only when they are next to each other
  204. Solved: OpenText Method: Excel remembers Last Import!
  205. Solved: Lookup Help
  206. Populate List Box in Excel with visible rows when worksheet gets filtered
  207. Solved: moving array to worksheet
  208. Solved: caclulating birthday in a userform
  209. Solved: Loop through a range and hide active Column
  210. help me plz
  211. Solved: Looping through autofilter, copy, paste
  212. How to improve the performance of this code
  213. Solved: Loop OpenText function
  214. Macro Help
  215. Excel wants to talk to Access
  216. Entering Selected Cell Values in Multiple Textboxes
  217. Solved: Change code to choose .txt file already open
  218. Checking existence of a text in SQL database table column.
  219. Paste Data From Excel To Access
  220. Solved: Is there a shortcut for this code?
  221. Solved: Remove last 4 rows from a listbox...
  222. Can't Exit Design Mode because 'ControlCommandButton1' cannot be created?
  223. Solved: Convert to Propercase Selectively
  224. Move multiple sheets from multiple files
  225. Creating dynamic Range for combobox
  226. Solved: VBA Web Query to google finance/reuters
  227. FORMULA FOR REPORT IN EXCEL
  228. From Excel to XML via VBA
  229. Solved: Test for Existence of Toolbar
  230. Using VBA to move the mouse to a specific coordinate and left click?
  231. Solved: Add ListBox item if item exist just once...
  232. Solved: Disjointed Information to Table (Solved)
  233. Solved: copy defined rows
  234. Solved: Clicking CANCEL After Executing a Command
  235. Making graphs in loop
  236. WebBrowser Control with Animated Gif
  237. Transfering data from UserForm to specific cell
  238. How do I put Msgbox in between formulas in VBA?
  239. Open a workbook with a long file path
  240. Copying to multiple workbook coding..
  241. Solved: Extract distinct list from a range
  242. Solved: Scanning Program that converts document to excel
  243. Sub Returning Workbook
  244. Help with Variables in Ranges
  245. Unloading User Forms
  246. copy selected cell with links
  247. How do you create a VBA formula code based on Filename?
  248. Group Variables together
  249. Solved: Help with Objects in a Collection
  250. Solved: Prevent Function calls in worksheet when running macro