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