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. Send to DB code change
  2. combobox update
  3. Solved: Run Macro against a non-active sheet
  4. Turning an Array into a String and Vice Versa
  5. define last value in filter criteria
  6. ODBC to Access from Excel problem
  7. Google rank in excel
  8. Is it possible to avoid compile errors programmatically?
  9. Need to split a 6 digit number
  10. Solved: Macro not working correctly for different user
  11. calender where the date colors change
  12. Solved: Clear worksheet except for Row 1 Macro
  13. Solved: Call a function from personal.xlsb
  14. adding submenus to a drop down menu
  15. Working with hidden rows
  16. mqasimalihot - What are you up to?
  17. Very easy VBA problem!
  18. Making my full macro much faster
  19. Solved: Force save different name on WB open or save
  20. Solved: Change worksheet value to ensure data integrity
  21. Solved: Restrict mulilpe entries is N/A or No error is selcted
  22. Solved: If Statements
  23. Solved: Whole Numbers
  24. Comparison formatting
  25. Advanced Filter
  26. Solved: Compare two columns
  27. Problem with ' in filename
  28. Efficiency
  29. IF Date falls within a Month - Help!
  30. Combo Box - How???
  31. [SOLVED:] Troubles with Counting Used Rows
  32. UserForms and Public Vars
  33. Solved: Excel freezes when code to add reference runs
  34. Worksheet_Change Query
  35. What is Application.Calculate
  36. VBA code to convert xls to PDF
  37. Solved: Mass Mailing Macro for excel and office 2007
  38. Sleeper: Editing a macro to display 0's next to a name
  39. Solved: Loop Through a UserForms Controls and Change TextBox Properties
  40. 2007 Chart not updating
  41. There has to be a faster way.
  42. Script to paste only values in cell- Excel
  43. Dynamic Field:= in Autofilter
  44. Solved: Loop through All Worksheets to remove Autofiler & Freeze Pans before close
  45. Solved: how to hide sheets for posting
  46. Paste selection to the first blank cell in a column
  47. Solved: Unwanted Microsoft message
  48. Solved: Routine to replace all cells with gibberish
  49. UsedRange
  50. Solved: Simplify this listbox code
  51. Cells Formatting for DATE
  52. Solved: size of sheet
  53. FTP Upload Advice
  54. ADO Recordset FetchComplete Event
  55. How to customize KBase sort routine?
  56. Solved: Syntax error
  57. Solved: multiple column vlookup
  58. Average of a Count in Pivot Table?
  59. Solved: Resize with Vlookup Help
  60. Digital signatures gets removed on a shared workbook
  61. Walking Through Many Subdirectories, Many Workbooks, Many Worksheets
  62. Define variable from cell value, append, and embed images.
  63. Required fields, validate on save
  64. Internet Explorer Automation Wait for HTML Tag to appear
  65. Send mail and avoid security message pop up
  66. Teaching coworkers excel basics
  67. Sleeper: Macro Slowdown due to Multiple Processes?
  68. Solved: List Box not linking!!!
  69. Solved: Restrict download area
  70. Chart data based on user input
  71. Solved: Invalid or Unqulified Reference
  72. Solved: Copying & Sorting
  73. Solved: Goalseek error
  74. Apply query to Recordset
  75. Solved: Embedded controls
  76. User Form
  77. Alter Code to show value in column 'A"
  78. Solved: Excel workbooks as a Database
  79. Problems with referencing a .xla file
  80. Solved: Import CSV & Ignore Items With No Text Qualifier
  81. Copy Autofilter Items
  82. CANNOT MADE CODE WORK
  83. Max and min values
  84. UPDATING NOW() AUTOMATICALLY
  85. Iterative copy paste problem
  86. Sleeper: Excel Solver Question
  87. Solved: Greater, Less than formula
  88. Help to enable VBA in excel 2007
  89. vba to automatically hit a key on the keyboard
  90. Code to show if cell interior colour is red
  91. Solved: paste value for filtered data
  92. Pivot table defaults
  93. Running Delete Row Code For All Tabs In A Spreadsheet
  94. Solved: remove signs (wildcards) from a string
  95. Solved: rename folder
  96. Help With/Code To Enable Macros . .
  97. count matching cell colors
  98. Solved: Need Windows Login of User who changed the data
  99. Or Function
  100. filter by dates
  101. Sender in VBA?
  102. Problem using "range.find" in VBA
  103. Solved: Lect combobox item, display wksheet name in listbox
  104. ftp upload
  105. Random Sampler
  106. Solved: separate rows with blank rows
  107. Need a macro to copy data to main file
  108. Solved: How to capture position info of a cell
  109. VBA help - code to loop through a certain folder structure
  110. Solved: Set Print Area - Last Row/Cell Used
  111. VBA cannot activate cell after first loop
  112. Solved: Excel Userform textbox's
  113. Solved: Adding a Treeview control to a Userform
  114. excel template error handling
  115. Get CSV from a PHP script on a server (mysql 5)
  116. UDF causes other macro to fail w/ err 1004
  117. find next blank row and input information from form
  118. Best Way to Loop Through Range?
  119. automatic spell check on open fields in protected document?
  120. get last cell value and add 1 for next number
  121. Solved: Set column width in pixels
  122. Pull out the values which are not Unique
  123. What is PERSONAL.xlsb??
  124. Auto Scale Chart Font in Excel 2007
  125. Removing HTMLCheckboxes
  126. Solved: Excel 2007: Bypass Workbook_Open Code
  127. Why is this ElseIF not the same as this Select Case?
  128. Autofilter On One Column?
  129. Copying from one file to another
  130. VBA
  131. Excel to PDF
  132. VBA
  133. Change cell color to color of adjacent cell
  134. Solved: repopulate formulas
  135. Solved: positioning a Chart
  136. Excel generate a task in Outlook
  137. Find all xls files except one subfolder
  138. Frequency function and open intervals
  139. retentive variable
  140. To random_noise
  141. Solved: Need help with toggle button
  142. Working with Charts
  143. Finding a Value
  144. Find the next date in column
  145. populating combobox at runtime
  146. Error: Excel cannot complete task with available resources???
  147. Solved: Text-to-column but right to left
  148. Error Copying Data
  149. Checking Tab Names
  150. Import Address Book from Outlook
  151. [SOLVED:] Solved: Selectively copy ActiveCell onChange
  152. Solved: Save as & file name\path problem
  153. Solved: vlookup with multiple criteria
  154. Solved: Filtering records older than one year ago
  155. Solved: Date formula in vba
  156. detect more than one border color along single edge of range
  157. Trendline data/info
  158. How to access the methods of .xla from VBA?
  159. copy & paste
  160. Solved: script to copy multiple cell values into one cell
  161. [SOLVED:] Shifting rows to a worksheet depending on a cell value
  162. userform apply code after userform end
  163. Will deleting defined name delete data??
  164. Removing pictures
  165. Deleting words in a string
  166. Validating Textbox's on Worksheet using Class Modules`
  167. Group and filter the data
  168. Solved: accidently save over file
  169. Insert Chart Help Needed
  170. Hidden Module?
  171. Column values based on entries on another sheet
  172. Solved:
  173. Solved: VBA userform
  174. What Does This Mean??
  175. conditional formatting based on date?
  176. time sum
  177. Solved: run DOS command without waiting ?
  178. Solved: Extract Text to columns
  179. SeriesCollection by name
  180. Solved: Deleting / Reordering columns in a Worksheet
  181. Solved: .formula not working with Excel
  182. Vanishing controls...
  183. Solved: Working with Shapes
  184. Code to copy and insert rows
  185. Pulling folder content file info into worksheet
  186. Solved: Check date & compare to another date
  187. Excel to SQL Server
  188. Query Table in Excel
  189. Faster method for VLOOKUP
  190. Solved: Sending Copy of WorkSheet from 1 Book to Another
  191. Solved: all caps combo box
  192. Highlight Row Based on Cell Value
  193. Highlight cells that did not match
  194. Solved: Bar Chart doubt
  195. display range value in message box
  196. [SLEEPER:] Automatically populate userform from row selection in excel
  197. Input more than 15 digits numbers in a cell in a worksheet
  198. How to Calculate Tax from Net Amount--Help
  199. [HELP] Merging all the details of the work book in one sheet.
  200. Problem with ComboBoxes (control toolbox ones)
  201. need some code to move items into new sheets
  202. Excel to PDF
  203. Solved: search next value with textbox
  204. TAB Name
  205. Extra Information alongside Pivot Table
  206. Excel chart in PowerPoint
  207. Solved: Regression Analysis macro
  208. [SOLVED:] Trying to get Code to run in excel 2007
  209. Solved: search next value with textbox in other sheet
  210. First date in week from <WeekNo, Year>
  211. [SOLVED:] Order an array from the smallest number to the biggest
  212. Format Cell For Time
  213. Fairly simple problem
  214. Survey in Excel using Visual Basic Need to edit!
  215. Dynamic pivot charts using pivot table
  216. Is this something that I can do in VBA?
  217. Speed up loop?
  218. update procedure in excel file from personal.xls
  219. Open Template with file picker
  220. Limit amount of rows formatted
  221. "INDIRECT" worksheet fuction problem
  222. Solved: Return default save path for an excel add-in
  223. string manipulation problem
  224. Solved: I'm having trouble selecting a range
  225. Solved: BeforeDoubleClick Issue?
  226. Solved: count all equal combinations
  227. Calculating An Average
  228. Solved: Combine Data into one Cell
  229. Drop down List
  230. Summing Similar Conditons
  231. Help uploading excel cells into website
  232. Inserting a Range on a Chart as TextBox ?
  233. Count Files in Several Folders
  234. Solved: Auto fit columns in whole workbook
  235. Formula to Prevent a higher % to be entered...Help
  236. [SOLVED:] Open access and run macro in access
  237. Date Format
  238. Solved: Text To Columns - passing FieldInfo value as a string
  239. run code from personal.xls
  240. Solved: Code Amend to OK Msg Box Before Close
  241. Write to a text file
  242. Conditional formatting
  243. Solved: make visible based on value
  244. modify nextrow code
  245. Error Msg: MS Office is waiting for another application to complete an ole action
  246. 2007 Pivot Table Conditional Formatting macro problem
  247. Can’t Find Project on Library . . .
  248. Transform data to Columns
  249. Image Popup when mouse arrow is on Button
  250. Runtime Error 5: Invalid procedure call or argument