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