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

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