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. Change cell color from user form
  2. Solved: Clearing Pivot Cache
  3. Solved: Worksheet_Change with 2 requirements
  4. How to LinkColumn of a Saved Workbook
  5. Command Bttn import .csv file to new worksheet
  6. Two questions: Long and Dim
  7. Pasting a selection of data
  8. Solved: Solved:
  9. Get current keyboard layout with VBA
  10. Need help in creating complex macro.
  11. Solved: Conditional formatting query
  12. Solved: Change a Picture or Object Color using cell values
  13. Importing From txt File
  14. checking that a user entered decimal number in textbox is only upto 4 decimal places
  15. Creating a Login Form
  16. Application.EnableEvents problem
  17. close Wbk-a and open Wbk-b
  18. Lookup data from many sheet and Skip blank
  19. Solved: Convert Date
  20. Force Macro + Other Applications
  21. Solved: MATCHROW = 0 > HIGLIGHT
  22. add alert to txt if criteria met
  23. [SOLVED] Grid combination logic problem
  24. Macro To Add Grades Into System
  25. How do you make a clickable button without creating a form?
  26. Sync Pivot Tables
  27. Amend Macro Store Info In Different Places
  28. need a save as text macro with delimiter
  29. Solved: match / lookup to code table on different sheet
  30. Filling a range of cells using a VBA function
  31. Solved: Getting data from other sheet with if statement and somprodukt
  32. Solved: *Automatically Unprotect & Protect sheet - Macro command button
  33. Solved: Apply code only to column A
  34. Debugging - Show workbook if code running on memory?
  35. Replace and sort macro
  36. Run a macro on a different wbk
  37. Solved: Automatically import a .bas module
  38. email results
  39. Solved: Collates data from many sheets to Master sheet
  40. Little Regex Problem
  41. Solved: Help: Run-time error '1004': Application-defined or object defined error
  42. Creating a folder with cell contents
  43. If statement logic question
  44. Solved: Loop that works on all sheets in workbook
  45. Moving range to onther sheetbase on cell value
  46. how came wb close by module showing in VBAProject window?
  47. Solved: updating data from another workbook
  48. Listbox selection criteria report
  49. Solved: Displaying - 0 - while using VBA
  50. Automatically move cursor if value exist
  51. Exclude Sat & Sun while calcualting due date
  52. Solved: Resizing Array
  53. Not able to access elements from a webpage
  54. How to compare two sheets
  55. Set Formula and Notify if changed
  56. [SOLVED] VB Code to Copy a table and place it in an email.
  57. Text Import Code crashes at same record
  58. Getting data from different sheet and sort and sum
  59. Solved: If statement based on active worksheet Index Name
  60. Solved: Listbox+rangecopy+concatenate
  61. Copy Prices (with conditions - VBA) from one workbook to another
  62. Solved: Vlookup with an Index & Match formula
  63. Solved: Getting External Data From Web
  64. Help with Solver in VBA (range related)
  65. Reading a text file
  66. Need Help in creating a movie list catalogue
  67. Disable Cut, Copy, Paste Request
  68. Excel 2007 - Can vba display the MenuFloaties mini toolbar?
  69. Solved: Arrange sheet by name in between other sheets
  70. [SOLVED] Topic - Help Debugging Code : Placing a range in the body of an email.
  71. User Form
  72. Search data and return latest status based on date & time
  73. Solved: cancel ESC key
  74. File Size comparison by VBA
  75. Solved: Button to Copy & Move to another sheet ERROR
  76. Putting selected cells data into one cell
  77. Clean up Sort
  78. Automatic Creation of combobox
  79. How can we update the date in a cell when we modify a text cell?
  80. How to get help quickly - and keep getting it.
  81. Solved: New Excel files based on Cell values
  82. Rearrange Excel Sheet to uploadable File for SQL Server
  83. Solved: Merge data as value without formatting
  84. Delete data from Pivot Table
  85. Solved: Conditional Output to Pre-Formatted Worksheet
  86. pull letter above after subtotal
  87. User Defined Function - Mtwo = 2X
  88. Solved: Need to count rows in the copied range, or rows in the clipborad
  89. Small problems with generating a Bubble Chart in VBA
  90. Workbook Open/Before Close events
  91. Solved: Formula for count by day and hour
  92. Solved: Need to limit choices for the save as name.
  93. Solved: Excel2007 .RemoveDuplicates
  94. looping results
  95. Deducting amount of time (hrs) from a date and time stamp (dd:mm:yy hh:mm:ss)
  96. User Defined Function - Payment(mode, price)
  97. Solved: Create a sound
  98. VBA Lookup Errors
  99. Macro Slows with the same data...
  100. Why does my code not work Internet Explorer
  101. Run-time error 1004 trying to select cells
  102. Copy/Paste Macro issue
  103. Solved: Calling a function from a worksheet formula
  104. Solved: How to combined Modul
  105. HELP needed with VBA MMULT
  106. driving hours
  107. Solved: prevent textbox selection without disabling it
  108. Solved: Someone hide the codes?
  109. Solved: Test Large Change
  110. Store data and put them on a new sheet?
  111. Help to modify code
  112. Delete everything on sheet except?
  113. Solved: How do you set up this simple array?
  114. copy worksheet and values
  115. Solved: Radio button is not working - variable not defined
  116. Solved: After filtering row16 down, fill row10 with top visible row. If no results do nothing
  117. Lost Shortcut functionality
  118. Frame visible properties
  119. Columns in ListView
  120. Find Data in a table and enter =now into a certain cell
  121. Solved: Alternate for INDEX/MATCH
  122. Setting ws name
  123. Looping through a bunch of text files
  124. Change Graph data range
  125. Open internet at workbook open
  126. Need help with modifying this array
  127. Easiest way to write greater or less than?
  128. If / Instr command to change variable
  129. Solved: Modify code to close workbook if opened on wrong computer
  130. MsgBox - Displaying two values
  131. Solved: Show date and time in a message box
  132. Search for blank cell based on two conditions
  133. Solved: Need to set textbox to the width between Column 1 and column 24
  134. Protecting Excel Workbook
  135. Solved: passing an array to a class
  136. Save as Macro
  137. Solved: COUNTIF using multiple criteria
  138. Solved: if user keys a specific word in cell
  139. Solved: Dump Call Stack
  140. Solved: Creating a textbox in each cell of the active row range Column 1 to 24
  141. Solved: Selection Change Event only if Row Selected Changes.
  142. Solved: What code lanuages does Excel 2010 understand?
  143. Solved: Permission Denied renaming Textbox if name in the thousand's in 2003 - ok in 2007
  144. vba I/O text
  145. Solved: skip value with error
  146. Solved: Copy and rename sheet in different name
  147. Solved: custom class - multiple values for an attribute
  148. Help in combining multiple spreadsheets
  149. Solved: Select a Sheet in another Workbook
  150. Custom Formatting For Two Numbers in a Column
  151. How to find 2 reference point and grab info where they intersect
  152. Connecting to Oracle Database
  153. VBA for Highlighting
  154. Gmail Macro
  155. Mathematical Calculation "at which point - specific percentage could be achieved"
  156. Need empty recordset for almost complete code
  157. Rearrange columns
  158. XML help needed
  159. Solved: Error Handling Help
  160. Sum text after grouping
  161. Extend the msgbox wider?
  162. Custom sort modification
  163. Solved: do...loop statement
  164. Application.onkey
  165. Copy Two Columns into one column
  166. Solved: Finding and manipulating cell ranges
  167. Solved: select folder bij list
  168. Solved: Chart Macro
  169. Disable print button in worksheet command bar - Excel 2007
  170. Solved: Link button to PayPal
  171. Copy & paste
  172. Solved: set printer to 2 copies automatically
  173. Excel Reverting to all values
  174. Solved: Help with formula to divide number into 4 cells
  175. Solved: Ontime event
  176. Solved: Set all sheets to pagebreak preview.
  177. multiple ranges to if statement
  178. kill wkb & close excel
  179. Monitor cell for change
  180. Module class and form Listed in VBA without folders
  181. Randomly Generate text in cells from a combined range of cells
  182. Solved: Macro Tweak
  183. Solved: VLookup Code Error in form - Runtime Error 1004
  184. Solved: Tweak Macro Not To Eliminate Numbers
  185. Drag & Drop?
  186. Solved: Clear sheet only if File is selected
  187. Solved: SPECIAL NUMBERING
  188. Text String Joiner Macro
  189. Solved: Flashing text
  190. Solved: space bar
  191. Vlookup for multiple instances
  192. Solved: SUMIF not working =:(
  193. Solved: If file is open, can the Thisworkbook open event save a copy and leave it open?
  194. How to Populate Userform Labels from a Range
  195. Solved: VBA to Save PowerPoint
  196. SelectionChange Select Current Row of Range and Lock
  197. How to get rid of these dead macros?
  198. Detect Conditional Compilation Setting via code
  199. click paypal button
  200. odd or even
  201. Unhide column without selecting sheet
  202. Solved: Search for date in range and return cell address
  203. Practice Problems
  204. Solved: When closing Workbook repeated message "Do you want to save?"
  205. print files form dialog
  206. visual Queue in excel
  207. Solved: Screen / Worksheet Refresh
  208. index match help
  209. Solved: IF...ELSE...THEN LOOP HELP Please Help!
  210. Solved: One Script for Multiple Worksheets
  211. Solved: Insert year into cell
  212. Is Late-binding possible in VBA?
  213. Solved: Conditionally moving cell contents
  214. VBA application terminates when Control events are added programaticly
  215. help understanding code
  216. Forex Rates from a Java Applet
  217. Solved: dynamic list
  218. msgBox to naming folder
  219. Link Cell to MS Project % Complete
  220. Pause blinking caption
  221. Updating Inventory
  222. Edit Feature in Userform
  223. Radio button, activate, highlight cells?
  224. Accessing Outlook Contacts / Categories
  225. Make a button transparent?
  226. Solved: Flash Border Line
  227. Solved: Radio button is not working.
  228. Automated Functions
  229. connect Excel to AS/400
  230. moving sheets
  231. How to get out of 'Excel is waiting for another appplication...'
  232. Have sound embedded in VBA file?
  233. Solved: Clearcontents in a row
  234. Solved: Activate Macro When Sheet is Opened?
  235. How to hide a Button
  236. Solved: If Then Statement
  237. Solved: Boolean Working?
  238. Copy/paste a local file into PowerPoint
  239. Solved: Is the coordinate system inside a chart area different than outside.
  240. multiple form
  241. Right-Click on Toolbar button
  242. add a condition
  243. combining vlookup & hlookup
  244. Using an IF statement with multiples
  245. Return Value with color
  246. Solved: A code to write TXT file
  247. an active sheet save as copy
  248. Merge workbook to single workbook
  249. Solved: Error Handler
  250. Dual Monitor Setting in VBA