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: Insert A Row
  2. Problems with Worksheet_SelectionChange
  3. Date array function has type mismatch error
  4. Help inserting a new row into several worksheets and copy formula
  5. Counting entries between dates using sumproduct?
  6. Solved: Need a msgbox to report to me the missing record number
  7. How to get variables numbers from array of numbers
  8. Validaing Userform Input
  9. Solved: How can I prevent Button Double clicks?
  10. Searching a keyword in a pdf file from excel using vba
  11. save a single sheet filedialogbox
  12. URGENT HELP REQUIRED
  13. Check shared file open.
  14. Text file read/write.
  15. Solved: Import text from Excel to a PDF file
  16. Displaying Total CMD Button
  17. VBA Macro to split cells at every ";"
  18. Remove hundreds of empty rows
  19. Solved: Copy Tab from close workbook into an open workbook
  20. To consolidate master data from different worksheets
  21. Populating Combobox list from listbox entries
  22. Creating a folder in the drive
  23. unzipped worksheet - protection
  24. Creating Charts using VBA
  25. Store selected ranges address in sheet
  26. Nesting Complex IF Statements
  27. Solved: Comparing two sheets. - I've seen code here before that I like, but I can't find
  28. Run sub when sheet is activated
  29. Excel data table filtering - need help
  30. Excel UK Developers Conference 2012
  31. NUMBER ARRANGER
  32. Solved: Comment filling
  33. Solved: UserForm - Need Help!
  34. multiple target address
  35. Validate Email in a Excel Cell
  36. Load | Delimited file into Sheet3 of the excel workbook
  37. Solved: Apply Row 16 cell formats to all rows
  38. Quick Case Statement
  39. Sleeper: Auto Update VBA Project
  40. Solved: keybd_event API missing information on User Form
  41. Little help with Visual Basics
  42. Can anyone crack this file?
  43. Cut cells and move
  44. application.undo
  45. Euro Sign wont work
  46. match data and return datalength
  47. My VBA code takes 4 hours to run
  48. Excel VBA Shopping Cart
  49. find last used row but not include formula that returns blank
  50. errror message
  51. VBA Coding window highlights text red and then deletes
  52. Forgot on Solved: Insert A Row
  53. "countif" in multiple worksheets using VBA
  54. Solved: Paste data with adding spaces between letters
  55. Unload UserForm resets project
  56. Solved: find string in column A and past used range of row to sheet 2
  57. Checking Columns for Numbers
  58. concatenate a range of cells with header values
  59. Solved: Looping around a userform textbox
  60. Pass TextBox Value to Access Query
  61. [SOLVED:] Can I create an Array from 1 to AutoFilter.Range.Columns.Count
  62. Looking up Records
  63. Solved: Help to include network drive when browsing for file location
  64. Concatenate Multiple Rows
  65. Solved: Fill Blank Cells with Value to the Left
  66. Formatting dates
  67. Cells with values
  68. Solved: string split for date
  69. Looking for functions: IsUserPressingAMouseButton / IsUserPressingAKey
  70. Solved: Reduce Numbers Down To A Specific Value
  71. how to store arbitrary selection area to two-dim array
  72. Error Box help
  73. Solved: Writ data to Excel problem
  74. Solved: Code stops?
  75. URGENT: APPEND DATA
  76. Find all occurance of cell value from another work book
  77. Sheet/Tab Copy Limit?
  78. pulling data from different reports into master workbook
  79. Solved: Print Selected Cells to Another Cell
  80. Compare 2 Columns of Excel Sheet
  81. Have txtBox search results populated in listbox
  82. Solved: Occasional filter\sort on worksheet_change glitch
  83. Is this possible with VBA?
  84. Solved: Select File from Form
  85. [SOLVED:] inputbox cancel
  86. Solved: Find & Replace Letter At End Of Number Only
  87. Problem on closing userform with API handles
  88. Solved: insert space in a string after n characters
  89. Solved: combobox1.value (as YYYY) - 1
  90. Solved: Dynamic Range based on Heading
  91. [SOLVED:] Code to edit data and to save as a text file.
  92. Volatile Functions and closed workbooks.
  93. Search
  94. workbook link ref cell
  95. Clicking on a Chart Point
  96. Internet Form with Dropdown List using Java/Ajax
  97. Pivot table with data validation reference
  98. Hidden game?
  99. Solved: Combine VB Code
  100. copy a color of font and cell of conditionally fomatted cell
  101. save a workbook and giving it an initial file name based on a cell value
  102. First and Last Bit of GetAsyncKeyState
  103. Hide empty rows
  104. Solved: Selection.Find error
  105. Excel Java and HTML :x
  106. Solved: Networkdays #name? error
  107. Solved: Insert Value of Selected cells to another Cells
  108. Solved: Splash Screen UserForm time delay and dll issues?!
  109. Importing a defined range from another sheet and then grouping/Sorting
  110. Code to Determine The Largest Number From Different Groups of Numbers
  111. Charting from Range assigned using Cells method!?
  112. Basic Arithmetic doesn't work?!
  113. Get Workbook Index from VBA
  114. Pasting a range of cells in Sheet Header
  115. Solved: Problem Moving Data
  116. Run-time error '1004'
  117. Solved: Step on through the code
  118. Inserting a new Column in Pivot Table
  119. Solved: Workbook_BeforeClose
  120. How to delete columns using VBA excel?
  121. Solved: WORKDAY in cell returning wrong Workday?
  122. Solved: Searching for a Value and Highlighting if Found
  123. VBA Excel Chart to PowerPoint
  124. Input box size
  125. Help needed to create a function or vba code for this process
  126. How to Create several buttons dynamically in my own Ms-Excel Plugin DYnamically
  127. Create a moveable button in own MS-EXCEL PLUGIN
  128. Solved: Application OK only in Excel 2000 or earlier
  129. Find and Replace help
  130. Problem with too many identical loops
  131. VBA code to close html confirm window.
  132. Need VBA code to click HTML image button.
  133. How to compare (neighbor) cells within a range object?
  134. How to get the real character when ? is displayed
  135. Find my String in an Array?
  136. Solved: Go back to the cell where you started a macro
  137. VBA Coding extension
  138. Solved: Assistance Modifying Array
  139. Restricting data entry in a table, one row at a time
  140. Macro to Copy from one Workbook to Another
  141. grouping function
  142. Is it possible to use formulas instead of pivot tables to call data from a worksheet?
  143. Solved: underline non duplicated values from 2 columns
  144. Variables Holding Wrong Data
  145. Random NUMBER
  146. Auto Adjust Range on a graph? Help
  147. Solved: Insert columns based on a variable
  148. Solved: macro doesn't work
  149. Solved: Copy Worksheet to new Workbook
  150. Copy each advance filtered data (filter by date 1 to 31) to new sheet
  151. How to change the words size in Excel/VBA Help Window, not in Excel window?
  152. How to read values from a dynamic form with dynamic text box names?
  153. [SOLVED:] Code Running Sequentially
  154. How do you incorporate vba code for excel into vba code for access 2010?
  155. Solved: VBA to count number of Cells with Data and write to a text File
  156. call web service via https
  157. [SOLVED:] Set Print Area conditional
  158. Error: Method or data member not found
  159. Solved: Looping based on a condition
  160. Solved: to rename and create new folder..
  161. Filling down a formula
  162. [SOLVED:] Covert text to date
  163. Excel VBA/Formula Selective Count
  164. Delete visible sheets except sheet1
  165. Looping through and finding average of data
  166. Solved: Combine coloured sheets from files
  167. Function LEFT / RIGHT
  168. Change cell rule from list to ranged cell automatically
  169. VBA to cut & paste
  170. Solved: Add new record of data to existing worksheet
  171. Solved: cell activate
  172. Mac EXCEL 2011 VBA
  173. Selecting items in already existing Combo Boxes (Drop down list)
  174. Sort Before Graphing
  175. Solved: Finding a string in Excel
  176. Import file to update
  177. control internet explorer popup window from excel
  178. Solved: Create a .txt file from a range of selected cells
  179. Solved: Listbox Index - Number format
  180. Solved: How to make an existing VBA Macro Globally Accessible or Public
  181. VBA to Email Range in body and attach sheets concurrently
  182. Adding Macros te Template
  183. Single value criterion
  184. Google Maps Driving Times - Stopped working
  185. Solved: Summing a dynamic range
  186. Solved: copy from excel to word
  187. macros
  188. Solved: Limiting scroll area is preventing me from clicking any row buttons
  189. Counting number
  190. Extract data in filter format from CSV file
  191. Solved: Problem with Email attachment
  192. IE Temp & memory or what??
  193. Inserting an event procedure
  194. How can I find character with ASCII code 160 in a string using VBA ?
  195. Disable commandbars in Excel 2007 - through VBA
  196. Un-protect sheet for specific user
  197. Send email with data depending on active cell...
  198. Delete Multiple cols in Excel VBA
  199. Simple question
  200. Lookup text if match found, paste it into the next cell
  201. Need to Import Data from Multiple Sheets into a Master Sheet
  202. Solved: Copy Next Column of Data
  203. Solved: How to refer to a cell in VBA
  204. copy and paste data to certain cells
  205. Assign value to read-only object
  206. Solved: VBA formula referencing cell in different worksheet
  207. disable OnTime macro before close file
  208. Extract data from website in an Excel Spreadsheet
  209. search
  210. Run-time error '1004': Copy Method of Worksheet Class failed
  211. [Excel2k3+VBA] Importing spreadsheet specs from Access Tables and Render
  212. [SOLVED:] Setup page from excel to word
  213. Table View In user form..
  214. auto hide empty rows within a software program
  215. Solved: Macro doesnt work with buttons
  216. CONDITIONAL FORMATTING CHALLENGE Change numbers to RED
  217. Solved: Need to Replace incorrectly spelled names, based on a list of before and after.
  218. Solved: sum(if..) until ..
  219. Comparing the values in two columns and highlight the values missing
  220. Need ideas on how to approach name entry validation.
  221. Solved: Worksheet formula in VBA
  222. Randomize blocks of range by column
  223. Solved: Using IF statement and Select Case statement
  224. Get Data From Closed Workbooks
  225. Get the Windows Login and Logout times
  226. Get the Count of Unique Values in a Column
  227. Retrieve the values
  228. Excel Cell Value Email
  229. Solved: Create a Text File
  230. My simple macro causes my excel to freeze up
  231. Solved: auto save in excel
  232. Imposing Fine
  233. [SOLVED:] Copy files runtime error 70 when trying to copy
  234. Solved: Variable .txt file import, Please help!
  235. Solved: Code Not Running after Adding If Statement
  236. Solved: Find column value in multiple sheet and copy Row to Summary
  237. Can vba do the printer setting?
  238. Solved: Why does creating activex button on sheet interfere with value stored in PrevCol var
  239. Solved: January to December based on Year
  240. Solved: #DIV/0! ERROR
  241. Copy Selected Filter and Paste to other sheet with different format
  242. creating a chart from a userform
  243. Solved: Validating columns using Formula or Select Case ?
  244. SQL Query in VBA without using the Access database of OLEDB connection
  245. Solved: output subtotals only to new sheet
  246. Calculate Group Totals
  247. Solved: Save Worksheet selection to PDF
  248. DTPicker giving time not date.
  249. Trying to store a refedit range into a cell
  250. Solved: VBA Run-time-error '424'