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

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