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

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