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