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

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