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. Solved: Lookup Intersection and copy column data into another sheet
  2. Populate combo box from selection of different combo box
  3. show popup of all sheet tabs
  4. Extracting data text and so on.
  5. Delete the row if cell contains null value else as it is ?
  6. Solved: Populating Combo Box With Values VBA
  7. Solved: Save Data Based on Vlookup
  8. [SLEEPER:] Compare two lists... and make changes
  9. Screen Flickers with screenupdating set to false
  10. Restricting access to a user to update a cell that is being updated by another user
  11. Solved: Userform Show/Hide Problem
  12. Solved: Date Picker default date
  13. Speeding up loop: deleting rows
  14. Solved: Extract Date
  15. Solved: Loop Through cells and sum
  16. Finding Holidays Formula
  17. [SOLVED:] Worksheet change event to populate timestamp
  18. Tabing issue in Combo box
  19. Solved: Formula Improvement - Hours * Rate
  20. Activate Method of Range Fails
  21. Solved: Looking up date and calculating monthly returns
  22. Solved: Counting based on 2 criteria
  23. Problem with SetFocus
  24. Execute diferent formula depending on cell value
  25. number format
  26. Help require in lookin for option button click event code.
  27. Solved: Setting default date in calendar
  28. Solved: Using A Date in DSum formula
  29. First Time VBA'(er?)
  30. Ticking Clock
  31. Solved: Select large array of non-contiguous ranges
  32. set cell value
  33. Solved: Pass an InputBox value into number of rows
  34. [SLEEPER:] Initialize cell with mmult formula
  35. Solved: BIN2HEX Worksheet Problem
  36. Problem when using OFFSET
  37. Can we compare the Excel columns alone
  38. Solved: move sheets from specific files each time a macro runs
  39. Solved: named ranges
  40. Copy Entire Row if Column Value is Negative
  41. change formulas to
  42. Compare cells and highlight on a result
  43. Excel 2007 Populate table with web query
  44. Accessing files on webpage
  45. help with re-calculating Excel UDF
  46. Automation of Data Transformation and Consolidation
  47. Solved: How did I screw up Johnske's routine to force macro enabling?
  48. txtDate
  49. Inserting a row and moving a particular cell down one row
  50. PIvot Tabel macro no longer works since upgrade to Excel 2007
  51. Solved: Add Text to Old Call/New Call
  52. auto create text
  53. Copying to next empty row
  54. Help RC FORMULA STYLE
  55. Solved: Select Case with > 1 Variable
  56. excel vba to autofit row after cell update
  57. Excel and Access
  58. Solved: If/then statment where "then" does multiple actions?
  59. [SOLVED:] Before print function
  60. qty breakdown for inventory
  61. Setting the value of a cell to the value of a variable
  62. using sumproduct or sumif
  63. How to randomly choose sample rows after using Autofilter??
  64. lines in a cell or dropdown to next cell
  65. Tooltip Variable Values Vanished from VBE!
  66. Solved: Read Only: Disable opening/or disable prompt-to-save-as?
  67. How to Fetch Web Data into Excle
  68. Solved: for loop
  69. Solved: Insert Formula by VBA method
  70. Closing Excel & Opening Access
  71. Solved: Combo Box question
  72. 2 dimensonial lookup formula not working
  73. Formula in VBA problem
  74. Solved: Passing Variables from Sheet Code to Module Code
  75. Conditional Formatting & Reading Fill Value
  76. Compting 99% of a col range while autofilter is on.
  77. activecell.value - change from sub
  78. Removing duplicates with a difference
  79. Solved: .AddItme help
  80. New to VBA
  81. Solved: Editing Cell Comments Via VBA
  82. Solved: populate text box from combo box via vlookup function
  83. Solved: Formula to capture cell's displayed value
  84. Solved: VBA HTML - how do I access this button?
  85. Solved: Cell Interior.ColorIndex Property Changing
  86. Simple find?
  87. highlighting over due dates
  88. Vlookup from two cells
  89. [SOLVED:] Need Help : VBA in EXCEL / (if possible in DIAdem software)
  90. Conditional selection in excel VBA?
  91. Print Multiple Pages from DropDown Box using Macros?
  92. Multicolumn ListBox - Moving item upwards
  93. Adding Comments to a Formula
  94. Using VBA to create WordArt
  95. Solved: Determining Type of Data in a Column
  96. Test 3 spots
  97. Help! Macro to copy worksheet from different templates
  98. Vlookup from autoupdating master
  99. Solved: Insert Row every nth row
  100. E-mail attachment with VBA from Excel
  101. Counting Forward x number of months from given date
  102. Intersect function to find matching row AND column?
  103. Solved: Excel: Sumproduct or Nested IF statement help
  104. Solved: Worksheet Protection except Specific Column
  105. Solved: Remove first word in a string
  106. return column of change
  107. Solved: pivot table problem
  108. Excel 2007 Legend Border
  109. Have worksheet refresh only for changes in certain cells
  110. .Find and Dates..
  111. auto conversion
  112. File Chooser Needed
  113. Copy row data another worksheet in columns
  114. Get data from protected file, changes required in existing code
  115. Button macro
  116. [SOLVED:] Subscript out of range' Error ...
  117. Lookup on two values and copy cells when match found
  118. Solved: Need errorhandling for "print sheet" buttons
  119. Why does the path appears in some function formulas but not in others?
  120. Creating a standard form
  121. Solved: OFFSET and MATCH formula not working
  122. Filter data
  123. 3D Chart
  124. append color text (VBA)
  125. Sleeper: Activecell.offset
  126. Solved: Problems with creating a shift-plan for a new year
  127. [SLEEPER:] Renaming not working correctly
  128. [SOLVED:] Auto Fill into Text Box / cell
  129. Need to know how to copy into next blank column
  130. Convert entity in excel
  131. Solved: Copying formula down used range
  132. Solved: Lookup Column A value and add Column X- then copy to other sheet
  133. Evaluating a string of an array
  134. Changing Colour Palette
  135. Solved: Resize autofilter
  136. Excel refresh page
  137. how to check if file is read only, but from other file
  138. Adding a,b,c letter to duplicates
  139. Verify that a Hyperlink successfully opened
  140. using wildcards in Formulas
  141. Find matching columns/cells and copying over data
  142. Passing data between a main code and an UserForm
  143. Folder Search File List
  144. Using if statements in PivotTable formulas
  145. Import range from closed excel file
  146. Solved: Search directory and return values
  147. ListBox Transfer Query
  148. Chart object fails
  149. Input Box/User Form
  150. Count Empty Range and MsgBox
  151. How to use ' to ignore large section of codes
  152. Format values copied and concatenated
  153. Run macro whenever you change sheets
  154. preserve regional settings when saving to xlTextPrinter
  155. Solved: intersection of named range and a column
  156. ODBC in VBA excel
  157. Solved: little sub that can MERGE
  158. how come temp files keep showing up
  159. Solved: Why is this not working?
  160. Solved: worksheet value change affecting 2 cells
  161. Solved: hiding Rows using index number
  162. Solved: Problem Launching Excel from Access with CreateObject
  163. Printing In Excel
  164. [SOLVED:] Delete Sheet In VBA Project Window
  165. Need comments
  166. Scrolling not working for TreeView
  167. Solved: Deleting Rows
  168. Solved: Inserting formulae into Used range
  169. Solved: locking VBA project
  170. ADO Version
  171. Pivot Table - Getting Correct Profit %
  172. Solved: (VBA) Recursively list files and output to csv
  173. referring to numbers/alphabets
  174. Solved: Timing a For Loop
  175. Using 'IsNumber' in a Select Case
  176. excel save as csv
  177. Sorting a table
  178. Absolute value
  179. Solved: Copy the text from WORD to EXCEL
  180. save sheets as new version: changes required in existing macro
  181. Pivot Table Stored Proc with Parameter
  182. Solved: Data Validation list based on a filtered list.
  183. Auto sort consolidation book
  184. Solved: Copy rows from one worksheet to another with some condition.
  185. Delete Row if Cell Contents = "ABC"
  186. Not able to access input boxes on a web page
  187. Solved: Error::Can'tDeclare Array as 'Public' ::What is Excel's Problem now?
  188. Hyperlink to Search Folder for a Number
  189. Solved: Instr & bold
  190. Referencing worksheet name using code name
  191. record and play macro to create commandbutton gives different results
  192. Switch off subtotal on pivot table
  193. Copy Paste of Filtered data with hidden columns
  194. Solved: Percentrank :CSE
  195. Delete Macro
  196. Trouble with pasting a formula
  197. Loop OK manually, but "freezes", when run with DDE update
  198. Solved: Macro won't run
  199. Copy & Pasting in VBA
  200. [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA?
  201. Placing data on a closed excel file in Sharepoint
  202. Checking each cell in a row
  203. Extract string within tags
  204. Update excel record to existing DBtable
  205. Solved: need help for ranking a list
  206. Solved: How to check if user has PI tag addin if not add it?
  207. How to update a list to fill combobox
  208. Do Update only Loop, NOT again from start Sub with DDE link
  209. Solved: can you get vba to declare variables based on an argument passed
  210. Solved: excel vba book recommendations
  211. Change sheet to PDF & Delete Sheet
  212. Solved: Creating a look-up and complete macro
  213. Solved: Repeating Rows at the BOTTOM
  214. Solved: Find last row and set range name programmatically
  215. Solved: VB control of IE Dialog box
  216. Help with For Loop Structure
  217. Click listbox and Show picture
  218. Wanted: Testing and feedback of Duplicate Master addin V2.0
  219. Solved: Forms with hyperlinks
  220. Solved: VBA coding help
  221. Open File for Output:: What if file does not exist?
  222. Having problems trapping error 76
  223. Solved: Dynamic Drop down list based on filtered list
  224. Solved: Find records and return values to new column
  225. manipulating Excel's "Normal" style
  226. Script out of range error
  227. Solved: recursive sheet deactivate event
  228. Listbox with zero entries
  229. [SOLVED:] VBA to convert .exe
  230. a word of thanks to all those that help in this forum
  231. How to show Detail Box
  232. Excel - WebBrowser Control - Vista/IE7
  233. [SLEEPER:] Detail MsgBox
  234. how to highlight the first value in a listbox
  235. Solved: convert number to text
  236. [SLEEPER:] verify text of IE
  237. Comparison on 2 sheets base on a unique name
  238. application defined error - VBA
  239. Solved: Create folders if don't exist
  240. open a new instance of Excel
  241. Userform On Website?
  242. fill column when a row criteria was satisfied
  243. Solved: Probably not the right tool but...can Excel..
  244. delete spaces
  245. suffix
  246. Solved: Using months and weeks in Lookup formulae
  247. Sleeper: Biffed something in the code...
  248. Solved: Private Sub Worksheet_Change(ByVal Target As range)
  249. vba validation list
  250. Outlook Manipulation via Excel VBA