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. Prefix with "-" sign
  2. Solved: Fully clearing the used range of a worksheet
  3. code error going from xls 2000 to 2007
  4. Solved: Formula For based on blanks
  5. Solved: Count highlighted rows
  6. Change Tracking - possible without custom views?
  7. Need to reference multiple workbooks
  8. Get Key
  9. save as
  10. Solved: combobox populate
  11. VBA codes for skipping cells
  12. Solved: Compile Error of Duplicate Decleration in Current Scope
  13. find duplicates with different data and extract it
  14. Create New Workbook from existing Tab
  15. Solved: Find value, input into a different column
  16. [SLEEPER:] VBA-PERL via .bat
  17. Solved: Importing a .txt file without a user prompt
  18. Multiple Page Print Form
  19. Lots of small queries in a small database - performance problems
  20. Remove string before a certain character
  21. HTML save not working
  22. Help with VBA Excel project please!
  23. Solved: Remember Hidden State
  24. Change font for part of a cell
  25. Combining Multiple Workbooks / Worksheets
  26. Button Image
  27. Solved: save problem
  28. Controlling the number formats in a file
  29. VBA Forms Module Help please.
  30. EnableOutlining problem - It is driving me mad!!
  31. Solved: show very hidden
  32. application not visible flashes
  33. Help with small project for work please
  34. Looking for VBA algorithm for circular references
  35. VBA Excel macros
  36. Create PDF Stopped Working.... Help!
  37. User Form /COMBO BOX 1
  38. Solved: Workbook_Open loop??
  39. Solved: VBA Reference Protected Workbook
  40. Solved: go to vb studio?
  41. Solved: textbox line under the text
  42. Solved: Auto Unique List
  43. Userform to edit records in different sheets
  44. I would like code to show active workbook
  45. Solved: Specifying file location in a cell and referencing to that cell in VBA, ASCII of 0 to
  46. Solved: help with the first program
  47. Avoiding Variants
  48. Excel exported reports have problem
  49. Adding a column to highlight the changes while comparing two version of excel sheet
  50. Solved: Sum if or sumproduct help?!
  51. Solved: values in range
  52. Copying Autofiltered data, pasting all data when autofilter shows no data
  53. Solved: Create dynamic range to use in formula
  54. Hide rows with bold text
  55. Perform action only if mutiple criteria is met
  56. Solved: call windows printers
  57. Sending Email in Excel
  58. VLOOKUP in VBA
  59. Combining mutiple excel files
  60. Copying certain cell on condition
  61. Searching many sheets for data
  62. Using name manager
  63. Solved: displaying certain line of text from notepad
  64. displaying certain line of text from notepad
  65. Trouble with Grouping
  66. Solved: ListBox1.RowSource for visible Rows.
  67. copy cells from one sheet to another
  68. moving folders based on a criteria
  69. Text To Columns VBA
  70. Solved: Form run time
  71. Creating Text Files from excel each row
  72. HOW TO OPEN EXCEL ADD-INS IN TO VIEW CODES
  73. VBA Coding: Font Change
  74. export worksheet to a txt file
  75. Copy rows to new tabs based on value in 1st column
  76. Solved: Cut and Paste cell value between 2columns based on criteria
  77. VBA code for comparing a worksheet with a column and show the result with a color
  78. QR Codes for Excel 2003 XP
  79. insert range of cells if data in column doesn't match
  80. Copy and Paste Problem
  81. Workbook_BeforeSave
  82. Solved: VBA to auto email report
  83. run macro automatically based on criteria in other spreadsheet
  84. Fixed/non volatile date function
  85. Copy between sheets
  86. Solved: average offset rows in a column
  87. Macro to update Sheet2 based on Sheet1
  88. Indentify column references for cells that meet criteria and assign them to variable
  89. Solver VBA reference in non-english Excel
  90. Solved: textbox focus
  91. combobox one last push
  92. create log for entire file
  93. Solved: I have exceeded Excel’s limit of 1048576 rows while importing data from a file
  94. Timeformat Sum Up and Separation Based on Conditions
  95. Cell reference copy in another cell without link and formula
  96. Object required error with VBA rows deleting
  97. Formula solution for repeated search in column
  98. Solved: Copy selected range in autofilter
  99. Insert the name of the worksheet in cell and than link the cell to another worksheet
  100. Count If
  101. Update powerpoint from excel macro
  102. Excel VBA Macro Crashing
  103. Solved: if & vlookup formula : help requried
  104. Disable alert message
  105. pulling data from multiple worksheets
  106. Select Case Function
  107. problem inserting formula with R1C1
  108. Run Time Error 7
  109. UserForm_Terminate
  110. Sub / Function recorder
  111. New project
  112. Spreadsheet data management
  113. Solved: Find and Replace for Time
  114. Do Loop with InputBox and ActiveCell Ref HELP!!
  115. Solved: AutoFill TextBox in UserForm
  116. Sleeper: Highlighting Cell in Variant
  117. Solved: web navigation
  118. looking for an Event that fires when an existing Workbook is opened
  119. Opening Excel file and running macro
  120. How to save filename with -v2 -v3 and so on at the end if file name already exists
  121. Solved: Turning multiple quantities into singles
  122. Referring to excel application
  123. Solved: Trouble looping through ranges with non-adjacent cells
  124. Automating calculations between values on 2 separate worksheets
  125. VBA knowing which cells it has filled?
  126. Combine "if" formula : help required
  127. Bulk Copy / Pasting
  128. Automatically fill cell when data entered in another sheet
  129. Macro crashing excel
  130. Please help me find out the data link of the website
  131. Subtracting Values of Range Variants
  132. Status Bar or Progress Bar
  133. Solved: Concatenation of many cells from another workbook as a “block text”?
  134. Filtering the values and removing the duplicates
  135. Solved: OLECMDID_SAVE or SAVEAS pvain pvaout
  136. Parsing an RFP Word Documnet to Excel
  137. help with code please for arrays
  138. Reset MOST of Worksheet with Macro
  139. Graph in VBA
  140. auto save workbook upon close
  141. Solved: filter bloks
  142. Solved: ChangePivotCache - PivotCaches.Create Problems
  143. How to Loop through columns in an Array and write to a range
  144. Add additional data to word document's bookmark in excel
  145. Solved: Subtotal() generates extra lines
  146. File Copying From/to different Folders
  147. Solved: Downloading File issues - Buffer Length invalid or not enough memory
  148. Text to Excel VBA
  149. How to show save as dailog box
  150. Solved: macro to read a cell and subtract a number?
  151. How can I display a list of folders and files in window?
  152. error when puting more than 1 string
  153. Help on Extract portion of string in the right way
  154. need to help: mid function
  155. Move data from Excel 2007 to Access 2007 using VBA
  156. Copying last value of a column
  157. Impoting excel sheet to new workbook
  158. date help
  159. Solved: If values in row cut/paste
  160. If the selected cell does not have a comment, then insert a comment.
  161. Ways of declaring arrays
  162. Changing Multiple For Each Statements Together with Next - VBA
  163. Solved: leave the ActiveX text box, pressing 'Enter'
  164. Data Feed to Excel using XML from a website
  165. Formating prob
  166. Select dates by current month
  167. first post....
  168. Unable to get the Vlookup property of the WorksheetFunction class
  169. VBA Nested Lookup as a UDF
  170. Solved: VBA count files funtion
  171. Solved: How to repeat a procedure/code a number of times
  172. Solved: Return which control triggered an AfterUpdate event
  173. Autonumbering invoice then saved to another worksheet in the same workbook
  174. HTML Source Code from Safari/Mozilla on mac
  175. Build a tree of called functions / procedures
  176. Adjusting array of values for filtering for actual values in sheet
  177. Saving file
  178. VBA for Updating Pivot Table report filters from a OLAP Cube
  179. Form Display stops at FormName.Show - Why
  180. Solved: Whenever cell is added will be recorded on another sheet with date and time and value
  181. Copy a cell from excel to word and aligning center using VBA
  182. how to make add-in load before workbook
  183. HTML Source from IE
  184. Solved: Delete Rows with Condition
  185. excel 2007 cell context menu question
  186. Solved: Array Not Working
  187. Solved: Get Textbox Value
  188. Help with macro to update text on shapes
  189. Solved: Select the cell with the click of a mouse, and have the result of calculation
  190. Solved: How to get Last Key or Key-Combo Pressed (Not Event)
  191. Solved: Moving files from different source folder to different destination folders
  192. Solved: Parsing Addresses
  193. Help with Macro and Object Variable
  194. Pull info from one Active Workbook and Save in Another
  195. Solved: If wb is open give message
  196. exe
  197. UK National Insurance Number Validation
  198. data conversion
  199. Solved: VBA to create a separate sheet for each month
  200. Right click option menu...specific items
  201. Invoice Processing
  202. Input difference words run difference macro in one textbox
  203. Open XML file in Notepad and delete all "-"es
  204. Solved: Hiding columns
  205. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
  206. display worksheet data in user form
  207. Convert sub to function - prompt not appearing in formula bar
  208. Solved: Print pages that contain data
  209. Solved: Increment Formula With If Statement
  210. Boost Macro running speed
  211. group data
  212. [SOLVED:] Removing Duplicates for Multiple Columns independently
  213. Solved: Report to collect filtered data from multiple sheets and consolidate
  214. Hide columns based on cell value
  215. Copy from one worksheet and save to another
  216. Solved: Lastrow +
  217. Validating more than one textbox for Null values
  218. Solved: Sum particular data
  219. Solved: Simple VB? Take one file and make many
  220. HTTPS GET REQUEST ***HELP***
  221. Passing variables
  222. VBA code to send excel sheet as PDF
  223. Combining MsgBoxes into one box
  224. Userform limit?
  225. Solved: how to make shipping label with picture
  226. Find 1st Empty Cell in Range
  227. Formating (pivot)
  228. Want to create a variable that references a cell
  229. How to copy and paste the date
  230. Force ontime Macros to run one after another instead of simultaneously
  231. Solved: Move to Next Record
  232. Solved: Moving cell values based on specific criteria
  233. VBA code for Cursor to stay Stationary in one cell
  234. Automatic Calculation when sheet tab clicked
  235. SaveCopyAs not working.
  236. Urgent VBA Debugging help
  237. Concatenate string with itself in a "while" loop
  238. MultiPage in UserForm
  239. How can I change part of my title by referencing a value in a cell?
  240. Create Desktop Shortcut - Change Icon
  241. Flag on birthday calendar
  242. Solved: Macro request: Copy rows that match values in a column of names
  243. excel 2010 windows 7 64 bit hangs fooooorever
  244. Saving a file vy referencing a cell and using RDB Create
  245. Solved: Round down to nearest 5,000
  246. Solved: Cell value = #NUM!
  247. Solved: Code wont run in certain modules
  248. Solved: UserForm with ComboBoxes and TextBoxes
  249. Loop to Copy Text From Excel to Powerpoint Text Boxes
  250. Solved: How to activate the cells by using VBA