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. Sorting, even-odd
  2. Can a command button pass variables to a program?
  3. Understand code
  4. Error on copy and paste to powerpoint
  5. Need help to create an Excel Function
  6. Solved: Selecting Noncontiguous Cells
  7. Solved: Force lower case
  8. Sum $ within a cell
  9. Solved: conditions for multiplecomboboxes
  10. Solved: Problem when Excel function RAND() is triggered by a macro
  11. Return email from textbox
  12. Calculating Working hours in a Week
  13. Solved: Excel VBA - Linkg a TextBox to a TXT File
  14. How to name a chart that is not a chart sheet?
  15. Go to top of sheet
  16. Menus in foreign language versions
  17. Solved: count a specific text value in a column
  18. Solved: Ending Macro
  19. VBA HELP
  20. Fill row to coulmn
  21. Macro to remove duplicates
  22. What are the Units for width and height for charts to powerpoint
  23. My scripts are stored in different modules
  24. Solved: Copy and paste only visible characters
  25. Highlighting max numbers
  26. Solved: Msgbox for if beginning letter of word a "M"
  27. Workbooks comparison
  28. Solved: PageSetup
  29. Print Macro
  30. Solved: infinite paste!!!!
  31. Automatically defining cell background color via system date
  32. To Access and Back
  33. Converting number stored as text VBA problem
  34. Solved: Sendmail bugging
  35. 2 Date Time Difference
  36. excel 2007 patch?
  37. Solved: Runtime Error '-2147352000b)': Specified dimension not valid for current chart type
  38. Need a code replies to an outlook message
  39. Solved: Default rgb for buttons
  40. Solved: Active cell color change
  41. Solved: Exporting text of cell into input box
  42. Function parameters won't work correctly
  43. Check Column w Criteria
  44. Cell to Cell comparison and color coding
  45. Solved: Trimming multiple blanks
  46. Solved: Open URL that includes string picked up from cell
  47. Check an ActiveX control is installed
  48. Solved: EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditions
  49. Macro to select unknown, named table
  50. Custom Msgbox
  51. How to embed mp3 in excel sheet?
  52. help
  53. Solved: Breaking out of Loop with Keyboard
  54. 64 bit version
  55. How to get the value of a checkbox when...
  56. Solved: Find files in folder that have not been saved in x days
  57. Find - Copy - and Paste
  58. custom sorting a group of data
  59. Pivot Table
  60. Hightlighting duplicates by comparing multiple columns
  61. Solved: For Each Loop Only Loops Once...
  62. calc sales within x-mile radius using trig function - lat and long
  63. Data from Access through network
  64. Lookup values AND Subtotal
  65. Simple Floating Toolbar
  66. Get folder names in different columns excel
  67. Solved: Build table in 2010
  68. Form Control - Checkbox - Background changes colour when clicked
  69. Solved: Another 2010 problem
  70. Solved: Determine previous quarters from today
  71. Determine if folder is Recycle Bin
  72. Updating Access From Excel VBA
  73. Excessively slow script (Update wanted)
  74. Prevent duplicate but for one cell only
  75. Solved: populate column with array values
  76. Create a Macro to add to an existing Macro
  77. Solved: Link text box to a file size ?
  78. How convert this code to a macro?
  79. Solved: File name compiling via Userform data help!
  80. rotate label from user form
  81. Solved: Close a UserForm and open another
  82. How can I make a PasteSpecial from Excel to Outlook?
  83. Multiple Column Validation List
  84. Solved: assigning a formula to a cell
  85. Can I enter a value in the prompt of a password-protected workbook?
  86. Searching entire phrases for one or two words that contain many words
  87. Solved: Complex code needed (Seperate words)
  88. use VBA to capture screenshot of a form
  89. Solved: Delete duplicates
  90. VBA Change the Default SaveAs Location?
  91. Directly Access Streaming Live Data
  92. Prevent Size Increase With Formulas
  93. Lookup vba
  94. Solved: Calendar Control 11 - Open on today
  95. PRECEDENTS property not working in a UDF
  96. Solved: Webbrowser Frames
  97. selected cells in yellow
  98. Paste Values
  99. Grouped Controls
  100. Problems in looping through charts
  101. ChartType property changes for no reason
  102. Open Office excel issue
  103. How to format a part of the imported table from Web
  104. Project - Build Football (Soccer) Results, Table and Stats spreadsheet
  105. Importing Pictures
  106. Solved: trying to copy and paste too much data!
  107. Importing Pictures
  108. Sum up formula
  109. Excel Userform that is published in Word
  110. Solved: Disabling Worksheet Change while macro is running
  111. Help update code
  112. Conditional Formatting on computed field
  113. Appending Multiple Workbooks to Master Workbook
  114. saved colour
  115. PDF multiple sheets
  116. copy date to another workbook's month tab and day cell
  117. Solved: comparing ranges
  118. Rowsource for a combo box
  119. Macro that compares directory contents to...
  120. The triple loop....
  121. Solved: Create a .txt file
  122. Solved: Open file .xls or .xlsm, or xlsm
  123. Run Macro From User Form
  124. run time error 438, but method DOES exist!!!!
  125. How to search within a text box?
  126. Help Needed (LookUp or Match)
  127. Solved: delete sheets between two dummy sheets vba
  128. How can VBA recognize the contents of an HTML <a href> tag?
  129. Counting data in 2 dimentional tables
  130. VBA code for pivot table
  131. Listbox Values from VBA, not from worksheet
  132. Solved: Eliminating a Line or cell from code
  133. Drag&Drop CSV onto Image Control
  134. Solved: Creat Macro
  135. Verifying "free text"
  136. Active cell font color change
  137. Solved: Check if file is Open ?
  138. Looking for a solution.
  139. Add cells until adjacent cell is not blank
  140. Call Method Remove Duplicates from VBA
  141. Input Box Help
  142. Dates and Times in an Array
  143. Why cant i get the contents of the title tag ?
  144. Copying and pasting from multiple workbooks
  145. Using Userform Input to Run a certain command
  146. For each worksheet in active workbook, the name will be shown on ...
  147. Delete files from a list in excel
  148. Moving pictures 2003 vs 2007
  149. Add new row,copy only formulas&formats, when reached last used row
  150. prevent multiple instances of excel
  151. Does anyone use a digital pen with Excel?
  152. Solved: Always open in new excel
  153. Solved: Find unique records
  154. check if in wkbk1 then delete in wkbk2 if 5 fields match
  155. exclude some worksheets according to a list of the name of worksheet
  156. Validation list from multiple dynamic ranges
  157. Solved: Multi-page Form
  158. Compare 2 workbooks and delete duplicates
  159. Index and Match across multiple work sheets.
  160. Solved: paste to offset cell not working
  161. Reading values from different excel files
  162. GetObject to open Word File
  163. Object Variable Not Set
  164. macro one sheet to multiple-need adjustment w/ input boxes
  165. Copy textbox from Excel to Powerpoint
  166. Solved: 2010 application.filesearch
  167. Need to copy data excel
  168. Need Macro Unique based Max and Min time
  169. Create a Access table using Excel
  170. Solved: changing lines that transfer
  171. Solved: How to custom format my cell so that decimal my 0s appear
  172. Solved: How to populate a column up until the next column is populated
  173. Solved: Autofilter in reverse
  174. VBA for Latitude and Longitude from 5 digit Postal Code
  175. How to stop date format changing when copied by macro to new file
  176. comparing to excel files
  177. Need help with Auto Comment macro
  178. Opening multiple excel instances
  179. personal.xlsb
  180. Solved: Micrsoft office excel is wating for another application to complete an OLE action
  181. How to pass a normal datatype argument to an array parameter?
  182. Solved: Copying values into range
  183. Solved: New to VBA, a simple question
  184. formula to macro
  185. auto sum data above
  186. Compare two sheets
  187. Multiple search parameter boxes
  188. Solved: Removing duplicates
  189. Solved: Conditional Worksheet Column Comparison and Text Insert
  190. Trouble with Range objects in For Each...Next loops
  191. problem in copy and pasting data due to column limit
  192. Trying to "Line up" rows across sheets.
  193. Macro Optimization
  194. Find Function
  195. Solved: custom format Required in a cell by code
  196. Solved: Need help with combining 2 VBA Worksheet_Change Codes
  197. Calculation based on cell reference
  198. Solved: Shorten code
  199. exporting to csv
  200. Solved: Macro for write value without duplicate
  201. Excel Add-inn Password Recover/Remover
  202. copy workbooks to different folder
  203. Copy from above cell
  204. Search for Certain Part of String
  205. Call a sub from another open workbook
  206. Solved: VBA Move Files to Sub Folder
  207. Solved: Sort Help VBA
  208. IF and Offset Macro
  209. need sort data
  210. simple problem
  211. Solved: filter by month
  212. Conditional Formatting using VBA
  213. Acomplex export from Excel to Powerpoint
  214. Change value of Cell to the integer in VBA
  215. Solved: Assigning formula to cell glitch?
  216. Anyone In Auckland?
  217. Funky Character in CVS - Text To Columns
  218. Need help on Sumif formula
  219. Conditional macros
  220. Calendar without add-ins
  221. input the names of all MS Word file in an Excel file.
  222. CommandBarControl error
  223. Solved: part of Dir string vba
  224. need help writing a program...
  225. Solved: force a refresh to workbook shared on network
  226. takefocusonclick checkbox
  227. Alternative of .SearchSubFolders = False for 2010
  228. Looping through commands
  229. Solved: open macro security setting dialogue box
  230. Solved: Copy unknown range size
  231. How to apply Average formula with multiple criterias
  232. Stable progress bar
  233. Function as Argument
  234. Code interrupted after running another workbook
  235. type mismatch on application.run
  236. how to sum based on data in corresponding rows
  237. Solved: Calculation with an asterisk
  238. Solved: Chart Creation
  239. Solved: formula problem, nested if
  240. How to display values in excel sheet from vba Form.
  241. List out all possible combination in the sheet
  242. Selecting Rows with More than one Constant
  243. application.match type mismatch
  244. Users Help
  245. Solved: Sort will not work ...
  246. Excel VBA controlling IE confirmation popup box
  247. print rows 2,3, as headers on page if multiple pages
  248. hide the row if the row has nothing or more than 1 cell has things
  249. help with html extraction
  250. Solved: activx component cant create object excel 2007