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