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