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. Delete Row sends Excel into an infinite loop
  2. Maximum size for a typical .xlsm file
  3. Solved: For next i help
  4. Dates and Days
  5. help please
  6. Calling macros
  7. sheet protection options
  8. Check if a shape is selected
  9. Editing in Word and saving in Notepad while controlling everything in Excel
  10. Unstable event code
  11. Convert workbook code to worksheet code
  12. Auto print last filled page
  13. Sum of column
  14. Effectively using Classes and Property Let/Get; referring to parent or sub class...
  15. Displaying missing values from 2 worksheets in another separate worksheet
  16. Solved: Deleting part of a merged cell
  17. Solved: Calculate Time Left
  18. Solved: Delete all info other than name on left side of cell.
  19. Login to yahoo mail.
  20. Solved: VBA code for checking possible combinations of 4 numeric digits
  21. copy folder WB to a one workbook
  22. Macro to drill into pivot table
  23. Automation error (Error 440)
  24. Solved: Pivot Table
  25. Dynamic Looping Help
  26. Help to disable popup calendar
  27. Filter Problems
  28. Solved: Enabled Button
  29. Excel VBA Coding for xls transformation
  30. Solved: DoubleClick event in a textbox
  31. copying a range from multiple csv files
  32. Solved: how fix it - vlookup in visible range (not invisible)
  33. Share workbook with digital signature
  34. Solved: Checklist compare
  35. Solved: Zero the negatives
  36. Effect of AND and OR operators on Type Long
  37. Append excel table into Access table on weekly or monthly basis
  38. Solved: To reflect latest data updated in a row range
  39. How to generate weekly/monthly reports from daily report using macros
  40. Changing Chart Titles
  41. Deleting empty worksheets in a workbook
  42. Copying a picture from a web page and pasting into Excel
  43. Solved: goal seek w/ value from another workbook
  44. interact with web page
  45. Compare 4 columns & find dissimilar
  46. Search Function Problem
  47. Round off Issues and more...
  48. Search data within the spreadsheet to log
  49. How to create the menu w/o the code as the attached file
  50. Function Help
  51. Solved: Data Validation: Combine Two Cells In Drop Down Only
  52. find with xlprevious not working
  53. Solved: Dissect result
  54. Search Date in Worksheet and Set Format
  55. Solved: 2003 Multibox Color fix
  56. help with vba code please
  57. Help with code
  58. Solved: Help Date's
  59. Solved: Red Font
  60. Copy data
  61. Problem with If...Then...ElseIf Loop
  62. custom format
  63. Solved: Import Web Data with HTML format
  64. timekeeping template
  65. Problem showing images in locked sheet
  66. Count non empty cells
  67. Getting Error when No visible Cells found. What to do?
  68. Macro to look at list in sheet1, if not in sheet2, pull in
  69. How to re-arrange the listcolumns?
  70. Reading Data and creating a table from it
  71. Textbox Userform: Autopopulate textbox from another textbox
  72. Solved: Lookup County
  73. Updating sheet automatically periodically
  74. Copying a range from a different workbook
  75. Height of Prina Area
  76. Drill into a Pivot Table using a Macro
  77. Data Validation code error
  78. How to destroy (de-filter) individual advanced filters in a worksheet?
  79. Macro vlookup with fill down
  80. Linking dynamically allocated row offset to stacked column chart data range variable.
  81. Solved: loop Error
  82. Solved:Looping a section of code
  83. Solved: Basic VBA problem with Format
  84. Solved: VBA to Excel Add-in
  85. Data Validation based on 2criteria
  86. Solved: Look excel range?
  87. Make a report with data taken from cells
  88. Solved: Delete Empty Cells
  89. Solved: Entering Value in Combobox with Dynamic Range
  90. cannot get rid of error message
  91. Why doesn't the xlcelltypelastcell not giving the last cell inside a list?
  92. Move files and ignore file extension?
  93. vlookup with input box to select a new month when run
  94. Set the values for .TextFileFixedColumnWidths in code
  95. Solved: concatenate cells in IF statements
  96. List Ranges with Missing Data in Column
  97. HTML table code
  98. Solved: Range Selection error
  99. Moving to Excel 2010 - worksheets.move compatibility
  100. Macro: Highlight Cell in Col B that DOES NOT exist in Col A
  101. Help Exiting Loop
  102. Combo box in Excel to query MySQL
  103. Unlock Blank Cells in Column G
  104. Advanced Filter Command Buttons
  105. Copying Characters to the Right of a Selected String in a .txt file
  106. Drop Down Validation Double Dependency
  107. How to password protect grouping?
  108. Solved: SUM Formula
  109. Cells that update automatically
  110. VBA Data Analysis Loop Problem
  111. Creating a list of variables
  112. Unhide bug
  113. Solved: Range matrix
  114. Solved: multiple interior.colorindex
  115. Solved: error handling failed
  116. Solved: Conditional Formatting Help :-)
  117. Solved: Range selection with array of ranges
  118. Solved: Cannot switch to an active excel workbook from word
  119. Code understanding
  120. Create worksheets from a list
  121. Solved: Find
  122. Tricking Sort Logic
  123. Convert UTC to local time with DST
  124. E-mailer from individual e-mail to 1 e-mail
  125. Solved: Setting wb.Name to string for VLOOKUP formula
  126. Solved: searching a word in lower and uppercase
  127. Replace Chart labels with Textboxs
  128. Question about vba programming
  129. how to search for a string in text file
  130. Solved: Shell and Wait Issue
  131. Solved: Stripping numbers from alphanumeric strings
  132. Solved: Delete Rows
  133. VBA code to hide rows
  134. Solved: Listbox1: Highlight Pre selected Item
  135. Copy Paste File Specified in Cell to Another Folder
  136. Confusing issue with Copying and moving work tabs
  137. Solved: Quick VBA Userform Pivot query
  138. Solved: Copy from one workbook, to another, keeping format.
  139. connetct own help file in excelVBA function addina
  140. Problem with .xlsm file adding code via VBA
  141. Solved: Strange Error in simple VBA macro
  142. userform filtered search
  143. Solved: Sumproduct with HLookup
  144. Solved: Find text in a cell,copy row and paste into new sheet
  145. How To Copy Paste File Named in Cell to Another Folder Named in Cell?
  146. RGB (R, G, B) to hex function
  147. VBA Code Freezing
  148. Need Help - Macro Not Working Properly
  149. Compare two spreadsheets
  150. Solved: VBA for updating every worksheet in workbook.
  151. Solved: Problem with more then one each.. for cicle
  152. Solved: Display the first word separated by comma in textbox
  153. Filling in IE form with values from Excel
  154. Solved: Strange problem when protecting/unprotecting sheets
  155. Solved: copy cells to column without blanks
  156. saving spreadheet to network drive
  157. Converting Matlab Code to Vba
  158. Why the Set temp(0) = Activesheet.Columns(3).insert is not working?
  159. VBA Help
  160. Solved: Workbooks.Open issue in Excel 2010 (Network Drive)
  161. VBA Excel Transpose all files in a folder
  162. Solved: Conditional Format 2 arguments; one of them is only a part of a cell contents
  163. Comparing string differences between two separate column of sheets???
  164. Merge first sheet of multiple excel file
  165. Solved: Userform Option Button Issues
  166. replacing characters in a column which occu at random positions
  167. Publishing Defined Names to single Htm page
  168. Expressing a " in an excel Formula as VBA code
  169. Solved: Filter and VBA
  170. Solved: VLOOKUP Code
  171. Solved: Allow Authorisation On 2 Computers
  172. Solved: Application.Countif - separate workbook
  173. Solved: VBA Copy
  174. save as with auto name
  175. Solved: Speed up an Array Formula in VBA
  176. Solved: UserForms: Passing inputs from one to another
  177. Reading values from a closed excel sheet
  178. Solved: making a list of the datasheet
  179. Sorting Options for Several Data
  180. Compare two spreadsheets-Macro
  181. Debugging Runtime Error '13' Type Mismatch
  182. Solved: MsgBox to list missing .references
  183. on each day, at 6am, the excel file will be opened by itself
  184. Macro Help: Replacement for cut and delete Speed wise
  185. Sorting sheets within a workbook
  186. Solved: rd_filename = Active.Workbook.Name
  187. Find cells within range equal to 70% of sum of total range
  188. Solved: select worksheet and display selected sheet in workbook
  189. Master Filter for Pivot Tables
  190. Solved: make VBA code shorter
  191. Problem with VBA script reading from MySql database
  192. Solved: Working on a not visible Worksheet
  193. String and Combox Question
  194. Solved: Not understanding Custom Icon Macro
  195. Return Types in Excel VBA
  196. Solved: Insert Row after Specific Text
  197. Solved: Runing a macro by clicking on a sheet
  198. Delete and Move a row in excel
  199. Automate Click, Save Close
  200. Make a simple report with VBA
  201. Solved: userform multiselect listbox - select item
  202. mutliselect listbox via looping a range
  203. Extract email out of changing string count
  204. controlling cell entries
  205. Solved: Re-calculating cells with unrecognized functions
  206. Copy text from Word and paste into Excel VBA
  207. Solved: Msgbox interrupts drawing on worksheet
  208. Solved: Separate generated password with dashes
  209. Cannot Insert Column
  210. VBA web queries - error 1004 "The site reports that the address is not valid"
  211. Solved: variable formular depending on number of work sheets
  212. SendKeyys command turns off Numlock
  213. Two Columns (Search and Copy)
  214. Comboboxes filling with for loop
  215. Declaring global Boolean variable?
  216. read/write to textfile
  217. Loop through all visible worksheets in excel
  218. On error resume next
  219. Is it possible to automate results from an access query into Excel?
  220. Using data collected in a module/ macro
  221. Solved: Variable dimension of a matrix
  222. Solved: Copy deleted info
  223. FileDateTime(pathname)
  224. find info in cells,delete cells with no info and paste to printsheet. then repeat
  225. Is it possible to do automation to control another application through vba code?
  226. Need help in event
  227. VBA code to import pdf as txt to Excel
  228. Solved: .Find not working between Workbooks
  229. Solved: PRICING GRID
  230. Copy WS to a Named WS values only
  231. Auto open file at fixed length of time
  232. Copying File issue
  233. Solved: Problem with ListBox
  234. Swapping Cells
  235. Solved: Problem with declarations and Str function
  236. Solved: Message Box Reminder
  237. Solved: Problem with cut/paste to last row of sheets
  238. right-click in textbox
  239. Solved: Start Counting when cell changes
  240. How to pick the random numbers from a set of numbers
  241. draw arrows
  242. Solved: Setting filters from a form
  243. Solved: Creation of Folders and Sub-Folder
  244. Insert picture in sheet + send range via email
  245. Solved: VBA to calculate last month
  246. Solved: Page Break
  247. How to Connect to an API
  248. Solved: Returning TextBox data to msgbox or cell
  249. Solved: copy first sheets from all work books in a file into a collective sheet
  250. Get Final URLS?