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

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