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

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