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. Nested Collections
  2. Macro to copy paste data
  3. Solved: Iserror in VBA setup
  4. Inventory control
  5. Solved: Need Help with the Logic of my Program
  6. AutoCorrelation and Partial AutoCorrelation series Generation
  7. Load Excel Userform from Powerpoint Button
  8. [SOLVED:] Sorting a column alphabetically, however a blank row between names must be retained.
  9. Continual Import of Excel data into Sharepoint list
  10. Solved: Webbrowser page depending on listbox value
  11. Solved: how to reference previous cell value
  12. Need Help developing an Algorithm to Decode MathML (XML)
  13. Delete the duplicate value/cell in selected range
  14. Excel VBA recognizing the variable as Date wrong
  15. How to exclude hidden pivot field items in count
  16. Copying data from DB in a Sheet
  17. Change Array Arguments to read horizontal instead of vertical
  18. Count of rows excluding a set of values in the another sheet
  19. Solved: Conditional Formatting a worksheet based on value in a cell in another worksheet
  20. Excel Formula Help
  21. Pivot Chart and Table Problem
  22. Solved: Copy string to clipboard in VBA
  23. Sorting Collections
  24. Solved: Deleteing unused word bookmarks
  25. VBA to open Excel & Enable Macro
  26. Solved: User Form syntax
  27. Loop fifty files into one file
  28. Code to Filter, Copy, Paste and Save Data
  29. Excel Vba for Macros...
  30. Solved: sumproduct formula error
  31. Solved: IF Formula problems
  32. [SOLVED:] Excel VBA Open / Save As
  33. Solved: Copy selected cells in all worksheets and paste into another worksheet
  34. Solved: Deleting data within a named range (xl '97)
  35. Macros help
  36. Query-Style Custom Function needs speed boost!
  37. Strange combobox problem
  38. Solved: Assign Macro to Runtime-Generated Textbox Event
  39. Sorting then send
  40. Solved: How to open all files in folder using input box
  41. Solved: MS Excel: Password Problem
  42. Solved: Limit input to textbox
  43. Using FieldInfo with variable array content
  44. Solved: Explanation of Advanced Filter
  45. Selecting more than cell VBA
  46. Vlookup
  47. Solved: VBA code to periodically copy data
  48. Buttons to Start and Stop Macro
  49. Dynamic graph
  50. Solved: clear cells without form appearing
  51. Solved: Create a marco that will autofill a formula but the range is variable
  52. filter - hide active cell content
  53. Solved: Make chart where source data range is variable
  54. Chart Colouring Macros
  55. Solved: Find is not matching expected values
  56. Solved: Loop through user specified folder
  57. Solved: VBA lookup to insert value into cell.
  58. Solved: Excel equivalent to MS Word's DOCVARIABLE?
  59. [SOLVED:] Why do create a temporary variable and then set the value to a function?
  60. Solved: add to existing value by matching
  61. Vlookup the price in latest date
  62. Truncating cell data to fit in cell
  63. Solved: Custom Prompt box w/ multiple buttons
  64. Solved: Low inventory alert
  65. Solved: Invintory Project.
  66. Solved: Add opened file into a summary workbook
  67. Solved: Reduce size of current region
  68. Print PDF file
  69. Solved: When replacing a sheet, how to fix refs?
  70. Clearing and resetting CTRL+END
  71. Displaying text with freeze panes
  72. Chart source data depends on the sheets choosen on the Combo box
  73. Solved: Prompt comment?
  74. Solved: Change caption of a button on spreadsheet without selecting it
  75. Incremental Change in Values of Data Table
  76. Solved: Auto-repeating input error
  77. convert Exif photo data to excel
  78. ActiveSheet.Paste Error
  79. VBA to disable close
  80. VBA Compare Excel Files Macro
  81. Solved: Script to add values in new sheet without blank rows
  82. Solved: use GetOpenFilename with only few files displayed
  83. Solved: Find value and count occurances of text
  84. Solved: RANK (??)
  85. Recording web application using a macro?
  86. Solved: Find Empty Column Range
  87. Write to Output File w/out Overwriting Everytime?
  88. Solved: Add to comment?
  89. [SOLVED:] Automatic addition of comments to entire column
  90. [SOLVED:] Finding complicated average
  91. Advanced Find & Replace
  92. Solved: input box loop
  93. access invoice to excel combo box vba urgently need help
  94. Solved: extract values in a range
  95. Enum replacement for saving double datatype
  96. Macro to copy formulas across a worksheet
  97. insert image
  98. Date variables
  99. Using embedded pics
  100. Check if Column Exist & it in sequance
  101. VBA and XML::Conversion of Sorts
  102. Solved: open Excel filename with only certain characters
  103. Solved: Incorrect Date Brings Up MsgBox
  104. list names of all saved files
  105. Solved: Clear corresponding cells when changing one cell in a row
  106. Solved: Variables in message box
  107. Solved: Increase value of a Cell by 1
  108. Solved: password policy when opening an excel sheet
  109. [SOLVED:] Cannot select multiple cells at a time
  110. Call Sub when cell is double clicked
  111. Solved: Comparing Cells
  112. Solved: Sub to Go Back to Stored Range
  113. Solved: Summing of Totals
  114. Solved: Why doesn't this work?
  115. Solved: Partial file name
  116. Solved: Goto previous cell
  117. Solved: Clear shapes BUT save buttons
  118. auto serial number
  119. Solved: Disable subs depending on which button is pressed
  120. Solved: Format Date + 3 months
  121. Solved: Hyperlink activation of Script/Macro
  122. Solved: How to rename a worksheet if name already exists
  123. Cell References
  124. Workbook size
  125. Solved: Shapes & Values
  126. Auto increment number & Date Stamp
  127. Script to show up time zone in excel
  128. Syntax error
  129. Search list, find value and return binary value.
  130. Solved: VBA file names (and more) from folder on worksheet
  131. Problem with Contour Graphs
  132. Macro from Number to Letter
  133. VBA to download data from website
  134. Solved: Hyperlinks warning
  135. Arrange the values as per pre-defined orders
  136. Help with search form
  137. [SLEEPER:] Capture user data
  138. Iterating through a list of cells
  139. VBA sorting method
  140. Solved: How to Recognize this string properly?
  141. Solved: Lottery Checker
  142. Solved: Activate vba in another workbook
  143. Arraylist or something else help
  144. Solved: Lookup Value, Copy and Paste Row Values?!
  145. Type Mismatch error
  146. Shapes and values the sequel
  147. Solved: Checking to see if a cell contains a Number or Letter
  148. Sleeper: Problem with range selection
  149. Message box with options
  150. Solved: Close Excel Command Button
  151. Can Someone help with this For Loop?
  152. [SLEEPER:] Opening email with selected names and attachments
  153. How to get subtotal ignore subtotal which is netted in If()
  154. Solved: Is there a Function in Excel to Determine the Row Length?
  155. Solved: What am I doing Wrong in this simple Code?
  156. IE login and logout from Excel
  157. [SOLVED:] Type MisMatch!!
  158. Solved: date & time difference
  159. Solved: unprotect sections of word document with excel
  160. Solved: copy late items to new sheet
  161. Solved: I am the Worst:: Something is Terribly Wrong w/ My Code
  162. How to populate missing digits in a date cell or convert US to UK date format
  163. Need help for "Format" function
  164. Code update with the help of form
  165. Solved: Userform Pop-up when opening excel
  166. Solved: VBA Graph - Tweaks Needed to Amend Font and Placement?!! HELP!
  167. Quick Question ABout Setting a Range
  168. Solved: Case statement
  169. Solved: Problem With .pagesetup.printarea
  170. Progress Bar
  171. What am i Doing wrong
  172. Solved: The Trouble with For-Loops
  173. Warning message open file
  174. Solved: Number Based on Date
  175. Solved: ADO handling
  176. VBA CODE OLAP Pivot Table Excel 2007
  177. Solved: Date and Time Difference 2
  178. Solved: Data Validation Negitive
  179. Sleeper: Amend HTML file
  180. Solved: If 8th character ...then
  181. Solved: UF textbox 8th character
  182. Solved: Hyperlinks to Hidden Worksheets
  183. script to pull email information onto excel
  184. adding time 15min in a textbox
  185. If statement help
  186. how to set a value to an external cell ?
  187. create a list of numbers in a single cell
  188. Solved: Hide Row based on particular word
  189. code without select
  190. [SOLVED:] MS SQL OLEDB struggling
  191. Solved: Stored procedure w/ w/out parameters
  192. Need Assistance with Text Font Color Change
  193. hide columns depend on cell values
  194. Solved: Data population based on a field entry
  195. Solved: Using an If statement on change event procedure
  196. Solved: copy visible cells
  197. printing pdf's i open thru excel vba
  198. [SLEEPER:] Checkbox problem
  199. Solved: Infernal 4s
  200. Solved: Combo Chart creation
  201. Solved: Populate userform from selection of another userform
  202. Excel variable for path
  203. Need help with a multiple if statement on a change event procedure
  204. Emailing from Excel
  205. Solved: Forumla with defined sheet name in other cell
  206. Process all values in search area to retrieve all matches
  207. How to implement this effectively
  208. Solved: Using named range to plot chart data
  209. Solved: Compiler Directives (#Const, #If, etc.)
  210. Update links with all files closed
  211. [SOLVED:] Run-time error '-2147417848 (80010108)'
  212. How to load hyperlinks in userform listview
  213. Need help for Dynamic Data
  214. Solved: Reformatting a WorkSheet
  215. Solved: Find cell containing PART of string
  216. Something "Off" About my Code ??
  217. Balance two elements to a number
  218. Problem with Nested IF function
  219. Need formula to get that output
  220. Format textbox to numbers in Userform
  221. Solved: Formatting bookmarks
  222. Manipulate a string
  223. Solved: Deleteing Word Chart Rows if all cells are empty
  224. Stop FIND() errors - related to my late post
  225. Solved: Case Select
  226. Pivot table macro
  227. adding cell in excel vba
  228. Check if selections in listbox are contiguous
  229. Solved: Compare dates
  230. Consolidate Data from Mutiple Sheets in Summary
  231. How to check if file is open
  232. Solved: Calling Subs::Error "Compile Error: Expected Variable or Procedure, Not Module"
  233. Solved: select txtbox
  234. Solved: Cell Format being Weird
  235. Solved: match and return offset value in cell
  236. how do i sum a total of multiple numbers
  237. array in vba
  238. Insert/Delete Rows on 2 sheets simultaneously
  239. Solved: randomize rows in range
  240. Macro on Server
  241. Convert text to numbers
  242. Solved: Conditional Formating with multiple If statements and conditions
  243. Solved: Convert entire column from General to Text
  244. This Should be Easy::Event Handler Maybe?
  245. Seriously Excel? Change Row Colors
  246. Select folder and insert folder path into cell
  247. Solved: Drop Down Box Settings
  248. Send to DB code change
  249. combobox update
  250. Solved: Run Macro against a non-active sheet